Auto - lookup Blank Value for textbook

フォローする

Chelsea Chen

• 2023年02月14日 18:24

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!

0

• 

  Varun Agasthya

  • 2024年01月23日 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

   

  0

  コメントアクション パーマリンク

サインインしてコメントを残してください。