Hello all,
I need help for this scenario.
On the home screen there is a search input text and below there is a gallery based on 'Field Changes' table. People search in the input box with Name, WorkOrder ( lookup column from table 'SAP Work Order') etc fields and gallery is filtered based on the text input search.
Now recent enhancement added. New many to many relationship is created with 'SAP Work Order'. Now business users asking to enable search for many to many as well.
For example below items in 'Field Changes' table:
| Name | Work Order No (N:N) |
| 1001 | 3565 3566 |
| 1002 | 3565 3567 3568 |
| 1003 | 4041 4042 |
When user searches with '3565' , the gallery should show items 1001 and 1002.
Any idea how to achieve this??

Report
All responses (
Answers (