Question Change the default search in item browse

QAD_Hack_2021

New Member
Hello,
I'm sure this is a very basic question but I'll ask anyway.
In item browse, or any browse for that matter, how can you change the default search criteria globally in QAD 2014SE?
I am aware of saving favorites but I want this to change the search for everyone.

Thanks in advance!
 

W.Wulmsen

Member
Go to the browse in the QAD menu.
Use the context on the browse and select Design ( when authorized ).
Then you can enter an additional general selection .
 

QAD_Hack_2021

New Member
Hi William! Thanks for the reply. I am able to to select design and adjust the browse but I am more interested in seeing it open and default to "contains" instead of "start at" as shown in the attached picture.
If this is done in design, I'll need another clue please.Screenshot 2021-10-20 122300.png
 

W.Wulmsen

Member
I found via the QAD Knowledgebase what is possible with the searchfields.
It is possible to add in Pre-Processor Commands comments with directives.

When the "Pre-Processor Commands" tab is not visible in the Browse Maintenance.
Use the context menu ( right mouse click on the "Header data" line and select "Show All Tabs"

All fields have these search operatorlist:

/*!BF|pt_mstr|pt_part|searchOperatorList=Equals,NotEquals,Contains,Range,GreaterThanEquals,GreaterThan,LessThan,IsNull,IsNotNull*/

When you want to start with Contains, there is an undocumented feature.

Use this comment line in Pre-Processor:
/*!BF|pt_mstr|pt_part|searchOperatorList=Contains,Equals,NotEquals,Range,GreaterThan,LessThan,IsNull,IsNotNull*/

Remove : GreaterThanEquals,

Why I don't know but it triggers the "starts at" operator.

reg.
W2
 

rumi

Member
I found via the QAD Knowledgebase what is possible with the searchfields.
It is possible to add in Pre-Processor Commands comments with directives.

When the "Pre-Processor Commands" tab is not visible in the Browse Maintenance.
Use the context menu ( right mouse click on the "Header data" line and select "Show All Tabs"

All fields have these search operatorlist:

/*!BF|pt_mstr|pt_part|searchOperatorList=Equals,NotEquals,Contains,Range,GreaterThanEquals,GreaterThan,LessThan,IsNull,IsNotNull*/

When you want to start with Contains, there is an undocumented feature.

Use this comment line in Pre-Processor:
/*!BF|pt_mstr|pt_part|searchOperatorList=Contains,Equals,NotEquals,Range,GreaterThan,LessThan,IsNull,IsNotNull*/

Remove : GreaterThanEquals,

Why I don't know but it triggers the "starts at" operator.

reg.
W2
Hi, is to possible to set which field would be first?
On picture, the first is 'Item number' but i would like to have another filed (column) from the first dropdown ...

Thanks
 

W.Wulmsen

Member
No, the sequence of the fields is related to the fields row.

The only thing you can do is deactivate a field.
Again in preprocessor:

/*!BF|pt_mstr|pt_domain|isSearchField=false*/
 

rumi

Member
Thanks,
but it doesnt work when the browse is used in a function (1.4.1 for example) as a lookup on field...
Where can i find these preprocessor 'magic tricks'?

M
 

W.Wulmsen

Member
They are hidden in de Knowledge base of QAD.
Most I retrieved from AA-69940.

I have tested it now also for the Lookup functionality.
There the operator GreaterThenEquals is mandatory. Why???
There is no manual where the complete functionality is described

W2
 
Last edited:

QAD_Hack_2021

New Member
I found via the QAD Knowledgebase what is possible with the searchfields.
It is possible to add in Pre-Processor Commands comments with directives.

When the "Pre-Processor Commands" tab is not visible in the Browse Maintenance.
Use the context menu ( right mouse click on the "Header data" line and select "Show All Tabs"

All fields have these search operatorlist:

/*!BF|pt_mstr|pt_part|searchOperatorList=Equals,NotEquals,Contains,Range,GreaterThanEquals,GreaterThan,LessThan,IsNull,IsNotNull*/

When you want to start with Contains, there is an undocumented feature.

Use this comment line in Pre-Processor:
/*!BF|pt_mstr|pt_part|searchOperatorList=Contains,Equals,NotEquals,Range,GreaterThan,LessThan,IsNull,IsNotNull*/

Remove : GreaterThanEquals,

Why I don't know but it triggers the "starts at" operator.

reg.
W2
William, can you include a screen shot of what the Pre-Processor is? I just want to make sure I understand it fully before I try break it.
 

W.Wulmsen

Member
The Pre-Processor can be seen in the Browse Maintenance.

This is the default when browse maintenance is opened:

1637925349635.png

With the right mouse, you can either open the default or all Tabs.

1637925467728.png

Example of Pre-Processor for Generalised Codes:

1637925530748.png
 

QAD_Hack_2021

New Member
That's brilliant! Thank you again William!
I still don't understand "how" or "why" it works, but it works!

I'm going to experiment with some other browse menus.
 

QAD_Hack_2021

New Member
Here's another thing I've learned thanks to WW2, you can set the the initial condition by selecting it in the Value-Return Column drop down under the header tab in design mode. So between the Pre-Processor and Header I can now fine tune all of these Browse programs!
Item Browse Design.png

Thanks so much William!

I think next, I will try to link additional data tables in a completely new totally custom browse. Wish me luck!
 
Top