Request Property field issue

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

Parents Reply Children
  • Sure, I'll try to explain:

    I have a request property with 2 parameters:

    Parameter 1) Name of the application selected from the IT shop
    - ParameterName1="Application"
    - ParameterType="Calculated"
    - Data Source= "Table"
    - Table column = "ESet - CustomProperty01"
    - Condition= "XObjectKey='%ObjectKeyOrdered%'"

    Parameter 2) List of companies displayed based on the application of the request
    - ParameterName="Company"
    - ParameterType="User prompt"
    - Data Source= "Table"
    - Table column= "CCC_APP_SOC - CCC_App"
    - Condition= "CCC_App=$PC(Application)$"

    On the portal side, this happens:
    - The user selects the application on the left and the service item on the right.
    - CURRENT Condition: In the shopping cart, the user has to manually select the application from the dropdown menu and then he can choose the list of companies based on the selected application above.
    - DESIRED Condition: In the shopping cart, the user should be able to choose a list of companies without having to manually select the application from the dropdown menu.

    So I wonder, is there a way to automate the filling of the value of parameter 1? I would like it not to be displayed on the portal because it is only needed for the calculation of parameter 2.

    Thank you so much,

    Elena

  • 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 from ESET Where XObjectKey = '%ObjectKeyOrdered%')

  • Yes, that's exactly what I was looking for!
    Thank you so much Markus!