topic Re: Native Sql Query error in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/native-sql-query-error/m-p/174455#M127585 <HTML><HEAD></HEAD><BODY><SPAN>USER_ID_ should be in character form. Enclose 3 in a quotation mark:</SPAN><BR /><BR /><SPAN>idlink.USER_ID_ = '3'</SPAN></BODY></HTML> Thu, 06 Mar 2014 09:11:40 GMT liowbot 2014-03-06T09:11:40Z Native Sql Query error https://connect.hyland.com/t5/alfresco-archive/native-sql-query-error/m-p/174454#M127584 Im need query user task list&nbsp; and with some variable what link this task.when i running following sql <IMG id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />ELECTt.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.AC Thu, 06 Mar 2014 02:33:47 GMT https://connect.hyland.com/t5/alfresco-archive/native-sql-query-error/m-p/174454#M127584 vito16 2014-03-06T02:33:47Z Re: Native Sql Query error https://connect.hyland.com/t5/alfresco-archive/native-sql-query-error/m-p/174455#M127585 <HTML><HEAD></HEAD><BODY><SPAN>USER_ID_ should be in character form. Enclose 3 in a quotation mark:</SPAN><BR /><BR /><SPAN>idlink.USER_ID_ = '3'</SPAN></BODY></HTML> Thu, 06 Mar 2014 09:11:40 GMT https://connect.hyland.com/t5/alfresco-archive/native-sql-query-error/m-p/174455#M127585 liowbot 2014-03-06T09:11:40Z Re: Native Sql Query error https://connect.hyland.com/t5/alfresco-archive/native-sql-query-error/m-p/174456#M127586 <HTML><HEAD></HEAD><BODY><SPAN>thank u!</SPAN><BR /><SPAN>Problem solved.</SPAN></BODY></HTML> Thu, 06 Mar 2014 10:57:41 GMT https://connect.hyland.com/t5/alfresco-archive/native-sql-query-error/m-p/174456#M127586 vito16 2014-03-06T10:57:41Z Re: Native Sql Query error https://connect.hyland.com/t5/alfresco-archive/native-sql-query-error/m-p/174457#M127587 <HTML><HEAD></HEAD><BODY><SPAN>You're welcome.</SPAN></BODY></HTML> Fri, 07 Mar 2014 02:28:33 GMT https://connect.hyland.com/t5/alfresco-archive/native-sql-query-error/m-p/174457#M127587 liowbot 2014-03-07T02:28:33Z