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

skumar over 8 years ago

Hi,

We're using legacy forms in one of our applications. This form has a paging grid that allows user to select a record to edit.
The data that we're displaying has following fields:

Person
- aid (Primary Key)
- First Name
- Last Name
- Email (Unique Key)
- Company

Whenever we select a record, it returns the row number of selected record instead of returning "aid" which is the primary key of our CDT.

How can we achieve this ?

Thanks,
Sandeep

Discussion posts and replies are publicly visible

Parents

0 sikhivahans over 8 years ago

@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)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 8 years ago

@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)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data