Display only specific value when using search function

[fgirardin]

Hello all,

I have a problem when using the search box for a specific document I'm working on.

The table is as follow

ITEM    OPERATION    DOCUMENT NUMBER     DATE

Each ITEM is unique

I have multiple OPERATIONS          (ORDER - SHIPPING - BILLING)

I have multiple DOCUMENT NUMBERS........ but........our system has been configured in a weird way (in my opinion) as we use only numerical code for each OPERATION. In principle it wouldn't be a problem... however, we use the same value for different OPERATION

Example:

ORDER 18/00255

SHIPPING  18/00255

These are 2 different documents, not for the same ITEM or client

When using  a standard search box, the results are most of the time a blank cell as QV doesn't know what to display

If I had to design the system, I would have added OR-18/00255 or SH-18/00255 so I could search separate documents....

I can't change that for the time being so, is there a way to search a DOCUMENT NUMBER from a specific OPERATION in a search box ?

It seems that you cannot specify a condition (Only...) in a search box

Thank you in advance for your help

Have a nice day

Fabien

[YoussefBelloum]

Bonjour,

sélectionner le type d’opération avant de faire la recherche ne résout pas le problème ?

[Gysbert_Wassenaar]

You can configure the search box to make it search only in specific fields. You could limit it to search only in the OPERATION field by choosing the option List Of Fields and adding only that field to the list.

[YoussefBelloum]

Thanks Gysbert