Confused on Find

[Jim_Shelton]

We are in FM 8.5, I have user who needs to do a search daily. Everything in the search is the same with the exception of the Ship Date. She needs to be able to enter that date. The remainder of the search is comprised of an overall search using two fields. And three omits using the same two fields with one additional field. That last field filters the omits.

 

My script works fine if the Ship Date is hard coded in. For some reason this is not making sense to me. Could use some help.

 

Jim

[David Head]

Post the script and we can have a look at it.

[Jim_Shelton]

Sure. This is what the user needs to search for, but they need to indicate a specific, Ship Date (which is a date field)

 

Go to Layout ["Eltron List PHASE 1" (Job Ticket 3)

Perform Find [specified Find Requests: Omit Records; Criteria: Job Ticket 3::Job Status; "Billed"

Omit Records; Criteria: Job Ticket 3::Job Status; "Shipped"

Omit Records; Criteria: Job Ticket 3::Job Status; "Cancelled"

[Restore]

Enter Browse Mode

[Ender]

You need to have the first request be a regular non-omitted request. Then your user will enter their criteria into that one, and omits happen on subsequent requests.

 

BTW: I think it's generally easier to read and debug scripts that don't use Restored Find settings. You can instead add Find criteria with a series of New Record/Request and Set Field[] script steps (and Omit Record, if it's an Omit criteria):

 

Enter Find Mode[]

Pause Script[]

New Record/Request

Set Field[Job Status; "Billed"]

Omit Record

New Record/Request

Set Field[Job Status; "Shipped"]

Omit Record

New Record/Request

Set Field[Job Status; "Cancelled"]

Omit Record

Perform Find[]

...

[Jim_Shelton]

Works perfect, thanks, I will remember this.

 

Jim