Select Box lookup custom query do not pick value from input in sql?

フォローする

Rakesh Burde

• 2020年03月13日 11:04

I took a drop-down list and select list type = "Lookup List" in the configuration tab.
Then I create a lookup source and select Name/Value pair and use Query manual

SELECT CUSTOMER_G+'('+CUST_C+')' as Name, CUST_CODE as Value FROM CUSTOMER_G WHERE C_CODE='${IssuingCompany}'

IssuingCompany is another input box it contents the c_code of the login user.

The problem is, When I validate the query then it runs. But actually it returns the employ list at the front end.
If I write C_CODE='2011' in Query hardcoded then it will work. I want to make it dynamic.

What is wrong in it?

0

• 正式なコメント

  

  AgilePoint NX Support

  • 2020年03月13日 19:15

  Hello Rakesh,

  Kindly select the lookup source as none in the select list type in the Configuration tab of the Dropdown list. You can use the Autolookup and select the same lookup source and configure the "Execute this lookup on" as Related Field Value Change.

  Thanks,

  AgilePoint Support

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

  Rakesh Burde

  • 2020年03月14日 06:10

  Great. Thanks, it solves my problem.
  Thanks Alot
  
  
  

  0

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

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