Find based on global fields -- HELP!

[jgoldston]

I know I have seen it somewhere in this forum -- maybe a scripting post -- I have looked all day -- Please Help!

I have a child db with line items of a master record. From the child db I have created a query layout to set the perameters of a report (backlog report). The script I have created sets all 4 parameter globals to empty upon execution. The user then defines the report. All is good in tinsel-town -- how then do I take these parameters and script a find request.

For instance:

Customer = Ace's Towing (From Value list) - Find

Report Aging = 90 Days (30 / 60/ 90/ Complete) - Find based on Calc If statement

Report Type = Full (Full / Standard) - Layout Choice

Sort = Due Date (Customer / Due Date / Part # / Department) - Sort by If statement

I want the script to

Find all records >0 qty due

and

<90 days from Status(CurrentDate)

then

Go to layout Full

Sort by Due Date

Go back to Original Layout

I cannot find anywhere in the scripting set up the If for find.

I know that there are wiser people out there than me -- and have read your past posts -- can you help this degenerate from So. Cal?

Look forward to your solutions!

James Goldston

[kenneth2k1]

There are a few ways to do this, so you may receive several different replies. Have you already defined the aging field calc and sorts? If so, it seems like you have already set up your script but just need to apply it!

Enter Find Mode [ ]

Set Field [qty due, ">0"]

Set Field [Report aging, "<90"]

Perform Find [ ]

Go to layout [Full]

Sort[Restore]

Go to layout [Original]

This is a hard-coded way of doing the search. If you want to have the info from your globals be the search criteria, use:

Set Field [qty due, g_QtyDueSearch]

Set Field [Report Aging, g_ReportAgingSeach]

These steps set the qty due and Report Aging fields to the data in the global fields (the "g_" fields are the globals). Also, you do not really need a group of global fields to be your search fields.

If you have not set up your aging field or sort, then it won't work. If you need help with setting up your aging field, get with me offline, and I can get you some "resources" that explain the aging calc field perfectly. Contact me at the e-mail address my profile provides.

You can also:

Go to layout [search Layout] - this can be a regular layout with the fields you want to search on it

Enter Find Mode [Pause]

***Enter seach criteria****

Perform find

By the way, why would you want the script to go to one layout, sort, and then just go back to the original layout? If you are generating a report, you may want to put a print command when the find has completed.

Ken