Start expressions with condition

[FaCe]

Hi,

why this condition not works ?

<<Start: SELECT(TABLENAME[ID],[ASSIGNED] =[_THISROW]."PAUL")
<<[CATEGORY]>> - <<[TASK]>>
<<End>>

I receive this error message: Cannot compare List with Text 

[diogolupcosta]

[_THISROW]."PAUL" has a sintax error. 

If the column PAUL existis, the correct would be [_THISROW].[PAUL]

[FaCe]

No i'd like to extract all the records that have in ASSIGNED table the name of 'Paul'.

[diogolupcosta · Accepted solution]

<<Start: SELECT(TABLENAME[ID],IN("PAUL",ASSIGNED[column where paul is]))
<<[CATEGORY]>> - <<[TASK]>>
<<End>>

[FaCe]

Solved thank you very much for your help @diogolupcosta 

<<Start: SELECT(SCADENZA OGGI[ID],IN("PAUL",[ASSEGNATA]))>>

<<[CATEGORIA]>> - <<[ATTIVITA']>>
<<End>>