Re: How to setup a SUBSET to filter a single value of (A+B+C+D) instead individually

Peter, have you tried creating a logical attribute using integrator in
R6?  It should be easy to do just make it equal to the fields you have
called out.  What I can't remember is whether you can subset on logical
attributes like this or not.  

Another option would be to create an SQL view with the field you need
and the key fields to the file.  Then Integrate that view as a
non-maintainable secondary to the ITEM WAREHOUSE object.  You will
definitely be able to use it with your subsets.  The benefit of this
method is it allows you do do any logic you want in your SQL view
statement (i.e. CASE statements). 

A third option is to set your subset up like the following

	WAREHOUSE		= (PROMPTED)
AND	LEAD TIME CODE	= 'M'
AND	LTPUR			<> 0
OR	WAREHOUSE		= (PROMPTED)
AND	LEAD TIME CODE	= 'M'
AND	LTREV			<> 0
OR	WAREHOUSE		= (PROMPTED)
AND	LEAD TIME CODE	= 'M'
AND	CMTLT			<> 0
OR	WAREHOUSE		= (PROMPTED)
AND	LEAD TIME CODE	= 'M'
AND	LTADP			<> 0
OR	WAREHOUSE		= (PROMPTED)
AND	LEAD TIME CODE	= 'M'
AND	LTVEN			<> 0
OR	WAREHOUSE		= (PROMPTED)
AND	LEAD TIME CODE	= 'M'
AND	LTPAV			<> 0
OR	WAREHOUSE		= (PROMPTED)
AND	LEAD TIME CODE	= 'M'
AND	LTSAF			<> 0

In this scenario the user only has to enter the Warehouse prompt 7
times! (It shouldn't be that hard! LOL)

***The following is added for Infor Development to see***
What we really need is the ability to add parentheses with in a subset
which could bring in to a more managable 
	WAREHOUSE		= (PROMPTED)
AND	LEAD TIME CODE	= 'M'
AND	(	
	LTPUR			<> 0
OR	LTREV			<> 0
OR	CMTLT			<> 0
OR	LTADP			<> 0
OR	LTVEN			<> 0
OR	LTPAV			<> 0
OR	LTSAF			<> 0
)

Tom Stieger
IT Manager
California Fine Wire


-----Original Message-----
From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]
[mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Peter_Vidal-/[email protected]
Sent: Wednesday, August 17, 2011 12:53 PM
To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]
Subject: [MAPICS-L] How to setup a SUBSET to filter a single value of
(A+B+C+D) instead individually


Hi List!!!

We are still on R6...

I need to create a subset on the ITEM WAREHOUSE that will help me do
something like this:

WAREHOUSE          = (PROMPTED)
LEAD TIME CODE     = 'M'
TOTAL PUR LEADTIME <> 0

However, I am thinking in the possibility of having this new "field"
called TOTAL PUR LEADTIME (listed before) and this should be equal to
the sum of LTPUR, LTREV, CMTLT, LTADP, LTVEN, LTPAV and LTSAF and then
use that field to subset the data.

Is this possible in the browser?  How I do this?

(Embedded image moved to file: pic13290.gif) PETER VIDAL PALL
CORPORATION SR System Analyst | WH Application Development 10540 Ridge
Rd., Suite 203, New Port Richey, FL 34654-5111
UC#: 262-2414 | Direct: 727-844-2414 | Fax: 727-815-3120 | www.pall.com

"Think like a wise man but communicate in the language of the people."
William Butler Yeats (1865 - 1939)
------------------------------------------------------------------------
--------

Attention:

This communication may contain information that is confidential,
privileged and/or exempt from disclosure under applicable law.  
If you are not the intended recipient, please notify the sender
immediately and delete the original, all attachments, and all copies of
this communication.


------------------------------------------------------------------------
--------
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.