cmdb_ci_service

[Snehal]

Hi Team
I have one script include is applied in the service field of change request where some filters are applied through the script on the cmdb_ci_service on table and i want to and one more condition where i want add the filter the to visible only operational services so attaching the screenshot and also i was checking the exact filter on table i could not able to replicate please help me here

[New Developer_S]

@Snehal  ,

Are you reffering to name " Operational Status " ? Could you please clearly post what is your requirement ? 

[Snehal]

Hi Team ,

I want to add to show only operational status = operational in the above attached code snippet .

[New Developer_S]

@Snehal ,
Please go the the table cmdb_ci_service , Create a query with your filter ( Operational status = operational ) . Copy it as addEncodedQuery and paste it in your code as required.

Hope this will sort you issue, if yes ,mark as solution accepted or hit helpful.

[Snehal]

Hi 
Actually i am getting it from where and how to encode the query if you can see i am attaching one screen shot in that one script include is there which is applied on the service field i want to replicate the same filter on the service table and additional to that i want to add the operational status query but since from the code snippet i could not able to find the field sys_class_name because firstly i want to check what are all the records are fetching for that query and then i want to add the operational status = operational filter if you could help me with that filter it will be helpfull

Thanks in advance !!