Question Status

Suggested Answer
JOHANS SAAVEDRA asked a question on 21 Mar 2014 5:57 AM

After upgraded a client from SL 7.0 FP1 to SL 2011, I found all the their templates that are using wildcards are not working. This is for SL standard reports, we are not even talking about Custom reports.

Whether you are using question marks (?) for single character or asterisks (*) is not working. It works fine when you use a complete value, but you combine value and wildcards does not work.

Using SQL Profiler I could get the SQL Statement the report is executing, and when I ran it directly in SSMS (SQL Server Management Studio) it return 0 records.

Is there something I have to do on the SQL side to recognize those wildcards?

Please help!

Johans

Reply
Suggested Answer
Santhosh Dharmar responded on 24 Mar 2014 11:48 AM

Hi

You can use the Operator as "Contains" instead of using wild card characters in Value

For Example: If we want to generate the Inventory Items report with the Inventory description "Crank" then

Just select the Field as "Inventory.Descr", and Operator as Contains" and Value as "Crank". No need to specify "%Crank%".

Hope this helps

Thanks and Regards

Santhosh D

Reply
Elaine Rettig responded on 24 Mar 2014 9:05 AM

Hi Johans,

I find the same issue.  

We may be able to come up with criteria that would get you the selection you need. Give me more specific selection parameters that you are working with and the report number.

Reply
Suggested Answer
Santhosh Dharmar responded on 24 Mar 2014 11:48 AM

Hi

You can use the Operator as "Contains" instead of using wild card characters in Value

For Example: If we want to generate the Inventory Items report with the Inventory description "Crank" then

Just select the Field as "Inventory.Descr", and Operator as Contains" and Value as "Crank". No need to specify "%Crank%".

Hope this helps

Thanks and Regards

Santhosh D

Reply
Chris Hanson responded on 25 Mar 2014 9:59 AM

We had thyis problem too when we went from 7 to SL 2011 FP1. Here is an example from our issue files back then:

Yes you can use ? now to replace _ to specify a certain number of characters to wildcard.   For example, the following would select 090 office.

GL_Subacct                                     EQUAL     ???090*

GL_Subacct                                     EQUAL     ???090%

Reply