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

Vijayr119
Tera Contributor

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

find_real_file.pngfind_real_file.png

1 ACCEPTED SOLUTION

Hi,

So it means the ref qualifier works with hard-coded value of service sysId

Since you want to filter records you need not use script include; this should ideally work

Is the variable name business_service correct?

javascript: 'parent=' + current.variables.business_service.toString();

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

18 REPLIES 18

Anil Lande
Kilo Patron

Hi,

I hope you have correct data in cmdb_ci_service table where selected Business service is parent of some other services.

No need to use script include call, you can achieve it in the advanced reference qualifier itself.

javascript:'parent='+current.variables.business_service.toString()

 

Thanks,

Anil Lande

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

I have already tried with reference qualifier but didnt work... Please see the offerings table and how the data is available.

If I select "Adobe Premier Suite Service" from seervice field, no service offerings will be listed in the field.

find_real_file.png

find_real_file.png 

 

find_real_file.png

shloke04
Kilo Patron

Hi,

You do not need a Script Include and you can achieve this using a Reference Qualifier itself as below:

Reference qualifier: javascript:'Give your Service Field Name=' + current.variables.Service_Variable_Name;

 

You can refer the below blog to learn more with a step by step explanation given:

https://community.servicenow.com/community?id=community_article&sys_id=1ce7dceedb5914101cd8a345ca961952

 

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

Regards,
Shloke

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

Regards,
Shloke

I have already tried with reference qualifier but didnt work... Please see the offerings table and how the data is available.

If I select "Adobe Premier Suite Service" from seervice field, no service offerings will be listed in the field.

find_real_file.png

find_real_file.png 

 

find_real_file.png