How to:

1. See Only Screen FetchSQLPaging (Forget Screen PageMeRibet and Screen PagingIboxIniyangGampang - they are another more complex ones)

2. Open Server Action FetchMe

3. Create Advanced SQL for Total (Count): sqlmeTot

4. Create Advanced SQL for detail: sqlme

5. Create also list of each sql output

6. Remember Pagination Widget to use: startindex, Maxrecord,

total rows

7. On Navigate: set startindex, refresh data

8. On Sort, new OnSort Action and GetSortByWithoutEntity Action(to remove the entity part of Sort By to be used in the Advanced SQL)

9. When there is filtering, reset the startindex to 0 and refresh the data (see client action Input_TextVarOnChange)

10. That's It!