User login
|
|
|
|
Frontpage Sponsor
|
|
|
|
Poll
|
What do you expect from your SI Implementation partner for the success of ERP implementation. Bring best practices - Not to offer more CR's Leveraging standard functions 14% Need more honesty to work with the Users until their processes are fully mapped & Users are trained 43% Focus on process automation/ integrations/ Real time data/ BI analytics 29% Stick to basics 14% Total votes: 7 |
|
Baanboard at LinkedIn
|
|
|
|
 |
6th March 2023, 12:11
|
|
Junior Member
|
|
Join Date: Jan 2023
Posts: 22
|
|
|
Baan: 4,5,6,10 -
DB: sql -
OS: windows
|
How to use Query menu command with like operator
Baan: Other/Unknown C/S: None/Unknown
Hi,
Using Baan IV becs client tool ...
Does anyone have an idea how to use the Query menu command from Labels Tools in order to get all the labels with label description like '%Company%' ?
For example, 'Company', 'Original company', etc.
See also the screen.
Thanks query-using-like.png
|
6th March 2023, 15:20
|
 |
Guru
|
|
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,764
|
|
|
Baan: Baan 4C4 A&D1 -
DB: Oracle -
OS: Sun Solaris
|
|
Use something like .*Company.* - of course company will have to have the right case. So this should find anything with Company in it, but will not find company. At least that is how I recall it works.
__________________
Mark
GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.
Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
|
7th March 2023, 10:41
|
|
Junior Member
|
|
Join Date: Jan 2023
Posts: 22
|
|
|
Baan: 4,5,6,10 -
DB: sql -
OS: windows
|
|
Thanks Mark. That works. I wonder now how to modify in order to get both company and Company (with respect to capital letters). Anyway the answer is useful.
PS: I thought the form takes the SQL special signs for LIKE operator (that is, % instead of *)
|
7th March 2023, 14:29
|
|
Guru
|
|
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,764
|
|
|
Baan: Baan 4C4 A&D1 -
DB: Oracle -
OS: Sun Solaris
|
|
You might want to check the help - I think the ? is for any character - but you could just use .*ompany.*. Back in the day depending on what I was doing I just might write an easy sql to query the tables that way - still using like .* in the like portion of the query.
__________________
Mark
GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.
Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
|
13th March 2023, 16:10
|
 |
Guru
|
|
Join Date: Mar 2002
Location: Belgium
Posts: 1,288
|
|
|
Baan: Infor LN 6.1 10.2.1 > 10.7 -
DB: MS SQL2017 -
OS: VM WindowsServer2016
|
Quote:
Originally Posted by mark_h
You might want to check the help - I think the ? is for any character - but you could just use .*ompany.*. Back in the day depending on what I was doing I just might write an easy sql to query the tables that way - still using like .* in the like portion of the query.
|
I think the like uses regex in which case it would be .*[Cc]ompany.*
__________________
Also read Luke 24:4-8
After that you can find many answers on Infor, LN, BaanIV, BaanV, InforLN and ION and even some questions asked here on baanboard.com
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
