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,

Outcomes