All, I have a pretty rudimentary GI. I need to filter values with a check box. So I created a parameter and then a condition. Essentially, if the check box is checked I need this to be true:
[SOLine.ReasonCode]<>'PENDING'
If the SOLine.ReasonCode = ‘PENDING’, then do not display those pending orders in the results.
This is what I have. When I click the No Pending check box, all records disappear. I’m not sure where to include the [SOLine.ReasonCode]<>'PENDING'
Best answer by darylbowman
(( [IsPending] Equals *checked* AND
[SOLine.ReasonCode] Does Not Equal 'PENDING' ) OR
[IsPending] Does Not Equal *checked* )
+4In the case you want the GI to always filter out PENDING reason codes, it might be best to just set this in the conditions tab instead.
In the case you want to be able to view the results but just optionally filter out the PENDING lines, then do as mentioned in the first paragraph and use the schema field for the reason code and make sure to set the in the condition tab, 2 lines, first line is the parameter = false, similarly to how you have it now. The second line should be to specify if the parameter is not used (IsNull)
+13(( [IsPending] Equals *checked* AND
[SOLine.ReasonCode] Does Not Equal 'PENDING' ) OR
[IsPending] Does Not Equal *checked* )
(( [IsPending] Equals *checked* AND
[SOLine.ReasonCode] Does Not Equal 'PENDING' ) OR
[IsPending] Does Not Equal *checked* )
Daryl, that did the trick! I always forget that you need to say basically “Do this if checked; else, do this instead.” I had to create a ridiculously long condition to get everything that they wanted (and had to get the (( )) double brackets just right lol) but it worked! Thanks Daryl and Benjamin!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
