Combine Parameters in GI

​@LaurenceGiraud36 How are you opening a GI from the other screen using an Action and passing the parameter in the action?

I would have thought it was as simple as having both fields the CD and ID on the Results of the GI and then the Action passed the Navigation parameter based on the ID and you can have a normal parameter to define the CD when run on its own (allow it to be blank)

Hi Dermot, 

we open the GI via an action throwing an PXRedirectToGIRequiredException where we pass all parameters in the exception. That’s not the problem we want to address here though.

We had to add two filters, one with the CD when using the GI directly. And the other one with the internal ID when redirecting from the other screen.

Our question here now is, whether there is a way to define a formula in the CD parameter that somehow takes the internal id from the other parameter and converts it to the CD? ​@Neil Cantral mentioned something like that in a GI webinar yesterday.

See also screenshot:
 

Can you pass the VendorCD in the parameter even if it isn’t actually what’s causing it to filter correctly? It sounds like you’re just wanting it to look good. Is that right?

​@Krischan Ok follow you now I dont think this is possible but i may be wrong

Ok, we’ll have to find another way. Txs for your feedback

If ​@darylbowman ‘s method works, you could maybe extend the condition so that the visible condition is used if present, but otherwise the hidden param ID is used if it’s empty?

​@darylbowman, no we can’t do that because of the bug I mentioned. The bug occurs when the parameter value contains non-English characters, like German umlauts. So even if we didn’t use the parameter value in the GI for any filtering, just passing a vendor cd like “Müller und Söhne”, would cause the GI to not be opened with the correct parameters.

Pardon my continued suggestions, as I’m not familiar with this bug, not being German 😏 Is the end result that the GI doesn’t open, or that it breaks the filtering? Because like ​@WillH suggested, if you could circumvent the VendorCD when BAccountID is used, if the GI actually opens, that might work?

Hi Daryl, it depends. Using characters > ASCII 127, like German umlauts, the GI would still open but with wrong parameters and hence with rows in the GI grid which don’t match what the user expected.

For characters like & which have a special meaning in URLs the GI would not even open when using BACcountID instead of VendorCD. E.g. opening the GI with a vendor like “H&M” would just result in a nasty asp.net error page.