Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 2nd October 2017, 17:17
MIMOURI MIMOURI is offline
Junior Member
 
Join Date: Mar 2005
Posts: 5
MIMOURI is on a distinguished road
Baan: IV c4 - DB: Bisam - OS: HPUX
Filter results

Is there any possibility to filter results using as substring chain the content of a program variable?

for instance by using in a SELECT the statement

WHERE tiitm001.dsca LIKE %find%

any item containing in its description the chain "find" is displayed

But what if "find" is the value of a variable? Is there any way?

Thank you
Reply With Quote
Sponsored Links
  #2  
Old 2nd October 2017, 17:29
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,903
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Not exactly sure of the question - but you can use query.extension and build you a filter on a session. You can search on query.extension to get an idea of the possibilities.
__________________
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.
Reply With Quote
  #3  
Old 2nd October 2017, 18:06
MIMOURI MIMOURI is offline
Junior Member
 
Join Date: Mar 2005
Posts: 5
MIMOURI is on a distinguished road
Baan: IV c4 - DB: Bisam - OS: HPUX
Mark
I want to introduce a value in a screen field and use it to filter the records containing this value in every position of a key field of the table
Reply With Quote
  #4  
Old 2nd October 2017, 19:30
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,903
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Are you on 4c4 or LN? In 4c4 you have query.extension - I usually have a filter program that calls the session that will be filtered. In LN look at query.extend - in LN you can rebuild the queries.
__________________
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.
Reply With Quote
  #5  
Old 6th October 2017, 22:44
rahul ingale rahul ingale is offline
Member
 
Join Date: May 2011
Location: Hyderabad
Posts: 33
rahul ingale is on a distinguished road
Baan: baan infor - DB: sql - OS: windows xp
sql.var=sql.parse(
" Select tiitm001.cuno " &
" from tiitm001 " &
" where tiitm001.dsca like " & find)

where find is variable.
__________________
IRL
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Filter on multiocc fields on Webtop pillai.ganesh Tools Development 0 14th February 2013 10:43
Session Filter Issue in ERPLN raikar_raviraj Tools Development 4 19th January 2012 14:56
Filter not working VishalMistry Tools Administration & Installation 2 23rd April 2011 06:14
Enable fields after filter patriciosoria Tools Development 0 23rd January 2010 21:34
Problems with ttstpqbf (filter) en@frrom Tools Development 1 19th April 2005 11:56


All times are GMT +2. The time now is 07:57.


©2001-2017 - Baanboard.com - Baanforums.com