Dynamic query for field reference in UI page

[dgovindhara]

Hello Team,

         we have two reference fields called category and subcategory. Subcategory should set lookup filter based on category selected by user and it is working fine. After setting category, trying to do search by writing in field subacetgory, it is showing all the results irrespective of category.

could you please help us out to fix the issue?

Thanks in advance

[Ankur Bawiskar]

@dgovindhara 

if both the fields are reference type on UI page then I have shared something similar solution earlier

see that and enhance

Change ui reference query 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[dgovindhara]

Using this solution, I am able to see filtered results when i click on magnifier icon of that reference field. but not filtering when i type something on that field

[Ankur Bawiskar]

@dgovindhara 

Glad to know that my approach worked for you to filter the records.

that's the OOTB behavior with reference fields in UI page, we can't do anything there.

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏