Data Selection for Applications

[Rauf]

For reports I can use "Data Selection" to exclude records. How about applications?
For example, I need to exclude all employees belongs to P001 = 40,50,80,90,10,35.
For reports, I can use "List of values" in Data Selection.
For applications, should I use processing option for each entry ? If I want to specify 10 companies, do I need to create 10 PO fields?
Any other simple way to do this ?

 

[erpfun]

I have used form event rules to dictate which information displays on my custom appications in JDE.

 

[MarshallB]

Is this a custom app? A couple of things, is the on-screen query tool available in 8.12? I'm not sure when they introduced that, but a saved default query could help limit your list.
Outside of that, if this is a custom application with a custom BSVW, you could limit the data set by adding a custom table to your view, the custom table could include only those groups that you want to see, and join it to the other table(s).

 

[Rauf]

Hi MarshallB,

It is a custom application.
I could filter the records in the 'hard' way as you said. I just want to know any other simple way is available.

Thanks.

 

[clmates]

Hi

You could also use the add user selection and clear user selection in ER on applications.

or you can use a process option with a custom udc to populate excluded or included values, then on each record processed check against the udc values to include or exclude (a bit slower than data selection)

 

[Rauf]

I want the following WHERE clause,

WHERE Y5907VED = 12/12/2012
AND Y5907TOV = 0
AND (LVST != D OR LVST != T)
AND (P001 != 10 OR P001 != 060 OR P001 != 050 OR P001 != 051)

I can achieve this for UBE in a simple way. How about application, will the following give same result ?


0001 Clear Selection(FC Grid)
0002 Set Selection(FC Grid, F590711, Y5907VED, <Equal To>, FC Leave End Date New, <And>)
0003 Set Selection(FC Grid, F590711, Y5907TOV, <Equal To>, PO cTypeOfVacation, <And>)
0004 Set Selection(FC Grid, F590711, LVST, <Not Equal To>, PO cLeaveStatus1, <And>)
0005 Set Selection(FC Grid, F590711, LVST, <Not Equal To>, PO cLeaveStatus2, <And>)
0006 // Exclude the following HR Companies
0007 Set Selection(FC Grid, F060116, P001, <Not Equal To>, PO szHRCompany1, <And>)
0008 Set Selection(FC Grid, F060116, P001, <Not Equal To>, PO szHRCompany2, <And>)
0009 Set Selection(FC Grid, F060116, P001, <Not Equal To>, PO szHRCompany3, <And>)
0010 Set Selection(FC Grid, F060116, P001, <Not Equal To>, PO szHRCompany4, <And>)
0011 Set Selection(FC Grid, F060116, P001, <Not Equal To>, PO szHRCompany5, <And>)
0012 Set Selection(FC Grid, F060116, P001, <Not Equal To>, PO szHRCompany6, <And>)
0013 Set Selection(FC Grid, F060116, P001, <Not Equal To>, PO szHRCompany7, <And>)
0014 Set Selection(FC Grid, F060116, P001, <Not Equal To>, PO szHRCompany8, <And>)
0015 Set Selection(FC Grid, F060116, P001, <Not Equal To>, PO szHRCompany9, <And>)
0016 Set Selection(FC Grid, F060116, P001, <Not Equal To>, PO szHRCompany10, <And>)

 

[JMR]

First of all, your WHERE clause does not match your ER code. I'm assuming your ER code is correct because your WHERE clause will not work as written (!= with OR's is a bad combination)

So, as written, no the ER will not match the WHERE clause. But it looks like, from what I can tell you're trying to do, that the ER will work as desired. It looks like you've already written it, so test it!

My preference: Put the SetUserSelection's in the 'Find' button ButtonPress event...WITHOUT the leading ClearSelection, but with a SetSelection(append). This will allow any filter fields to be included in the WHERE clause.

In the 'Find' button PostButtonPress event...put your ClearSelection.