Baanboard.com

Baanboard.com (http://www.baanboard.com/baanboard/index.php)
-   Tools Development (http://www.baanboard.com/baanboard/forumdisplay.php?f=8)
-   -   Filter results (http://www.baanboard.com/baanboard/showthread.php?t=70471)

MIMOURI 2nd October 2017 17:17

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

mark_h 2nd October 2017 17:29

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.

MIMOURI 2nd October 2017 18:06

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

mark_h 2nd October 2017 19:30

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.

rahul ingale 6th October 2017 22:44

sql.var=sql.parse(
" Select tiitm001.cuno " &
" from tiitm001 " &
" where tiitm001.dsca like " & find)

where find is variable.


All times are GMT +2. The time now is 13:16.


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