Reference glide_list in Script (for loop not validating XML)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-22-2011 07:59 AM
Scope: Filter on-call calendar drop down by using a glide_list (array) of values. This could be used in multiple variations on what the glide_list would actually reference. For me, it is a new field on the company table referencing other companies. We want a user from Company A to be able to see ROTA groups that belong to Company A, B, C.
Schedules Pages -> Group Rosters. HTML section.
<!-- get the groups that have a roster defined -->
<g:evaluate>
var groupIds = [];
var rotaGR = new GlideRecord('cmn_rota');
rotaGR.addActiveQuery();
rotaGR.query();
while (rotaGR.next()) {
groupIds.push(rotaGR.group + '');
}
// Find current user's company sys_id
var rotaBU = new GlideRecord('core_company');
rotaBU.addQuery('sys_id', gs.getUser().getCompanyID());
rotaBU.query();
// Reference glide list 'u_area' using for loop
var list = rotaBU.u_area.toString();
var array = list.split(",");
// if we have groups, query for groups with rotas
// and all values in the u_area glide list on current user's company record
if (groupIds.length > 0) {
rotaGR = null;
var groupGR = new GlideRecord('sys_user_group');
groupGR.addQuery('sys_id', groupIds);
var grOR = groupGR.addQuery('u_business_unit', gs.getUser().getCompanyID());
for (var i=0; i < array.length; i++) {
grOR.addORCondition('u_business_unit', array<i>);
}
groupGR.orderBy('name');
groupGR.query();
}
</g:evaluate>
The XML keeps throwing the following error on save:
Error at line (25) The content of elements must consist of well-formed character data or markup.
It does not like the for loop at all. As soon as I remove that for loop it saves without issue. Any thoughts? Is it possible I can't use a for loop here?
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-22-2011 08:14 AM
It's probably the
symbol that it doesn't like. That's a reserved character that must be escaped. You can replace it with
'<'
. See here for details.
'<'
http://wiki.service-now.com/index.php?title=How_to_Escape_in_Jelly
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-22-2011 09:45 AM
mark.stanger
Though I'm not getting my desired results, that page helped and it is passing the XML now. I used the HTML alternative for the
which is
<
<
That still may not be correct but it keeps it from getting an error.
didn't work either.
'<'
Thanks Mark!
