Skip to main content
Answer

Can you put a condition on a parameter

  • June 28, 2023
  • 1 reply
  • 87 views

Forum|alt.badge.img

A client has a GI with a vendor parameter. When you click on the dropdown it also shows all the users as they also have a baccountid. I need to be able to put a condition on the parameter as putting in a normal condition in the conditions tab only affects the resulting data.

The relations is this:

 

Parameter:

 

In the dropdown on the GI they need to only see from where the vendors start, in this case the naming convention all start with V-, where as the ones above are all employees.

Would this require customization?

Best answer by sweta68

Hi @francoisroux96 ,

You need to join VendorR table and replace parameter condition to VendorR.acctCD under PARAMETERS tab to get desired result.

Hope, it helps!

Regards,

Sweta

1 reply

Forum|alt.badge.img+9
  • Semi-Pro III
  • Answer
  • June 28, 2023

Hi @francoisroux96 ,

You need to join VendorR table and replace parameter condition to VendorR.acctCD under PARAMETERS tab to get desired result.

Hope, it helps!

Regards,

Sweta