We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Adding new DBV table in related list conditions while creating a standard report

Kingshuk Mazumd
Tera Contributor

Hi All,

 

I have created a new DBV joining 3 tables and I want to bring this Database view under Related List conditions while building a Report based on Table: Risk Identification [sn_risk_advanced_risk_identification]

Hope the attached screenshot will help...

 

Any suggestions?

1 ACCEPTED SOLUTION

@Kingshuk Mazumd 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

4 REPLIES 4

Ankur Bawiskar
Tera Patron

@Kingshuk Mazumd 

you can't select database view table in Related list conditions.

not possible as it only supports tables which has field pointing to main table in report

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

Thanks Ankur.
So this link is only for main tables or not useful for DBV? 



How to create Scripted Relationships or Defined Re... - ServiceNow Community

@Kingshuk Mazumd 

that link talks about adding Table as Related list on form using Defined Relationships.

It' not about how to add/show database view table in related list conditions in Reporting.

both are different things.

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

@Kingshuk Mazumd 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader