Get selected rows when a list page opens with all records

(0) Share

Report

Posted on by Community Member

I am new in Business Central. I have a contact list form opens on a page OnDrillDown, a user selects multiple contacts from the list and the selected contact email addresses are populated in DrillDown field in the text form. Now when the user again opens that contact list page, I want those previously selected rows selected on the page.

I am passing that selected list of contacts to the list page OnAfterGetRecord() trigger, applied for loop and compared current record number with the selected list of contacts and then filtred and marked But only first one record is shown on the page and not selected.

Can somebody help me with this??

Categories:

Other

I have the same question (0)

All responses (7)

Answers (0)

Hannes Holst 5,767 on at

Like (0)

Report

Hello,

An integration like you are describing is not supported by BC.
You are describing a 1:N relation which does make other approaches necessary.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks, Hannes for your quick reply.

You mean that something like I want, cannot be implemented in BC?

Was this reply helpful? Yes No
Hannes Holst 5,767 on at

Like (0)

Report

Hello,

Yes - BC is designed based on the relational database concept.
For your requirement, normally you would have to create a new Table that links the primary contact with the other contacts.

Like this:

Primary Contact No. Related Contact No.

CT001245 CT009965

CT001245 CT008844

CT003455 CT009133

Or, as an alternative, you could store the "Primary Contact No." directly in the records of the related contacts (using a new field).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks but I was trying to do it without creating a new table because I don't need to save those selections anywhere. I just want to map that selection on the list page.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Can someone else help me with this? ASAP

Is there any other solution except Hannes Holst provided. This is a solution but I don't want to implement this way

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,672 Moderator on at

Like (0)

Report

Maybe currpage.SETSELECTIONFILTER can help?

docs.microsoft.com/.../setselectionfilter-function

Was this reply helpful? Yes No
Romryan on at

Like (0)

Report

Did you get the solution on this?

Was this reply helpful? Yes No