Techy question on Find / Browse Form

bwilkinson

Well Known Member
Good Morning List,

On a find / Browse Form I have a View assigned , when I run the App the
Data Comes up fine. My Question is how can I apply a filter to the view
before the user clicks find. Is there a way to do it in the View or do I do
I use an ER on the form. And example of whatever way works would be a huge
help.

-Brian

William "Brian" Wilkinson
Quickie Manufacturing
Bwilkinson@quickie.com
856-829-7900 x143

JDEdwards OneWorld B7332 SP14.1
Microsoft Windows NT 4.0 Server Platform SP6a
Microsoft Windows NT 4.0 Terminal Server
Microsoft SQL Server 7.0 SP2 with hot fix 851
Microsoft Mdac 2.5
Citrix Metaframe 1.8
=========================================



William “Brian” Wilkinson
Quickie Manufacturing
Bwilkinson@quickie.com
856-829-7900 x143
 

kcobb

Member
Drop a business view field on the form and make it a filter field. If the
filter values need to be there before the form is useable by the user
consider creating processing options to send the data forward...


Good luck,

KyL Cobb
Elastic Networks
 

xller8

Member
On the form you have created, there are properties to
the data dictionary items that can be overridden.
From the dd item right click, go to properties, then
to overrides and then to default value.
Place a value in the field and make sure the checkbox
is not clicked for the default value on the top of the
page.
This will pre-populate some data - hope that helps.

Note that this populates the value for the form but it
can be overridden unless you use security.

Regards.


--- bwilkinson <bwilkinson@quickie.com> wrote:
> Good Morning List,
>
> On a find / Browse Form I have a View assigned ,
> when I run the App the
> Data Comes up fine. My Question is how can I apply a
> filter to the view
> before the user clicks find. Is there a way to do it
> in the View or do I do
> I use an ER on the form. And example of whatever way
> works would be a huge
> help.
>
> -Brian
>
> William "Brian" Wilkinson
> Quickie Manufacturing
> Bwilkinson@quickie.com
> 856-829-7900 x143
>
> JDEdwards OneWorld B7332 SP14.1
> Microsoft Windows NT 4.0 Server Platform SP6a
> Microsoft Windows NT 4.0 Terminal Server
> Microsoft SQL Server 7.0 SP2 with hot fix 851
> Microsoft Mdac 2.5
> Citrix Metaframe 1.8
> =========================================
>
>
>
> William “Brian” Wilkinson
> Quickie Manufacturing
> Bwilkinson@quickie.com
> 856-829-7900 x143
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=7429
>
> + - - - - - - - - - - - - - - - - - - - - - - - - -
> - - - - +
> This is the JDEList One World / XE Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> + - - - - - - - - - - - - - - - - - - - - - - - - -
> - - - - +
>


__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
 

Zoltan_Gyimesi

Legendary Poster
Re: RE: Techy question on Find / Browse Form

Just some minor addition to Kyl's hint:
1.) You can drop onto Form more than one BSVW field.
2.) You can populate them in the Dialog is Initialized form event or in the Button Clicked event of the Find button (it depends on your need and logic).
3.) You can hide these filter controls making them invisible for the user and prevent them to be overriden by the user.
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

bwilkinson

Well Known Member
RE: RE: Techy question on Find / Browse Form

This is what I was doing.

Created new Find /Browse Form.
Attached View V4101A
Added all fields in view to Grid.

I then run this and it works fine.
I then tried to use an ER to suppress certain Rows of the View by using the
following ER.

THIS IS ATTACHED TO THE FORM EVENT RULES
Grid Record is Fetched
If BC Address Number (F47046) is not equal to "1001258"
Suppress Grid Line(FC Grid)
End If

` I Have also tried it in the event "Write Grid Line-Before" with the same
results
The Results being that all rows are still returned. Any ideas or
suggestions on this would be a great help.

-Brian

=========================================
William "Brian" Wilkinson
Quickie Manufacturing
Bwilkinson@quickie.com
856-829-7900 x143

JDEdwards OneWorld B7332 SP14.1
Microsoft Windows NT 4.0 Server Platform SP6a
Microsoft Windows NT 4.0 Terminal Server
Microsoft SQL Server 7.0 SP2 with hot fix 851
Microsoft Mdac 2.5
Citrix Metaframe 1.8
=========================================



William “Brian” Wilkinson
Quickie Manufacturing
Bwilkinson@quickie.com
856-829-7900 x143
 

bwilkinson

Well Known Member
RE: RE: Techy question on Find / Browse Form

In the my last post I said it was view V4101A It was really V47046A.

Kyl and Zoltan I added a FIELD to the form and set it as a filter. I then
did the populate of it in the
"Dialog is Initialized" ER and It worked YE HA! My question is can I do the
same with ER , I was trying to
suppress grid rows at the time the record is fetched. Any ideas would be a
great help.

-Brian


=========================================
William "Brian" Wilkinson
Quickie Manufacturing
Bwilkinson@quickie.com
856-829-7900 x143

JDEdwards OneWorld B7332 SP14.1
Microsoft Windows NT 4.0 Server Platform SP6a
Microsoft Windows NT 4.0 Terminal Server
Microsoft SQL Server 7.0 SP2 with hot fix 851
Microsoft Mdac 2.5
Citrix Metaframe 1.8
=========================================



William “Brian” Wilkinson
Quickie Manufacturing
Bwilkinson@quickie.com
856-829-7900 x143
 

Zoltan_Gyimesi

Legendary Poster
Re: RE: RE: Techy question on Find / Browse Form

Brian,

I am really surprised because "SupressGridLine" should have to work in "GridRecordIsFetched" event.
It have just tried it on B7331 SP6 and really works fine.

My only suggestion is that create a simple brand new appl with a single form for test purpose only and try again.

Please, let us know your results.

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

bwilkinson

Well Known Member
RE: RE: RE: Techy question on Find / Browse Form

YE HA (where I got that I don't know)!

I created a new APPL.
Created a new Form.
Attached BSVW V47046A To it.
Added the ER Code and it worked this time.

Don't Know what I did different this time as opposed to the last test APPL,
but it works and I can stop pulling my hair. And ill just write it off to a
JDEdwards quirk.

One last question on the topic. Where can I find the documentation that
explains ER in Great Detail such as what all the system functions and so
forth do.

THANKS FOR THE HELP GUYS.

-Brian


=========================================
William "Brian" Wilkinson
Quickie Manufacturing
Bwilkinson@quickie.com
856-829-7900 x143

JDEdwards OneWorld B7332 SP14.1
Microsoft Windows NT 4.0 Server Platform SP6a
Microsoft Windows NT 4.0 Terminal Server
Microsoft SQL Server 7.0 SP2 with hot fix 851
Microsoft Mdac 2.5
Citrix Metaframe 1.8
=========================================



William “Brian” Wilkinson
Quickie Manufacturing
Bwilkinson@quickie.com
856-829-7900 x143
 

Zoltan_Gyimesi

Legendary Poster
Re: RE: RE: RE: Techy question on Find / Browse Form

Hi Brian,
At first congratulation to your success!

Please, consider which method will you use. Using filter fields could have performance benefits againts the SupressGridLine method, mainly working on large amount records.
On the other hand:
a.) You can combine the two method
b.) You can use more then one filter fields for the same BC field (e.g. for "Greater Than x AND Less Than y" selection criteria)
... to make more complex selections based on your needs.

In response to your last question:
The last known (for me) best collection of these types of information is in the OneWorld help (do you wonder?). Follow the path to access it:

1.) Start from the OW Explorer
2.) Select "Contents" from the Help drop-down menu
3.) Supposly you will get two help window
4.) Close the second window wich is active and has the input focus
5.) Open the "Tools, Technical and Foundation" from the remained one
6.) Select "Published APIs" from the list
7.) Open the main folder
8.) Select "System Functions"

This help is not so detailed but IMHO detailed enough to retrive useful informations and not only for System Functions but for Events, etc. in a well grouped structure.

I hope, you will find it usfull too.
Please, let me/us know if you have problem to acces the mentioned help or you have any trouble with it.

Regards,
Zoltán
P.S.: Maybe you can make a bit surfing on the KG too to retrive additional informations, tips, etc. If you find something usefull then please, share with us. Thx.


B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Top