QBE - Search multiple

[jrkircho]

Our company was purchased by a corporation, and they are moving us to JDE. I am completely new to JDE. When I asked this question of those training us, they had no idea.

We have a "Description" column. I would like to be able to search with the query-by-example (QBE) field for multiple criteria. For example, I'd like to search for "pipe" and "2in" and "seamless". Is there a way to do this in the QBE field or does it only allow you to search for one thing at a time? I have tried the following:
*pipe*, *2in*, *seamless* which JDE changed to *pipe, 2in, seamless* and found nothing
*pipe* + *2in* + *seamless* which JDE changed to *pipe + 2in + seamless* and found nothing

Any help would be greatly appreciated.

Thanks

 

[peterbruce]

jrkircho,

I don't think that is possible without specifically creating the functionality. You may have to do 3 separate searches. Is this a standard JDE application? Or a custom one? Also what JDE Apps and Tools versions are you using?

 

[franck_blettner]

if you are on Tools 9.1, you have to use query to do that. It's a standard option (Match any). Query is an improvement of QBE

 

[Larry_Jones]

Attached is a sample of the Query feature extension of QBE functionality which was introduced in tools release 9.1.

Please always include your release information and environment on your posts (see mine below) so we know where you're coming from without always having to ask.

 

[davidtrader77]

Hello,

Is possible to search 2 or more things at the same time, for example: I want to search 4 descriptions at the same time:

- Description1
- Description2
- Description3
- Description4

I come frome SAP and this was possible to do, but I am new in JDE and I have no idea if you can release this search.

Thanks all!!

Regards,

 

[BOster]

If you are wanting to do this as an OR type clause as in WHERE [Description1] = "SomeText" OR [Description2] = "SomeText". Then unless the APPL was specifically designed for this and you are trying to do this right in the QBE line it may not work exactly like that.

However, depending on your tools release and how the application is designed you can build more robust queries. Look for the following in the upper right corner of the screen and play with that to see if you can accomplish what you want. Not as quick and "adhoc" as you might be used to but useful none the less. And I believe you can get pretty creative with these advanced user queries.



And yes, I effectively just reposted what Larry did, but the UI does look a little different than from 10 years ago... and even my tools release UI may be old compared to the latest.