Database View Where Clause for List Fields

[lmcmanamon]

I'm trying to create a where clause on a Database View, but nothing is working. Table A has a List Field that contains references to Users (like the Watch List Field on the Task Table). Table B is that User Table. I want the where clause to state "the List Field CONTAINS this User" but none of the evaluators seem to product my wanted result. Can someone help me?

[amlanpal]

Hi Lauren,

There is no such operators present which operates as 'CONTAINS' or similar. But there are couple or workarounds present. One is using report and another is to use Before query Business rule. Please find the relevant threads below:

1. CAN WE USE "CONTAINS" OR "LIKE" OPERATOR IN WHERE CLAUSE OF DATABASE VIEW

2. Database View Table Where Clause to contain NULL

I hope this helps.Please mark correct/helpful based on impact

[amlanpal]

Hi lmcmanamon,

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this from the community inbox you will not see the correct answer button.   If so, please review How to Mark Answers Correct From Inbox View

[lmcmanamon]

I'm sorry, Amlan, but your comment didn't answer my question.

[nayanawadhiya1]

Hello Lauren,

Refer this may be it will help you -

ServiceNow Admin 101: Observations on Database Views, Part II