How to write a "where clause" in a database view

[vishnumaaya]

Hi, 

1. After creating a database view , adding the tables you want to combine , how to define where clause?

2. How do we know which one to write where clause for??

3. For example, see the picture below,

- How to judge where to write the Where clause? as in where clause is written near the change_request and not task_sla 

- Why was it written in change request where clause?

- Why did it not use change_request_sla table n used task_sla table??

Please share any article, blog or videos if you have. 

Thanks,

Vaishnavi

[vishnumaaya]

Hi,

I have multiple tables added,

incident_metric, cmdb_ci_outage and u_business_unit (custom table which has markets details).

I would want Incident number column, Outage number column, Duration(Outage) column and business unit column (where the outage has occurred) . How can I write database view for this?

Thanks,

Vaishnavi

[Dr Atul G- LNG]

Hi @vishnumaaya 

So on this case  you need to find out what is common in table and then create the where clause  to get the results, You can look OOTB database view to get an idea.

[Community Alums]

Hi @vishnumaaya ,

Refer to this example :

https://www.servicenow.com/community/training-and-certifications/database-view-quot-where-clause-quo...

https://www.servicenow.com/community/itsm-forum/database-view-where-clause/m-p/2474805

[Community Alums]

Hi @vishnumaaya ,

[Viraj Hudlikar · Accepted solution]

Hello @vishnumaaya 

Please refer below thread & videos:
Solved: Database View - ServiceNow Community

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0719186

https://www.servicenow.com/docs/csh?topicname=c_DatabaseViews.html&version=latest

https://youtu.be/_JY462TmXxU?si=2OvPCBW_Ecid4flE

https://youtu.be/vk1MYBxTSxY?si=j-Y1f0BFCdknobJT

https://youtu.be/vJo3BG2RCVc?si=Apuspc_SFU12gBbD

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.