Auto - lookup Blank Value for textbook

Hello! I am trying to do a lookup against a SQL table. The query is looking up multiple fields. One of the fields that I want to lookup for is a text field. However, I don't know what is the blank value for the text box in AgilePoint. I've tried null, ' '(a space) and both, but doesn't seem to do the trick. Currently, The Source and CoC works properly, but if I remove the value in the Identifier text box, then the look up doesn't return anything.

My query looks like below:

SELECT PrimaryKey, Source, CoC, Identifier FROM qps.QualityImprovementDashboard WHERE (Source = '${Source}' OR '${Source}' = '-1') AND (CoC = '${SelectCoC}' OR '${SelectCoC}' = 'Please Select') AND (Identifier = '${Identifier}' OR '${Identifier}' <= ' ' OR '${Identifier}' is NULL)

Any pointers will be much appreciated! Thank you in advance!

Varun Agasthya

January 23, 2024 05:12

Hi Chelsea,
In AgilePoint, if we want to retrieve blank values from a lookup, we need to leave the textbox blank, which is equivalent to an empty string (i.e., ''). However, upon analysing your SQL query, I noticed that the condition for the Identifier is incorrect. Please correct the condition to (Identifier = '${Identifier}' OR '${Identifier}' = '')

Thanks

Auto - lookup Blank Value for textbook

Comments

Didn't find what you were looking for?