We are using 'AJAXTableCompleter' in ui_reference in a UI Page. But unable to search records for the specified columns.

[Ritika Saran4]

Hi,

We want to fetch Assigned To (reference to User Table) based on Department of the user in a UI Page. We've written below code for the same 

'<g:ui_reference name="sys_user" table="sys_user" completer="AJAXTableCompleter" columns="department" columns_search="true" />'

But we are able to search from name but not department of users.

Quick response will be appreciated.

[kente]

Try to use 'AJAXReferenceCompleter' instead.

This is taken from the UI macro

If you are using completer=AJAXReferenceCompleter, you can also use:
columns= if you want to show additional columns in the drop down (semicolon separated list)
order_by= if you want to sort matches in the drop down by a particular column
query= if you want to limit the results (for example, active=true)

[Ritika Saran4]

Hi Kente,

I tried using AJAXReferenceCompleter but it is not working. Can you suggest anything else ?

[kente]

Ahh. i might have read it wrong the first time.

Are you trying to search by department? So you could write "customer" and then all users in that department would get shown?

[Ritika Saran4]

Yes Kente. I am trying to search by department so that when I write "customer" and then all users in that department would get shown.