We help IT Professionals succeed at work.

Pass NULL along with selected parameter choice from dynamic parameter

W D
W D asked
on
Medium Priority
434 Views
Last Modified: 2012-05-11
How do I pass NULL along with the selected parameter value from a dynamic parameter?
I need to show all records that have the selected value for my field AND all records that have NULL for that field too.
I have this for my Select Expert - Record formula: ({Command.FYI FlagTypeID}={?FYI Flag} or isnull({Command.FYI FlagTypeID})or{Command.FYI FlagTypeID}=''). It just returns those records with a value, no records return with NULLs.

I changed it to ({Command.FYI FlagTypeID}={?FYI Flag} and isnull({Command.FYI FlagTypeID}) but no records returned at all.

Thanks in advance for your help!
Comment
Watch Question

Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.