question Re: How to display only unique values from the Reference variable in Developer forum

How to display only unique values from the Reference variable

shaik_irfan — Mon, 07 Jan 2019 09:38:25 GMT

Hello,

We have a variable Reference Type which is referring to Assignment Group. Our Assignment Group contains duplicate group names ex: Test Group, Test Group, Network, Network

From the Catalog view when the user clicks or search for the Assingment Group we need to display only unique value like if the user types Network, it should display only Network once not multiple

How to acheive this

Re: How to display only unique values from the Reference variable

Alikutty A — Mon, 07 Jan 2019 09:44:35 GMT

Hello Shaik,

You can change the Type of Variable to Lookup Select Box and make sure you check unique values only under Type Specifications.

Please try and let me know

Thanks

Re: How to display only unique values from the Reference variable

siva_ — Mon, 07 Jan 2019 09:46:17 GMT

May i know What is the reason you have multiple group names with same name?

Thanks,

Siva

Re: How to display only unique values from the Reference variable

shaik_irfan — Mon, 07 Jan 2019 11:51:38 GMT

Cant we implement the same on Reference type ?

Re: How to display only unique values from the Reference variable

Alikutty A — Mon, 07 Jan 2019 12:02:47 GMT

You will need to write a advanced scripted reference qualifier to remove duplicates and display it on the reference variable. This is not a recommended approach, You should not allow duplicate group names on your group table and prevent it from creation by marking the unique flag on the name column on sys_user_group table.

Re: How to display only unique values from the Reference variable

Chalan B L — Mon, 07 Jan 2019 12:27:43 GMT

Write an Advanced Reference Qualifier and call script include

** Note: Below script is not tested

Re: How to display only unique values from the Reference variable

shaik_irfan — Mon, 07 Jan 2019 13:03:54 GMT

Chalan,

I tried with your script but it is not working :(.

Am i missing anything ?

Script Include:

Reference Type variable referene qualifier:

Re: How to display only unique values from the Reference variable

Chalan B L — Mon, 07 Jan 2019 13:12:39 GMT

Irfan in the reference qualifier pass the variable name you want to filter the duplicate names.

Let me know the backend name of the variable you are trying for ??

Mark correct if it helped you..!!!

Regards,

Chalan

Re: How to display only unique values from the Reference variable

Chalan B L — Mon, 07 Jan 2019 14:10:00 GMT

Hello Irfan,

Any updates here if it helped you could you please mark the answer correct..!!

Regards,

Chalan

Re: How to display only unique values from the Reference variable

Alikutty A — Mon, 07 Jan 2019 14:14:47 GMT

He is looking to compare all names from group table and remove duplicates in it. So in group table, if you have 100 groups and several duplicates, it should return unique entries in the reference field.

Re: How to display only unique values from the Reference variable

shaik_irfan — Mon, 07 Jan 2019 14:19:53 GMT

Variable name is Center & Cost Center table field name is name.

Do i need to change in Scirpt Include & Ref Qualifier or only Ref Qualifier ?

Variable Name:

Cost Center whcih is a Referring table:

Advanced Script:

Script Include: I tried keeping as Center too but it is not working in the scriptinclude function and unique field script line

Re: How to display only unique values from the Reference variable

siva_ — Mon, 07 Jan 2019 14:20:16 GMT

Hello Irfan ,

The way you called the script include in the reference qualifier is correct but the thing which you are missing is

after doing the processing that needs to be done in script include you are getting the items into an array but you are not filtering the duplicates as expected (i mean you are directly returning the array with the names from your script include and that doesnot work)

To make it work , you have to get the sys ids as an comma seperated list of values as you are returning the values to a reference field , it can only display records based on the set of sysid's

so into your array you can get set of sys_id values and you can use Array.join() after the ArrayUtil.unique() line

and assign those values to a variable and while returning you can use return "sys_idIN"+varName

Hope that helps

Thanks,

Siva

MARK THIS RESPONSE AS CORRECT IF THAT REALLY HELPS

Re: How to display only unique values from the Reference variable

Chalan B L — Mon, 07 Jan 2019 14:27:15 GMT

I missed this in the code Irfan

----------------------------------------------

var arrayUtil = new ArrayUtil();

var store = arrayUtil.unique(duplicateFieldName);

return 'sys_idIN'+store.toString();

--------------------------------------------

Mark the answer as correct and helpful if it helped you..!!!

Re: How to display only unique values from the Reference variable

shaik_irfan — Mon, 07 Jan 2019 15:06:12 GMT

Thank you, Now i dont see any record all gets disapperead 😞

Script Include:

var ScriptIncludeName = Class.create();
ScriptIncludeName.prototype = {
scriptIncludeFunctionName: function(duplicateFieldName) {
var arrayUtil = new ArrayUtil();

var store = arrayUtil.unique(duplicateFieldName);

return 'sys_idIN'+store.toString();

type: 'ScriptIncludeName'
};

Re: How to display only unique values from the Reference variable

shaik_irfan — Mon, 07 Jan 2019 15:07:10 GMT

In above response am i missing anything ?

Re: How to display only unique values from the Reference variable

Alikutty A — Mon, 07 Jan 2019 15:13:03 GMT

Hi Shaik,

You can try this script in your script include

var ccList = [];
var uniqueArr = [];
var arrayUtil = new ArrayUtil();
var cc = new GlideRecord('cmn_cost_center');
cc.query();
while(cc.next()){
  ccList.push(cc.name);
}
uniqueArr = arrayUtil.unique(ccList);
return 'sys_idIN'+uniqueArr.toString();

Re: How to display only unique values from the Reference variable

Alikutty A — Mon, 07 Jan 2019 15:14:51 GMT

Add this script with a function named getUniqueCostCenters() and Call it in the advanced reference qualifier of cost center variables as

javascript: new ScriptIncludeName().getUniqueCostCenters()

Re: How to display only unique values from the Reference variable

siva_ — Mon, 07 Jan 2019 16:48:36 GMT

If the assignment group field has duplicate names , how are you managing exact assignment groups for all the records. Initially i suggest you to run a background script removing all the duplicate assignment groups

Before that for the existing records you should also check if the assignment group(you are deleting) has already been assigned to a case and maintain a single unique assignment group with the same sysid for every existing case, i strongly suggest that it would be the better approach as it may even incur multiple problems in reporting

We can prepare a code for the request by modifying what you have written but we cannot be sure how GlideRecord takes in when you query the same name for an assignment group what ever first record comes up it gives that sys id and that might become a mess ..

Hope that helps

Mark this response as correct if that really helps

Thanks,

Siva

Re: How to display only unique values from the Reference variable

Alikutty A — Tue, 08 Jan 2019 06:32:45 GMT

Few more changes are required to the above script, please try the script below

var ccList = [];
var uniqueArr = [];
var ids = [];
var arrayUtil = new ArrayUtil();
var cc = new GlideRecord('cmn_cost_center');
cc.query();
while(cc.next()){
  ccList.push(cc.name);
}
uniqueArr = arrayUtil.unique(ccList);

ccList = [];
var cc1 = new GlideRecord('cmn_cost_center');
cc1.addEncodedQuery('nameIN'+uniqueArr.toString());
cc1.query();
while(cc1.next()){
  ccList.push(cc1.sys_id);
}

return 'sys_idIN'+ccList.toString();

Re: How to display only unique values from the Reference variable

shaik_irfan — Tue, 08 Jan 2019 06:40:09 GMT

Ali,

Thank you for the script but unfortunately it is not working 😞

Advanced Rer Qualifier Screnshot:

Script Include:

var ScriptIncludeName = Class.create();
ScriptIncludeName.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getUniqueCostCenters: function(){
	var ccList = [];
var uniqueArr = [];
var ids = [];
var arrayUtil = new ArrayUtil();
var cc = new GlideRecord('cmn_cost_center');
cc.query();
while(cc.next()){
  ccList.push(cc.name);
}
uniqueArr = arrayUtil.unique(ccList);

ccList = [];
var cc1 = new GlideRecord('cmn_cost_center');
cc1.addEncodedQuery('nameIN'+uniqueArr.toString());
cc1.query();
while(cc1.next()){
  ccList.push(cc1.sys_id);
}

return 'sys_idIN'+ccList.toString();
},
	
    type: 'ScriptIncludeName'
});

I see only 1 record other records got disapperaed.