Dynamic Query in UI page

Jake Sadler
Kilo Sage

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.

 

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@Jsadler19 

I shared solution for this 5 years ago

Reference field dependency on UI Page

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

1 REPLY 1

Ankur Bawiskar
Tera Patron
Tera Patron

@Jsadler19 

I shared solution for this 5 years ago

Reference field dependency on UI Page

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader