Hi Dilhansa, This query should be lucene query. Please refer [1]. Do you have data published and indexed in DAS? If so, first you can check whether your query is giving results from DAS data explorer. Please refer 'Searching by a query' section in [2].
[1] https://docs.wso2.com/display/DAS301/Query+Language+Reference [2] https://docs.wso2.com/display/DAS301/Data+Explorer#DataExplorer-Searchingforrecordsofatable On Fri, May 27, 2016 at 9:33 PM, Fathima Dilhasha <[email protected]> wrote: > Following are some variations I tried out. > > > - > > String query = "SELECT * FROM " + tables.get(i) + " WHERE " + columnName + > " = " + year + ";"; > > - > > String query = "SELECT * FROM " + tables.get(i) + " WHERE " + columnName + > " = '" + year + "';"; > > - > > String query = tables.get(i) + " : " + "SELECT * FROM " + tables.get(i) + > " WHERE " + columnName + " = " + year + ";"; > > - I tried to use a 'PreparedStatement' as well. But that requires a > database connection. > > Any help is appreciated. > > On Fri, May 27, 2016 at 5:54 PM, Fathima Dilhasha <[email protected]> > wrote: > >> Hi, >> >> I'm trying to call "*search(int tenantId, String tableName, String >> query, int start, int count)*" in *"org.wso2.carbon.analytics.* >> >> *api.AnalyticsDataAPI".* >> The query I'm using is as follows. >> >> String query = "SELECT * FROM " + tables.get(i) + " WHERE " + >> columnName + " = " + year; >> >> The error is as follows. >> >> >> *[2016-05-27 17:45:45,152] ERROR >> {org.wso2.carbon.analytics.dataservice.core.indexing.AnalyticsDataIndexer} >> - Error in index search: Invalid query, a term must have a >> fieldjava.lang.RuntimeException: Invalid query, a term must have a field* >> >> I did various changes to the above mentioned query and tried out. But it >> still gives the same error. >> Am I doing something wrong? >> >> Thanks. >> Dilhasha >> >> -- >> Fathima Dilhasha >> *Software Engineer* >> Mobile : +94 (0) 771663314 <%2B94%20%280%29%20773655496> >> <%2B94%20%280%29%20773%20451194> >> [email protected] <[email protected]> >> > > > > -- > Fathima Dilhasha > *Software Engineer* > Mobile : +94 (0) 771663314 <%2B94%20%280%29%20773655496> > <%2B94%20%280%29%20773%20451194> > [email protected] <[email protected]> > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Thanks & Regards, Inosh Goonewardena Associate Technical Lead- WSO2 Inc. Mobile: +94779966317
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
