Hi, We're using legacy forms in one of our applications. Th

UPDATE:

We're using todatasubset() method to display data into paging grid

@skumar So far I remember, in the paging grid component, todatasubset() retrieves the index whereas a query rule retrieves the primary key. I would like to suggest to make use of a query rule and check the results.

@sikhivahans

I agree with your point. To be more specific with our business logic, we're performing a filter kind of thing on the fields. Below is the sample code of what we're trying to do:

if(or(isnull(ri!search_text), len(trim(ri!search_text)) = 0), rule!get_all_persons(a!pagingInfo(1, 10)), todatasubset(union(rule!get_persons_by_first_name(ri!search_text), rule!get_persons_by_last_name(ri!search_text), rule!get_persons_by_company_name(ri!search_text), rule!get_persons_by_email(ri!search_text)), a!pagingInfo(1, 10)))

if search_text is given, the resulting datasubset has identifiers range from 1 to 10 instead of the primary key values of the query data.

@skumar May I please know the version you are working on?

7.9

@skumar Probably you may try something as follows, not sure how it behaves as I didn't test:
if(
\tor(isnull(ri!search_text), len(trim(ri!search_text)) = 0),
\trule!get_all_persons(a!pagingInfo(1, 10)),
\twith(
\ tlocal!inititalResults:union(rule!get_persons_by_first_name(ri!search_text), rule!get_persons_by_last_name(ri!search_text), rule!get_persons_by_company_name(ri!search_text), rule!get_persons_by_email(ri!search_text)),\t
\ trule!get_persons_by_aid(local!inititalResults.aid,a!pagingInfo(1, 10))
\t)
)

@sikhivahans Thanks a lot for the suggestion. It works

You can also define the datasubset entirely manually using a!dataSubset() - this gives you the opportunity to define your own identifiers.