reference qualifier code is not working

[Sanjay Kumar10]

Below reference qualifier code is not working. Could someone please help me.

javascript:'name=x_nuvo_eam_facilities_work_orders^element=u_facilities_problem^inactive=false^NQname=incident^element=u_problem_type^inactive=false^dependent_value='+current.variables.subcategory;

@Dr Atul G- LNG 

[Yashsvi]

Hi @Sanjay Kumar10,

please check below code:

corrected version of your reference qualifier code:

javascript:'name=x_nuvo_eam_facilities_work_orders^element=u_facilities_problem^inactive=false^NQname=incident^element=u_problem_type^inactive=false^dependent_value=' + current.variables.subcategory;

Make sure current.variables.subcategory is correctly populated. If the issue persists, try logging the constructed query for debugging:

javascript: (function() {
    var subcategory = current.variables.subcategory;
    var query = 'name=x_nuvo_eam_facilities_work_orders^element=u_facilities_problem^inactive=false^NQname=incident^element=u_problem_type^inactive=false^dependent_value=' + subcategory;
    gs.info('Reference Qualifier Query: ' + query);
    return query;
})();

Thank you, please make helpful if you accept the solution. 

[Sanjay Kumar10]

Hello @Yashsvi ,

Above code is also not working. I'm getting all the values however values are coming as per the value of category.

[Anurag Tripathi]

This is very little info to go on.

Can you show some screenshots and some table/ field names etc.

Most of the thing is custom and here we cant saw what is failing here.

[Sandeep Rajput]

@Sanjay Kumar10 Please test this query on the list of the table which your reference field is referring to and see if it returns any results with a sub category shown in the record producer.