Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Find a record in the g...
Finance forum

Find a record in the grid of the form which has dynamic tables as datasource (multi-select lookup)

(0) ShareShare
ReportReport
Posted on by 288

regarding my old question, I have been customizing D365 multi-select lookup to let users edit selection by the keyboard. 

I want to find a record in the grid of my custom lookup window. A user enters words with ";" separator then we should find the related records in the grid.  As can be seen in the below picture user types issued in the control of the form.  what I want is to find record which contains Issued.

7750.PNG

this entered word is always in the first column of the grid. Because the value of the selected record in the lookup window is always the first column of the record which is shown in the control. 

8117.PNG

The data source behind this form is Common and just store RecId, TableId and dataAreaId. I am not able to access directly to the field with user-entered value unless I traverse all datasources and their fields which are in the query. This query is the one we construct for lookup data.

So for clearing the issue, imagine that we have a form which data are created based on the dynamic datasources. (for instance, see buildDesign method in class SysLookupMultiSelectGrid). How can I search a field in the table behind the form and find the related record Id?

P.S  the query which is inputted as an argument to the lookup method can consist of multiple tables.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Featured topics

Product updates

Dynamics 365 release plans