Reference qualifier on glidelist ui macro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-08-2019 08:29 PM
Hi All,
i have a Glidelist type field on ui page which is referring to Group table which i invoked from the oob ui macro "lightweight_glidelist". I want to put a reference qualifier on that field. how can i do that.
Thanks in advance
- Labels:
-
User Interface (UI)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-08-2019 09:50 PM
Hi,
Have custom UI macro and add ref qualifier in that. Have something similar to this
<g:ui_reference name="reference1" table="sys_user_group" completer="AJAXTableCompleter" query="QUERY:javascript:new ReferenceQualUtils().getDefaultGroups();"/>
in that script include you can send list of sys_ids
Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-09-2019 12:35 AM
Hi Ankur,
The above tag is i think for a reference field reference qualifier but in my case am invoking the GlideList macro. Plz find the highlighted part where am invoking the macro and i want to put on a filter where it should only return the group name which contains cab.
<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">
<label> </label>
<g:ui_form>
<input type="hidden" name="result" id="result" value=""/>
<input type="hidden" id="incidentSysID" name="incidentSysID" value="${sysparm_sysID}"/>
<label>Type</label><br>
<select name ="a">
<option value="Estimate">Estimate</option>
<option value="ROM">ROM</option>
<option value="Assement">Assement</option>
</select>
</br>
<br></br>
<g:evaluate var="jvar_list">
var ug = new GlideRecord('sys_user_group');
ug.addEncodedQuery("nameLIKEcab"); // use your jelly variable here for the group to filter
ug.query();
var list = []; // create an array of user IDs
while (ug.next()) {
list.push(ug.sys_id); // add record's user to list as a member of that group
}
gs.info('hello123'+" "+list.length);
</g:evaluate>
<label>Groups</label>
<g:macro_invoke macro= "lightweight_glide_list" id="a_group" name="a_group" control_name="myListCollector2" reference="sys_user_group" can_write="true" />
<br></br>
<label>Requested Due Date</label>
<g:ui_date_time name="from_date" id="from_date" />
<br></br>
<g:dialog_buttons_ok_cancel ok_text="OK" ok_title="OK" ok="return actionOK();" cancel_text="Cancel" cancel_title="Go back to template" cancel="return cancel();"/>
</g:ui_form>
</j:jelly>
Thanks,
Abinash Dash
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-09-2019 12:57 AM
Hi Abinash,
Following links you can check
https://community.servicenow.com/community?id=community_question&sys_id=5407c7e5db1cdbc01dcaf3231f961923
https://community.servicenow.com/community?id=community_question&sys_id=4182c321dbd8dbc01dcaf3231f961993
https://community.servicenow.com/community?id=community_question&sys_id=a8be72a5db58dbc01dcaf3231f9619c1
Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-09-2019 02:07 AM
Hi Ankur,
I have gone through these links but they are still unanswered. I just want thw=e way we can use query in reference macro do we have anything similar for glidelist. query doesnt seems to be working have tried that as well..
Thanks,
Abinash Dash