Hello All,
I am building an application using UI Builder and facing some difficulty retrieving and displaying search-based results(I am trying this on my custom tables say x_my_customer_table)).
I tried using the Lookup Record data source. When I provide a Number field, I’m able to retrieve and display the corresponding result successfully. However, I’m trying to implement a use case where a user enters a name, for example, “Alex Down,” and only one matching record is returned for display.
Unfortunately, I’m unable to set a query filter on the Lookup Single Record data source, as it only accepts the Number field. On the other hand, when using Lookup Multiple Records, I am unable to dynamically set the query — something seems to be missing.
Any insights or suggestions would be greatly appreciated.
James.
