Can wildcards be used in reports?

[Mike Rivney]

I tried using asterisk (*) and dollar sign ($) but no go.  That is, no results found.  Is this possible or do I need to check with my system admin to get the rights?  Thanks.

[Arav]

Hi,

Where exactly in reports are you trying to use a wildcard ? Can you please add a screenshot if possible ?

Thanks,

Arav

[Mike Rivney]

Hi Arav,

  I'm trying to use a wildcard in the condition builder area of the report editor.  I've attached a screen shot.  

  Note :  navigation is All, Reports, View/Run, and then I select my saved report.

Thanks, Mike.

[Arav]

@Mike Rivney that won't work as the wild card operator "contains" already does that job.

May I suggest using the filter below ?

"Short Description contains oracle" AND "Short Description contains feed" ?

I know it's not exactly the same as what you are trying to achieve but it will get you the data you are looking for.

[Mike Rivney]

Hi Arav,

  It's helpful but not 100%.  What if I want ".... oracle ... feed ... " only?  So if there is a value of "...feed ... oracle ..." it would be found.  Thus, I get more rows than I want.

  Secondly, I have a large list of values to check on.  So they are in a group OR.  I can't insert your solution into this 'big' OR since it requires an AND.  That's due to the way the conditions can be built.  Can't have a nested compound condition.  I have to use new criteria and repeat my previous conditions (less the group OR condition) and add in your proposed condition.

  Lastly, are you stating that wildcard characters are not allowed on reports?

Thanks,  Mike.