How to create a report on comments from approval table

lkm · ‎06-23-2017

I have created a report from Approval [Sysapproval_approver] table. I want all comments including history comments only for change requests. I have tried adding filter using sysapproval_approver where starts with CHG% but that doesn't work to only get changes. I tried approval journal column is not empty and that didn't return anything either trying to get comments that are populated with data. Can someone tell me what I am doing wrong?

Thanks,

Linda

Dennis R · ‎06-23-2017

Add the field named "Value", that is where the comment is stored.

I know that's a bit weird, but the technical reason is because you actually want to look at the Value field of the journal table, not the Comments field of the approval table, which will always be blank in reports.

You might want to also add the "Approval for" field; that's the change number for which the comment is applicable.

View solution in original post

Kalaiarasan Pus · ‎06-23-2017

Dot walk the approval for field.
You will find a task type field in that.
Choose task type as change request.

Dennis R · ‎06-23-2017

Just to clarify what Kalaiarasan said above in case you're new to reporting, when you click to select the field name in the filter for the report, scroll all the way down to the bottom and select Show Related Fields. Then expand the field name box back out, and you should see:

Approval for ==> Task fields

Click on that, then expand the field name box once more and select Task type in the dropdown. Leave "is" as the operator, and choose Change Request in the value box. When you run the filter, you'll only see change requests in the list.

lkm · ‎06-23-2017

Hello. I am new to ServiceNow. I am able to return just the Approval for change requests but the other question was how do I filter to get all comments but not empty comments. Thanks for your prompt responses. I purchases ServiceNow Learning book and have an instance issue and received prompt response from it as well. It is great you have community support.

Kalaiarasan Pus · ‎06-23-2017

I realise now that my comment wasn't descriptive enough and should have included a screenshot to explain it better. I will keep this in mind for future responses.

Anyways, practice is the best thing you can do to get up to speed with ServiceNow. I haven't read any book till now nor have taken a course. I learnt most of the things by following people here and learning the tricks by actively participating on community.

Don't shy away from asking questions and the key is practice, which you have already started by getting a personal instance. Remember that the inactive period for personal instances is 10 days. So make sure that you take periodic backup of your work (I learnt this the hard way by losing most of my work).