How to filter Service Offerings based on Services selected from Record Producer ( Service Portal)

[Vijayr119]

How to filter Service Offerings based on Services selected from Record Producer ( Service Portal)

Both Service and Service Offering variables are referencing to cmdb_ci_services tabel

[Ankur Bawiskar]

Hi,

Is there any query business rule on cmdb_ci_service table which is restricting?

any table level READ ACL?

Regards
Ankur

[Vijayr119]

If there is issue with read ACL then Service field value shouldn't display the value from portal.. here I can see the list of Services from portal but not filtering the service offerings based on services selected. 

[Ankur Bawiskar]

can you try to hard-code the advanced ref qualifier to check if the filtering works?

[Vijayr119]

How can I do that? any guide to follow? or any sample code?

[shloke04]

Have you tried using a combination of Client script and Script Include for your scenario:

1) Create a Client Callable Script Include and use the below script:

Make sure the Script Include and Function Name is same.

function getOfferings() {
    var arr = [];
    var getServiceSeelcted = this.getParameter('sysparm_service');
    var gr = new GlideRecord('offering Table Name Here');
    gr.addQuery('parent field name', getServiceSeelcted);
    gr.query();
    while (gr.next()) {
        arr.push(gr.sys_id.toString());
    }
    return 'sys_idIN' + arr.toString();
}

Now update your Reference Qualifier in Service offering Variable as below:

javascript:'sys_idIN' + getOfferings(current.variables.VariablName);// Replace Variable Name with your Service Variable

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke