Union Of conditions

[suyoga]

Hey Folks,

I need help with creating union of condition, I have a relationships(Related List) on incident table which have criteria something like below:

current.addEncodedQuery('caller_id=' + parent.caller_id + '^ORu_behalf_of=' + parent.caller_id + '^ORcaller_id=' + parent.u_behalf_of + '^ORu_behalf_of=' + parent.u_behalf_of + '^sys_id!=' + parent.sys_id + '^sys_created_onONLast 60 days@javascript:gs.beginningOfLast60Days()@javascript:gs.endOfLast60Days()');  

Recommendation from servicenow team is to remodel this and have it in UNION and go away with OR condition(underlined) in above condition, I am looking for recommendations on how to go away with OR condition.

[Ankur Bawiskar]

@suyoga 

did they not provide the recommendation when you created the case with them?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[suyoga]

@Ankur Bawiskar  No we tried but was not able to resolve it, Engineer involved is expert in backend(server side and DB stuff), recommendation provided by them is to have it as UNION as instead of OR.

[Ankur Bawiskar]

@suyoga 

can you try this? I haven't tested it though.

var incidentIds = {}; // Use object for uniqueness

function addIncidents(query) {
    var gr = new GlideRecord('incident');
    gr.addEncodedQuery(query);
    gr.query();
    while (gr.next()) {
        incidentIds[gr.getValue('sys_id')] = true;
    }
}

var dateFilter = '^sys_created_onONLast 60 days@javascript:gs.beginningOfLast60Days()@javascript:gs.endOfLast60Days()';
var excludeSelf = '^sys_id!=' + parent.sys_id;

addIncidents('caller_id=' + parent.caller_id + excludeSelf + dateFilter);
addIncidents('u_behalf_of=' + parent.caller_id + excludeSelf + dateFilter);
addIncidents('caller_id=' + parent.u_behalf_of + excludeSelf + dateFilter);
addIncidents('u_behalf_of=' + parent.u_behalf_of + excludeSelf + dateFilter);


var sysIdList = Object.keys(incidentIds); // Array of unique sys_ids

if (sysIdList.length > 0) {
    current.addQuery('sys_id', 'IN', sysIdList.join(','));
} else {
    // Optionally, add a query that matches nothing if no sys_ids found
    current.addQuery('sys_id', ''); // This will return no records
}

If my response helped please mark it correct and close the thread so that it benefits future readers.

[suyoga]

Thanks @Ankur Bawiskar  let me try and test