Dynamic Query in UI page

[Jake Sadler]

I am trying to create a reference field that has a dynamic query. The query is set based on the value of the first reference field but I can't get it to work.

HTML Script:

<g:ui_reference name="group" id="group" table="sys_user_group"   query="active=true" completer="AJAXTableCompleter" ng-model="group" onchange="onChange()" />

<g:ui_reference name="user" id="user" table="sys_user_grmember"   query="active=true" completer="AJAXTableCompleter" ng-model="user" />

Client Script:

function onChange(){

var group = document.getElementById("group").value;

var query = "group.sys_id="+group;

document.getElementById("user").query = query;

Any help would be much appreciated.

[Ankur Bawiskar · Accepted solution]

@Jsadler19 

I shared solution for this 5 years ago

Reference field dependency on UI Page

Regards
Ankur