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 skumar over 8 years ago

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

Sign in to reply

Verify Answer

Cancel

Reply

0 skumar over 8 years ago

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

Sign in to reply

Verify Answer

Cancel

Children

No Data