Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
29%
500 - 800 GB
3%
800 - 1200 GB
8%
1200 - 1500 GB
8%
1500 - 2000 GB
11%
> 2000 GB
24%
Total votes: 79

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 28th November 2019, 15:33
KlaasJan KlaasJan is offline
Newbie
 
Join Date: Aug 2019
Posts: 1
KlaasJan is on a distinguished road
Baan: Baan IV - DB: MS SQL - OS: Windows 2016
filter data in zoomsession
Baan: Other/Unknown
C/S: None/Unknown

Hi,

I have a main session in where a user can select an invoicenumber. In a zoomsession I want to show related orders.
In the main session I do a zoom.to$.
And in the zoom session I added:

zoom.from.all:
on.entry:
import("ppmmm111.orno",orno)


After the zoom.from.all I receive the correct value 'orno' from the main session. But now I want to filter the data in the zoom session with the _index1 = value of variable 'orno'

So I tried a query.extend.where("ppmmm222._index1 = :orno")
and put this in the BEFORE.PROGRAM.
But whatever I try, it will never filter, and just shows all data.

Can somebody tell me what I do wrong?

Last edited by mark_h : 2nd December 2019 at 15:44. Reason: turned of smiles in advanced
Reply With Quote
Sponsored Links
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
Zoom from Reference to a session and filter data there jbaanm Tools Development 1 25th April 2019 16:33
Hiding Data from Database (Using Filter Hooks) azeez.hussain Blogs and Web links 0 28th December 2016 17:04
how can i filter the data of a session linyaohui Tools Development 5 7th January 2014 13:11
Application data dictionary vs. run-time data dictionary NPRao Tools Development 5 7th July 2009 09:16
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 06:38


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


©2001-2018 - Baanboard.com - Baanforums.com