Baanboard.com

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

Retirement Notice

Baanboard is shutting down on 31-dec-2023. See: http://www.baanboard.com/baanboard/showthread.php?t=76043


User login

Frontpage Sponsor

Main

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
20%
Need more honesty to work with the Users until their processes are fully mapped & Users are trained
40%
Focus on process automation/ integrations/ Real time data/ BI analytics
13%
Stick to basics
27%
Total votes: 15

Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 5th October 2023, 11:35
tion1976 tion1976 is offline
Member
 
Join Date: Jan 2023
Posts: 39
tion1976 is on a distinguished road
Baan: 4,5,6,10 - DB: sql - OS: windows
Unhappy How to add filter on a field that is not part of the main table
Baan: Other/Unknown
C/S: None/Unknown

Hi,
I have the requirement to add the filter controls on a field that i added to the form but it is not part of the main table.
I see there are no fields to filter. See the screenshot.
I want to do this either programmatically or by form editor or another way.
Thanks
Attached Thumbnails
Click image for larger version

Name:	s-2023-10-05.png
Views:	48
Size:	16.2 KB
ID:	7081  
Reply With Quote
  #2  
Old 5th October 2023, 12:26
JaapJD's Avatar
JaapJD JaapJD is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 1,009
JaapJD will become famous soon enoughJaapJD will become famous soon enough
Baan: BaanIV, BaanERP, ERP LN 6.1 - DB: Oracle, SQL Server - OS: Unix, Windows
You have to add the field to the query of the session by using the query.extend[.fld].* functions. Obviously this only applies if the retrieval of the field value can be expressed in a query.
Reply With Quote
  #3  
Old 6th October 2023, 08:12
srkndnsn srkndnsn is offline
Senior Member
 
Join Date: Aug 2016
Posts: 106
srkndnsn is on a distinguished road
Baan: Infor LN 10.7/10.6/10.5 - DB: Oracle/ MSSQL - OS: Unix/Microsoft Server
Quote:
Originally Posted by tion1976 View Post
Hi,
I have the requirement to add the filter controls on a field that i added to the form but it is not part of the main table.
I see there are no fields to filter. See the screenshot.
I want to do this either programmatically or by form editor or another way.
Thanks
Hi,

If you do this with extension, you should use nested query type or you can add referenced table but you must nsure that the record
in the other table exists, otherwise the record of the main table is not displayed .

Best regards
Serkan
Reply With Quote
  #4  
Old 6th October 2023, 10:10
JaapJD's Avatar
JaapJD JaapJD is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 1,009
JaapJD will become famous soon enoughJaapJD will become famous soon enough
Baan: BaanIV, BaanERP, ERP LN 6.1 - DB: Oracle, SQL Server - OS: Unix, Windows
Serkan is right in case the main table is a standard LN table and the session is a standard session. But it seems to be a custom table. If "Nr. foaie parcurs" is just a field from a foreign table, it can be added to the query in the session script and filtering will be available.
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
Use of DAL Question metropoj Tools Development 4 10th May 2012 17:32
Add field to multioccurence session ConradMollink Tools Development 0 31st August 2009 16:43
Add one field in the filter quelle Tools Development 2 21st January 2009 08:25
Input/Ref. Expression for table field other than main table? brad997 Tools Development 8 4th November 2008 09:43


All times are GMT +2. The time now is 01:17.


©2001-2023 - Baanboard.com - Baanforums.com