Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Perform Find with 'OR'

ron G
in Script Workspace and Script Triggers

Featured Replies

I have a field: STATUS.

It usually contains: "Current", "NPD", "Late", "Suspended", "Expelled", "Deceased" or ""

I want to do a report that includes everyone who is NOT "Deceased"

It doesn't seem that FM Perform Find does NOT allow '<>' or 'NOT=' or anything like it so I used:

PERFORM FIND ["Current"]

Extend Found Set ["NPD"]

Extend Found Set ["Late"]

etc...

down to...

Extend Found Set [""]

The weird thing is that trying to extend to the found set to include blank or empty records does NOTHING??? If this is so, how do I include empty or blank STATUS values??

Thanks

  • Author

The 'right' solution was to CONSTRAIN not EXTEND the FOUND SET....

Thanks to the other related forum posts for leading me to that solution...

I want to do a report that includes everyone who is NOT "Deceased"

How about doing exactly that - by a single request to omit "Deceased"?

Create an account or sign in to comment

https://fmforums.com/topic/77010-perform-find-with-or/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.