Request Property field issue

Question

Hello, 
 I am having an issue with the request property: The request is from the personwantsorg table, and I want to calculate the dynamic fields in the parameter query using "%", for example, UID_Person = '%UID_PersonOrdered%'. 
 This works fine, but when I try to use another parameter from personwantsorg, it doesn't work. I need the app name, for example, nameApp = '%DisplayOrgParent%'. 
 It's not a permission issue because if I use a static query, the apps are displayed correctly (for example, if I enter nameApp='TST'). 
 Could you help me with this? 
 Thank you, Elena

Markus Weiss-Ehlers · Accepted Answer

Note, that you cannot use the FK notation. the where-clause is in SQL not in VB code. 
 Replace AccProduct.CustomProperty01 with ESet.CustomProperty01 and the where clause with: XObjectKey='%ObjectKeyOrdered%'

Markus Weiss-Ehlers · Answer

You can eliminate the parameter "Application" if you change the Condition of your parameter Company to the following (At least If I understood your use-case correctly,)

CCC_App = (Select CustomProperty01…

Request Property field issue

Top Replies