Report - Database Views - Push the data to a column using the existing details.

[Sujatha V M]

Hello All, 

I have generated a report using database views which contains user, approval and change table. 

I want a column details as "VP" to be populated based on the approver's manager title contains "VP",

If that doesn't contain then it must drill down to next level of approver's manager's manager title contains "VP" and then push that user sys id to the column in report. 

For eg.

If Approver is Abel -> Abel's Manager is Aaron with title contains 'VP',  then it must return Aaron. 

If Approver is Abel -> Abel's Manager is Aaron without title as VP -> Aaron's Manager is Brown with title contains "VP",  then it must return Brown.

The search must happen only the VP is not found on the title. 

Kindly share your thoughts on this or ideas to retrieve the details. 

[luffy3478]

if your data in report is less. create a remote table and populate it as you like.

https://docs.servicenow.com/bundle/washingtondc-servicenow-platform/page/administer/remote-tables/co...

[Sujatha V M]

@luffy3478 Thank you for the suggestion. I was able to achieve it using script. 

Shall update the details as a separate blog/post.