question True/False in reporting to Yes/No in Service Management forum

True/False in reporting to Yes/No

Community Alums — Wed, 09 May 2018 13:53:38 GMT

Good afternoon again!

So, here's my problem.

I have a report which shows SLA's which have breached and this is indicated by a tick box (True/False)

When I report on this management don't like it. Is there a away I can change this to Yes/No? Or any particular work arounds?

The out of the box field is called has_breached

Appreciate it thanks

Re: True/False in reporting to Yes/No

Gaurav Bajaj — Wed, 09 May 2018 14:09:22 GMT

Hi,

What you can do here is create a custom string field with the calculated value based on has breached field.

If its true, you can set it to Yes else No.

Please mark it correct/helpful based on the response.

Thanks
Gaurav

Re: True/False in reporting to Yes/No

Community Alums — Wed, 09 May 2018 14:22:33 GMT

Worked beautifully, thank you. 🙂

Re: True/False in reporting to Yes/No

Gaurav Bajaj — Wed, 09 May 2018 14:25:40 GMT

That's the beauty of ServiceNow. Glad it helped.

Re: True/False in reporting to Yes/No

Community Alums — Wed, 09 May 2018 14:40:05 GMT

When I run it through the reporting it just shows at empty. Is there anyway I can do it so it updates the choices?

Re: True/False in reporting to Yes/No

Gaurav Bajaj — Wed, 09 May 2018 15:06:45 GMT

Hi Andrew,

I replicated the same & it gives me data in reports as well.

If it is not working for you, then you can run a background script once & set the before update business rule to update this field.

var grSLA = new GlideRecord('task_sla');
grSLA.query();
while(grSLA.next()){
	if(grSLA.has_breached){
		grSLA.u_has_breached_string="Yes"; //set custom field value based on has breached field.
			
	}
	else{
		grSLA.u_has_breached_string="No";
	}
}

Thanks

Gaurav

Re: True/False in reporting to Yes/No

Community Alums — Wed, 09 May 2018 15:12:23 GMT

Hi

Would it not be easier (I assume) to update the calculated value to use choice 1 or choice 2?

That way they would (In theory) show in reporting.

If that's possible.

Re: True/False in reporting to Yes/No

Gaurav Bajaj — Fri, 11 May 2018 06:46:45 GMT

Hi Andrew,

That won't do the trick as its again setting the string value, Please try this through BR & background script to make it scalable & stable one.

Re: True/False in reporting to Yes/No

Community Alums — Fri, 11 May 2018 08:20:41 GMT

Hi thanks for looking into this for me.

This did work but it only worked for SLA's after the date I made the button so I created a UI button to Update all and now we're in business.

🙂