question Re: Reference qualifier is not working properly in Developer forum

Reference qualifier is not working properly

Brijmohan — Tue, 18 Jun 2024 13:00:23 GMT

Hi All, I am working on record producer where I have 3 variables L1 category, L2 category and L3 category. I need to set these variables values depended on each other. I am able to get the values based on filter applied in script include but it is working only first time. Is there anything that I am missing in my script or any way to achieve this requirement and should give filtered record on every selection not only first time.

Scenario 1: If user select L1 category then only child categories should show in L2 category variable.

Result : It is showing only child categories like we have a, b and c three child categories and I selected a but when I want to change other category in L2 variable it is showing no record found.

Scenario 1: If L1 and L3 is empty then only those categories should show whose have child and parent category.

Result : It is showing categories as per filter but when I want to change other category in L2 variable it is showing no record found.

PFB script include that I am using in reference qualifier.

getLevel2Category: function(L3Category, L1Category) { var returnIds = []; var grModelCategory = new GlideRecord("cmdb_model_category"); if (!L1Category) { if (!L3Category) { // check if parent category is not empty grModelCategory.addEncodedQuery("parent_cateogryISNOTEMPTY"); grModelCategory.query(); while (grModelCategory.next()) { // Ensure the current category should have any child categories var childCategoryCheck = new GlideRecord("cmdb_model_category"); childCategoryCheck.addQuery("parent_cateogry", grModelCategory.sys_id); childCategoryCheck.query(); if (childCategoryCheck.hasNext()) { var tempId = grModelCategory.getUniqueValue(); returnIds.push(tempId); } } } } else { // Query for child categories with the specified parent category var encQuery = "parent_cateogry.sys_id=" + L1Category; grModelCategory.addEncodedQuery(encQuery); grModelCategory.query(); while (grModelCategory.next()) { tempId = grModelCategory.getUniqueValue(); returnIds.push(tempId); } } return "sys_idIN" + returnIds.toString(); },

Variable configuration

Thanks and regards,

Brijmohan

Re: Reference qualifier is not working properly

Ankur Bawiskar — Tue, 18 Jun 2024 13:00:28 GMT

@Brijmohan

no where in your script include function query you are using the value of the previous variable which should be used to filter

Re: Reference qualifier is not working properly

Brijmohan — Tue, 18 Jun 2024 15:24:33 GMT

Hi @Ankur Bawiskar Thanks for you response but I didn't get you. If you are talking about query, I am using below condition if we have any value in L1 category in else condition

var encQuery = "parent_cateogry.sys_id=" + L1Category;
grModelCategory.addEncodedQuery(encQuery);

where L1Category contain value of L1 variable.

Re: Reference qualifier is not working properly

Ankur Bawiskar — Wed, 19 Jun 2024 03:36:49 GMT

@Brijmohan

what about L3Category variable? you are not using it anywhere

Re: Reference qualifier is not working properly

Brijmohan — Wed, 19 Jun 2024 04:06:39 GMT

L3Category variable I am using in if condition for checking L3 category is empty or not like below

if (!L1Category) {
if (!L3Category) {

Code is working fine but the only issue is it is working only first time. Suppose I select category in L1 category field then L2 will show all child category. I select one category in L2 category field but when i go to choose other option it is giving no matches found. PFB snap.

First time selection

Second time selection