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?

[Nithya V Sivara]

Hi Lauren,

I am having the same issue. were you able to fix the issue?

thanks,

Nithya

[JC S_]

Were you able to make this work?

[Michel Donnat]

Yes, by using a where clause of this type:

INSTR(prefix1.a_list_field ,prefix2.sys_id) > 0

Where:
a_list_field is a List of type referenced by prefix2.