Native Sql Query error

[vito16]

Im need query user task list  and with some variable what link this task.
when i running following sql :

SELECTt.ID_,t.REV_,t.EXECUTION_ID_,t.PROC_INST_ID_,t.PROC_DEF_ID_,t.NAME_,va1.TEXT_,va2.TEXT_FROMdbo.ACT_RU_TASK AS tINNER JOIN dbo.ACT_RU_EXECUTION AS e ON t.EXECUTION_ID_ = e.ID_INNER JOIN dbo.ACT_RU_VARIABLE AS va1 ON va1.EXECUTION_ID_ = t.EXECUTION_ID_INNER JOIN dbo.ACT_RU_VARIABLE AS va2 ON va2.EXECUTION_ID_ = t.EXECUTION_ID_INNER JOIN dbo.ACT_RU_IDENTITYLINK AS idlink ON idlink.TASK_ID_ = t.ID_WHEREidlink.USER_ID_ = 3 ANDva1.NAME_ = 'companyID' ANDva2.NAME_ = 'processType'‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

im getting this error:
<code>
[Err] 22018 - [SQL Server]Conversion failed when converting the nvarchar value 'Order' to data type int.
<code>

[liowbot]

USER_ID_ should be in character form. Enclose 3 in a quotation mark:

idlink.USER_ID_ = '3'

[vito16]

thank u!
Problem solved.

[liowbot]

You're welcome.