find problem

[Wayne1158]

hope some one can help me. I setup a find to search on a drop down list that can be either set to Action or Completed. However when the sript runs the find it does not find all the records set to Action. Only about half of them. I have an omit in there after the find to omit all the records set to completed.

[Lee Smith]

post a copy of your script

[aaa]

Can you attach the part of your file?

[Wayne1158]

Here is the script, hope some one can see whats wrong.

Action Report

Set Window Title [ Of Window: Current Window; New Title: "Report" ]

Go to Layout [ "Action Report" (Employee) ]

Perform Find [ Specified Find Requests: Find Records; Criteria: Notes Employee ID::Action Required: "=action"

Omit Records; Criteria: Notes Employee ID::Action Required: "="

Omit Records; Criteria: Notes Employee ID::Action Required: "=completed" ]

[ Restore ]

Sort Records [ Specified Sort Order: Notes Employee ID::Date Created; ascending ]

[ Restore; No dialog ]

Show/Hide Status Area

[ Hide ]

Scroll Window

[ Home ]

[aaa]

It must work without omit. Here is your script and works clear.

a.zip

[Wayne1158]

Thanks, but still another problem. Say I have the following records in my notes database related to one person.

record 1 - Misc. text 1 Action

record 2 - misc. text 2 Complete

record 3 - misc. text 3

ok its finding the related records for this person due to it searching for ACTION. However instead of displaying the record marked ACTION in some cases it is displaying record 3 that is unmarked from the value list.

[-Queue-]

Are you doing the search in a portal or a single related ActionRequired field on the Employee layout?

[Wayne1158]

Search is being done in a portal, the search feild is a value list

[-Queue-]

Then the resulting found set should be all records which have 'Action' in at least one of their related ActionRequired fields, regardless of what the other related records contain. Is this the result you are receiving?

[Wayne1158]

Yes thats correct, but only want to display the note marked ACTION. Its definitley finding all records that have a note marked ACTION. However each person can have multiple notes in a related file. Not all are marked ACTION. All I need to do now is find some way to display only the related record marked ACTION. Curently it finds any person with any notes Marked ACTION but displays other notes that can be marked completed

[-Queue-]

Then why not perform your find in the Notes table instead of the Employee one? Or do you want to find only employee records where all related ActionRequired fields are set to action?

[Wayne1158]

Sorry about confusion, yes the find is only in the notes table. I dont want to find employee records where ActionRequired feilds are set to action. I only want to find them in the notes table and then display them in a list. Currently it finds them but if there were multiple notes for that employee then it displays one of these notes and that note is often not even set to action.

[-Queue-]

Set Window Title [ Of Window: Current Window; New Title: "Report" ]

Go to Layout [ "Action Report" (Employee) ]

Perform Find [ Specified Find Requests: Find Records; Criteria: Notes Employee ID::Action Required: "=action"

This would seem to indicate that you are performing the find on the Employee table, not the Notes table. Switch to a layout based on Notes and try it.