My requirement is to display the list of macro records which are developed/owned by the logged in users or the logged in user is part of the macro team
now i m writing two Glide record queries, the first one is to get the logged in users team and then using it in my second query
The second query return the list of sysid's
Then i m using it in my URL as
https://xxx.service-now.com/x_opt_macro_govern_macros_list.do?sysparm_query=sys_idINjavascript:new MacroTeam().getMyMacros()
Am i repeating the query condition again and again? And is there a way where we can do this in much efficient method?
getMyMacros: function(){
var arr=[];
var macros=[];
var gr=new GlideRecord('x_opt_macro_govern_macro_team_leaders');
gr.addQuery('team_leader',gs.getUserID());
gr.query();
while(gr.next()){
arr.push(gr.getValue('macro_team'));
}
var myMacro=new GlideRecord('x_opt_macro_govern_macros');
var query1=myMacro.addQuery('development_team_developer',arr.join());
query1.addOrCondition('developer',gs.getUserID());
myMacro.addOrCondition('owner',gs.getUserID());
myMacro.query();
while(myMacro.next()){
macros.push(myMacro.getValue('sys_id'));
}
return macros.join();
}
Also, one more query, its not relevant to my actual post though.. if i use my myMacro.sys_id in the while loop its not giving correct output but when i use myMacro.getValue('sys_id'), it works fine.. are there any differences?
