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@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Peter_Vidal@xxxxxxxx
Sent: Wednesday, August 17, 2011 12:53 PM
To: mapics-l@xxxxxxxxxxxx
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.


------------------------------------------------------------------------
--------