Jump to content
  • 0

View filter criteria questions



Is there a way to create views that do either of the following. I think I need to do these in a view, not a report, because I want these criteria pre-selected, and the report to allow users to select only their own date range.

1) I want to filter our records to include people who live in one of 6 - 10 specified states. Can you designate multiple criteria for a single field using "OR" logic?

2) I want to filter a table on 2 fields, showing records that have the specified values in either field, but not necessarily both. It looks as if the view filter defaults to "AND" logic. Is there a way to filter a view with "OR" on different fields?

Thanks for any information or suggestions how to handle this.

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0


Both requests are available on a Report DataPage like explained in the response above. However, they are not a standard features in a view. There's no good way to achieve the first request in a view for now. However, there is a workaround for your second request, which is to combine both fields you'd like to search on into one big field. Then create a view to perform "contains" search on that concatenated field.

Hope this helps.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...