Skip to main content
Solved

Allow wildcards in the PF step Change filter


Blommetje
Forum|alt.badge.img+13

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 

Best answer by Mark Jongeling

Hey @Blommetje,

This seems to me this is a bug. However, did you try this with Universal too? Just to be sure if it is only an issue with 2-tier Windows GUI or also Universal with Indicium.

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

5 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Administrator
  • 3940 replies
  • Answer
  • February 5, 2024

Hey @Blommetje,

This seems to me this is a bug. However, did you try this with Universal too? Just to be sure if it is only an issue with 2-tier Windows GUI or also Universal with Indicium.


Mark Jongeling
Administrator
Forum|alt.badge.img+23

@Blommetje , have you tried out my suggestion?


Forum|alt.badge.img

I am experiencing the same issue/bug. This also occurs in Universal.


Mark Jongeling
Administrator
Forum|alt.badge.img+23
Xavier de Bondt wrote:

I am experiencing the same issue/bug. This also occurs in Universal.

That is unfortunate, could you create a ticket for this in TCP? 


Forum|alt.badge.img

Hi Mark,

Sure, will do!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings