Why doesn't this selection forumula work: Parameters and Wildcards

[bigracefan]

Here is what I'm trying to pass:
{ECU_CHECKER_DETAILS.LINE} = {?Line} and
{ECU_CHECKER_DETAILS.TEST_DATE_TIME} >= {?StartDate} and
{ECU_CHECKER_DETAILS.TEST_DATE_TIME} <= {?EndDate} and
{?TesterName} = &quot;All&quot; or
{ECU_CHECKER_DETAILS.TESTER_NAME} like &quot;{?TesterName}*&quot;


The &quot;All&quot; works but when I try to pass a value into the &quot;{?TesterName}*&quot; parameter I get no results. For testing I put the parameter field on the header so I can see what it's passing. The value should work but doesn't bring back anythig. Is this the proper way to use parameters and wild cards?
Thanks.
Pete

 

[Szyma]

Hi,
please change it...

{ECU_CHECKER_DETAILS.LINE} = {?Line} and
{ECU_CHECKER_DETAILS.TEST_DATE_TIME} >= {?StartDate} and
{ECU_CHECKER_DETAILS.TEST_DATE_TIME} <= {?EndDate} and
({?TesterName} = &quot;All&quot; or
{ECU_CHECKER_DETAILS.TESTER_NAME} like {?TesterName}+&quot;*&quot

then it should works.

Good luck!

 

[bigracefan]

Works perfectly! Thank You.
Pete