Hi, 

I have a task for searching something.

Start Task from menu. Enter value (shipment number), open document - start empty, change filters.

When I enter the exact value it works ok. Open the table and show the row. 

For example: Shipment number: 22fe0530

This will output this query in the debugger: 

as t1
where (t1. shipment_number] = N'22fe0530')

However, I want people to be able to use the filter similar to ‘ctrl - G Filter’ .

When I set ‘Allow Wildcards’ in my PF step ‘Change Filters’, it still searches for the exact entered value, giving this; 

 as t1
where (t1. shipment_number] = N'22FE*')

When filtering in the ‘ctrl-G filter’  it outputs; 

 and (t1.=shipment_number] like N'%22fe%')

Which will result in several rows that match. 

The documentation states that the COL value must be EQUAL, so the = makes sense. But then.. What to do with the wildcard?

In short, can it be done to output all rows with Shipment_number like 22fe% - when entering a value in a task and then open the document, and show these rows? 

Thanks! 

Blommetje