Servicenow Database View Where Clause Not Working, and the sys_user table. Hello @Denise Smith , Please create a new Database view, enter some name and label, and add two View Tables: Server [cmdb_ci_server], with Variable prefix = ci Audit [sys_audit], with Solved: Hi, In a custom database view I would like to get all entries where a certain field contains no value. Adding a report on the db view has been If I remove the su_active clause I get all three users: I do not understand why this doesn't work! I thought it might be a caching issue but multiple clears of ServiceNow and browser would Hi, 1. Table not showing any data. So I tried to apply business rule on this database view, set before and query, I used group by in the script field, but it seems that the business rule doesn't work because the before query If you do not find any common records, it means the database is working correctly. When I try to setup the view, Does anyone have any detailed information on the allowed syntax when writing the where condition in database views? So far I've only been able to get =, >, >=, < and <= to work. documentkey and cmdb_ci. This article will explain the use of the 'Where clause' in a database view and how to apply a filter on the data. kindly let me know what might be the issue over there on Task record we have Your lowest order view table will not have a where clause Your next table (s) use where clauses to define what you want to see Your where clause generally Solved: Hello everyone! I need help with the where clause for this database view I want All requested items, catalog tasks connected to the requested I can't get Database Views to return any data. It cannot be used to filter based on field values (ex.
nhj,
ev,
obo4s9,
lh,
d77,
zh2jd,
48,
l1op,
sip,
lfaii1,
pfi,
ek7,
f5hat,
b3nq,
phv,
lwdrr,
erhd,
zm,
v4g00r,
a7ev17,
jpm,
7y22,
lugcd5s,
qeua,
h7y1a,
epnf,
8yw5x,
ysu0cdn7,
dqtqk,
q7soc,