Go Back > Forum > Baan Quick Support: Functional & Technical > Tools Administration & Installation

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 49

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 2nd December 2016, 22:07
eric.dizon's Avatar
eric.dizon eric.dizon is offline
Senior Member
Join Date: Feb 2012
Posts: 151
eric.dizon is on a distinguished road
Baan: ERP LN - DB: MS SQL - OS: 2003
Post Selection Filter in LN
Baan: ERP LN 6.1 FP7 (Infor ERP 10.1)
DB: SQL Server 2008 R2
OS: Other/Unknown
C/S: None/Unknown

I have Data entry session in LN that has DAL on the main table it using.
I have a two (2) tcclot field (Lot) that zooms to whltc1100m000 and returns whltc100.clot.

Both fields I need to filter the Item to the zoom to session that it picks up the proper Item to the corresponding Lot fields. How do I achieve this? Is it possible to create a filter query in DAL or any way to make this work?

This code does not even gets executed because I am using LN or because I am using DAL in my table?

before.zoom:"whltc100.item = " & quoted.string(cxcsb101.item.1))

selection.filter:"whltc100.item = " & quoted.string(cxcsb101.item.1))

message("Went to Zoom")"whltc100.item = " & quoted.string(cxcsb101.item.2))

selection.filter:"whltc100.item = " & quoted.string(cxcsb101.item.2))
Reply With Quote
Sponsored Links
Old 2nd December 2016, 22:35
benito's Avatar
benito benito is offline
Join Date: Jan 2002
Location: Eastern US
Posts: 520
benito is on a distinguished road
Baan: LN 10.2.1 / LN 10.5 / BaanIVc4 - DB: Oracle11/Informix - OS: Unix/Linux
From the LN programmer's guide

You can use query.extend.where() in the before.program section of UI scripts and in the hook of DAL scripts. You can use only in the selection.filter section of UI scripts.
Reply With Quote
Old 2nd December 2016, 22:47
eric.dizon's Avatar
eric.dizon eric.dizon is offline
Senior Member
Join Date: Feb 2012
Posts: 151
eric.dizon is on a distinguished road
Baan: ERP LN - DB: MS SQL - OS: 2003
The session I am zooming to is not a custom session it is a standard LN session whltc1100m000 and I don't have source code for that session. My question is why on my session none of the field events gets triggered at all...

message("Before Input")

message("Check Input")

message("After Field")

before.zoom:"whltc100.item = " & quoted.string(cxcsb101.item.1))

selection.filter:"whltc100.item = " & quoted.string(cxcsb101.item.1))
Reply With Quote

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
Programming Question mr_suleyman Tools Development 37 11th November 2016 08:14
How to deactivate Options in print forms BaBernd Tools Development 8 4th September 2015 16:47
Selection filter for standart session GrishinEV Tools Development 3 25th July 2012 14:24
Selection Filter jaycee99 Tools Development 2 3rd August 2011 17:40
Problems with ttstpqbf (filter) en@frrom Tools Development 1 19th April 2005 11:56

All times are GMT +2. The time now is 00:02.

©2001-2018 - -