Hans Karlsen (talk | contribs) No edit summary |
Hans Karlsen (talk | contribs) No edit summary |
||
| Line 5: | Line 5: | ||
/// If this variable is found in a seeker - it controls what the search shows , on what page it is - vSeekerResultCount/vSeekerPageLength | /// If this variable is found in a seeker - it controls what the search shows , on what page it is - vSeekerResultCount/vSeekerPageLength | ||
vSeekerPage | ''vSeekerPage'' | ||
/// The number of pages is set by the search logic for you to use, add variable and use type integer | /// The number of pages is set by the search logic for you to use, add variable and use type integer | ||
vSeekerPageCount | ''vSeekerPageCount'' | ||
/// The number of items you want on a page | /// The number of items you want on a page | ||
vSeekerPageLength | ''vSeekerPageLength'' | ||
/// The count of the sql query is set by search logic - you must add a variable of this name of type longint | /// The count of the sql query is set by search logic - you must add a variable of this name of type longint | ||
vSeekerResultCount | ''vSeekerResultCount'' | ||
The Autoforms construct seeker that make use of paging - refer to an autoform generated seeker to see details. | The Autoforms construct seeker that make use of paging - refer to an autoform generated seeker to see details. | ||
Currently this | Currently this available in the WPF-client and '''Angular-Turnkey-client (new 2020-Aug)'''. | ||
For letting the framework know which grid on the page that handles your search result you must also add the tagged value IsSeekerResultGrid=true on the Nesting of your grid - again this is done by the AutoForms seekers. | |||
==== Same explained with other words ==== | ==== Same explained with other words ==== | ||
| Line 32: | Line 34: | ||
If there a X pages available you control what page is actually fetched from db by setting a value in vSeekerPage between 1 and X prior to search. | If there a X pages available you control what page is actually fetched from db by setting a value in vSeekerPage between 1 and X prior to search. | ||
Even if the UI is not generated today - you can easily add "next" and "prev" buttons that change vSeekerPage by +/- one and do selfVM.Search. | <s>Even if the UI is not generated today - you can easily add "next" and "prev" buttons that change vSeekerPage by +/- one and do selfVM.Search.</s> UI is now generated in both WPF and Angular. | ||
a.k.a Seekmore, seek more | |||
Revision as of 15:03, 4 August 2020
Using the multivariable seeker to search the database you can configure the seeker to return the number of search result pages if the search does not fit within the MaxFetch setting.
To set this up the seeker logic looks for a set of known variable names to communicate the results in:
/// If this variable is found in a seeker - it controls what the search shows , on what page it is - vSeekerResultCount/vSeekerPageLength
vSeekerPage
/// The number of pages is set by the search logic for you to use, add variable and use type integer
vSeekerPageCount
/// The number of items you want on a page
vSeekerPageLength
/// The count of the sql query is set by search logic - you must add a variable of this name of type longint
vSeekerResultCount
The Autoforms construct seeker that make use of paging - refer to an autoform generated seeker to see details.
Currently this available in the WPF-client and Angular-Turnkey-client (new 2020-Aug).
For letting the framework know which grid on the page that handles your search result you must also add the tagged value IsSeekerResultGrid=true on the Nesting of your grid - again this is done by the AutoForms seekers.
Same explained with other words
When paging is turned on (define the variables above to turn it on) we will first execute the query with "select count(*) ...." to get the total count of hits in the db - this value is assigned to variable vSeekerResultCount.
You should set a desired page length - or expose this to your end users in the variable vSeekerPageLength.
The total number of pages available after search is then vSeekerPageCount:=vSeekerResultCount/vSeekerPageLength
If there a X pages available you control what page is actually fetched from db by setting a value in vSeekerPage between 1 and X prior to search.
Even if the UI is not generated today - you can easily add "next" and "prev" buttons that change vSeekerPage by +/- one and do selfVM.Search. UI is now generated in both WPF and Angular.
a.k.a Seekmore, seek more