AnsweredAssumed Answered

SQL Request field - using WHERE = Item properties

Question asked by robinelm on Sep 27, 2017
Latest reply on Sep 28, 2017 by robinelm

Dear All,


I am trying to fetch from a SQL Database users details based on the unique identifier. 

For that I want to use a SQL Request with a WHERE condition to return information corresponding to a given user: 


The query run in "Run Now" if I manually input and replace the ID. But when the form load and that the Item Property ID should be set up in the SELECT statement then it doesn't.


I tried different syntax without success and I am now wondering if it is possible to use a Item Property inside the SQL Query ?

Does someone has any working experience of such case ?


Thank in advance,