Autolookup to SQL database - Query unable to validate

Follow

Chelsea Chen

• February 09, 2023 18:55

Hi, I am having an issue with validating the query for auto lookup.

I need to be able to filter on multiple fields that users can optionally use to query the SQL database table and bring the data back to the form. However, when I try to validate the query just for a single field, it keeps on returning "Failed". This is what my query looks like.

SELECT Source, Identifier, UniqueCaseID FROM qps.QualityImprovementDashboard
WHERE Identifier = ${ID}

The web console is popping an error of "AgilePointServerException>Authorization header cannot be empty" when I try to validate. The problem seems to be with the "${ID}" part. When I remove "${ID}" and change the where condition to Identifier = 'some value', the the validation is successful. 

Any pointers will be greatly appreciated, thank you in advance!

0

• 

  Tobias

  • February 14, 2023 10:14

  Hi Chelsea

  Maybe you could fix it with just two ' ':
  SELECT Source, Identifier, UniqueCaseID FROM qps.QualityImprovementDashboard WHERE Identifier = '${ID}'

  0

  Comment actions Permalink
• 

  Chelsea Chen

  • February 14, 2023 18:17

  works beautifully! much appreciated of your help!

  0

  Comment actions Permalink

Please sign in to leave a comment.