Using parameters with partial text matches

[Former Member]

Hi all,

I have list of statuses displayed from a SAP system like, "created-Assigned-On Hold", "Canceled", "Created", "Completed".

I would like to create a static parameter filter with the options "Created", "On Hold", "Assigned", "Completed" and "Canceled".

If a user selects, On Hold, the records with the status "created-Assigned-On Hold" would be displayed and in the same way, if the user selects Assigned, the same records would be displayed. How can i incorporate this logic in the select expert?

Thank you

VV

[Former Member · Accepted solution]

Your selection would be something like

Status like "%"&parameter&"%"
//Substitute the astrick symbol for %
//can't type it here

[Former Member · Accepted solution]

Hey Debi,

I tried {database field } like " * "&{?Status}&" * ".as you had suggested. The records are not getting displayed or am i missing something here.

thanks

VV

Edited by: Vinnie_uic on Nov 5, 2010 4:36 AM

[Former Member · Accepted solution]

figured out the issue. was a type issue.

Thanks a lot