How to create a database view with a join on the RITM table to the value for variable.

[Bindhu1]

Hi Team , 
Requirement DONE :

Created custom interactive filter to be able to drill down to the office location performing the work within the  XYZ Dashboard. Currently this value is available in the “Location" Variable field. Since interactive filters cannot be built on variables, the approach we have taken is to add a new field “Ser Location” to the RITM table. We have copied the value from "Location" variable to new "Sr Location" filed. 

Changes they need Now: 

creating a database view with a join on the RITM table to the value for this variable.

Since RITM is core ServiceNow table, not a good idea to add custom columns on the table.

Please let me know how to create database view for this and bring it on dashboard

Thanks

[Prince Arora · Accepted solution]

@Bindhu1 ,

For database view, I have tried this combination in my PDI and got the response:

Please check it

If my answer solved your issue, please mark my answer as ✅Correct & 👍Helpful based on the Impact.

[Prince Arora]

@Bindhu1 ,

You marked my answer helpful!

Please accept the solution, if it has answered your query 🙂