add prepareData method for global setting query