Hi! Does anyone know if you can use substitution lists with GIs? I’m trying to use them instead of using a long IF formula. This is what it looks like and the error:
Answer
Substitution lists with GIs
+4Best answer by estebanperalta54
I looked further into it and learned that the Substitution lists do not work in Generic Inquiries and are only meant to be utilized in Import Scenarios. Instead, I used a switch formula:
If you found the post helpful please like the post or if it answered your question mark it as best answer. Thanks!
+1You could create another GI and use it as a subquery that contains all the lookup values you need for the primary GI. This functionality was released in 2024 R1.
If this answer is helpful, please consider liking it!
+4I looked further into it and learned that the Substitution lists do not work in Generic Inquiries and are only meant to be utilized in Import Scenarios. Instead, I used a switch formula:
If you found the post helpful please like the post or if it answered your question mark it as best answer. Thanks!
+2For posterity, another option is to join in the PX.Api.SYSubstitutionValues DAC, which is where the Substitution Lists’ values are held. In this situation, you could Left join onto POOrder with the relations below to mimic SubstituteListed. An inner join would more closely mimic SubstituteAll.
Then display the SYSubstitutionValues.SubstitutedValue in the results grid instead of POOrder.AtributePODEST.
This way is more maintainable, since you can change the Substitution List as needed and don’t need to dive into hard-coded values in the GI.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.