Service offering listing based on selected service

[Piyush Dwivedi]

How should we configure When the "Service Offering" field is mandatory, it should only list offerings that are related to the selected Service in Change form?

[SANDEEP DUTTA]

HI @Piyush Dwivedi ,

I think the ask is wrong, based on field mandatoty you want to do something !!

What you can look for is , based on the  "Service Offering" selected it should list offerings that are related to the selected Service in Change form.

[AndersBGS]

Hi @Piyush Dwivedi ,

Basically there are two ways. If service is selected, then service offering should only show service offerings related to service. This can easily be done by a simple reference qualifier where parent is service. Second option is, if service offering is selected but not service, then you could do a client script with a script include to auto populate the service. 

[Bert_c1]

As stated by others here, the described behavior is due to the service_offering field on change_request is a reference field to the 'service_offering' table. It has a Reference Qualifier "javascript:'parent='+current.business_service;". So only those records in the 'service_offering' table that have their 'parent' value set to the selected 'Service' are shown on the form. You can go to a list view of 'service_offering' table records, add the Parent column, then group on that column to see available choices in your instance. You can build your desired relationships in that table.