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
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 9th February 2007, 12:08
Bruce21's Avatar
Bruce21 Bruce21 is offline
Member
 
Join Date: Jan 2004
Location: Austria
Posts: 46
Bruce21 is on a distinguished road
Baan: 4, ERPLN - DB: Oracle - OS: Win2000, Win2003
Set table-fields-filter on List-View which are not in the maintable
Baan: ERP LN 6.1
C/S: None/Unknown

Hello,
i have created a new session with the item table as main-table. (listgrid)
I have added now some table-references and configured it for showing on my list.
But if i try to define a new filter i can only select entries for the items.
Do you have any ideas how to solve this?
Kind Regards Martin
Reply With Quote
  #2  
Old 9th February 2007, 14:41
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,935
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
I do not understand what you really need. You have a main session with item master as the maintable. What filter did you set on this session? How did you set this filter? Was it using query.extend? More info is needed so we can make suggestions.
__________________
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 9th February 2007, 21:05
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,032
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
Mark,

Filter is a new standard tools menu item in Reger and Gemini Tools versions. It is referred to as the query browser option (QBF-ttstpqbf) in the previous BaaN releases.

Martin,

Please add more info and screen shots in your posting, others cannot guess what's your requirement or in your mind. If you are explicit then you have a better chance that others can help you out well.

Refer to the session's help -
Quote:
Filters (ttadv9593m000)
Use this session to define, or edit filters. You can use the filters to display subsets of records in an overview session, and to define a sort order.
To specify a sort order for the filtered records, click Define Sort Order on the Specific menu.
Note
The filters only apply to the records displayed in the session from which you started the Filters (ttadv9593m000) session.
Related topics
Overview of filters
To use filters
Field Description
Filter Name The name that identifies the filter.
Note
When you apply the filter to the overview session, the name appears in the session's title bar.
Field Name The field you use to filter the overview session's records.
For a record to display in the overview session when you apply the filter, the record's data in this field must satisfy the Value field by the operator you select in the Condition field.
If you define more than one field for a filter, the conditions combine to form an AND relation. That is, when you apply the filter, only records that satisfy all your filter's conditions will display in the overview session.
Note
You can only select fields that:
Are displayed in the overview session and the details session.
Are stored in the session's main table.
Attached Images
File Type: jpg filter.jpg (53.0 KB, 72 views)
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
Sponsored Links
  #4  
Old 9th February 2007, 21:36
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,935
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
I did not look to see version the post was on - I saw 4 in the user profile so that is what I thought the post was about. I'll have to look more carefully in the future.
__________________
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
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
Programming Question mr_suleyman Tools Development 37 11th November 2016 09:14
Which Set Commands Do You Use? Why? mr_suleyman Tools Development 14 16th January 2014 22:44
BW client parameters lsatenstein Tools Administration & Installation 2 31st January 2012 22:29
Tables used for MRP and PRP. BurghMan Tools Development 1 10th February 2005 15:08


All times are GMT +2. The time now is 10:05.


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