HI All, I have a requirement where we need to implement pagination. My webapp uses extJS as front end and they are implementing infinite scroll.
As the user scrolls down, a service request is sent to get the next page and extjs doesn't have an option to selectively retrieve the last record to use paged queries as explained in Phoenix website. Requirement is like i have to two texts to search in two different tables. but i need to select only one table records in a paged manner. The two tables are having common field EL_ID. Currently i am using a query like below: SELECT * FROM ELEMENT WHERE EL_PARENT_ID IN (select EL_ID from ndm.element where el_id NOT IN( select EL_ID from element where el_id in (select AE_ELEMENT_ID from ATTRIBUTE WHERE AE_ATTR_VALUE = 'text2')LIMIT 100) AND el_id in (select AE_ELEMENT_ID from ATTRIBUTE WHERE AE_ATTR_VALUE = 'text2') and el_name ilike '%text%' LIMIT 200); The issue with above query is that phoenix is retriving the results of first pages in every other subsequent page which is not correct. I dont know if I am doing it wrongly. So, any help would be great. please let me know for any questions or clarifications. Thanks, Satya
