P
peggycole
Guest
Hi, We are developing a new website with Kendo UI and JSDO's. We notice a problem when sending a ablfilter to the back end if we want to search with the contains functionality. The progress.all.js we use ( https://github.com/CloudDataObject/JSDO/blob/master/lib/progress.all.js ) composes the ablfilter with the index-function but in OpenEdge the index function is not the same as the contains function so our queries are not using the available word indexes (instead we would have some bad query performance). So this is what we receive at the back end: {"ablFilter":"(nad_obj = '31557015,0421' and orgcy_obj = '14490001,0421' and INDEX(search_param, 'WMSAR.WMSAR_Article_Number!colormax') > 0)","tableRef":"tUniqueArticle","viewTables":""} And this is what we were expecting (and would work with the current back end): {"ablFilter":"(nad_obj = '31557015,0421' and orgcy_obj = '14490001,0421' and search_param contains 'WMSAR.WMSAR_Article_Number!colormax')","tableRef":"tUniqueArticle","viewTables":""}. Does somebody know how we can establish this? Is there somewhere another version of progress.all.js available we can use that includes this functionality? Some other facts (may be not relevant): OpenEdge 11.6, use of business entities, via appserver (not pasoe) Kind regards, Peggy
Continue reading...
Continue reading...