Filter Options
DayBackForFileMaker.FilterOptions History
Hide minor edits - Show changes to markup
https://www.seedcode.com/rootimages/stikipad/daybackonline/textfilter.png
https://archive.seedcode.com/rootimages/stikipad/daybackonline/textfilter.png
https://www.seedcode.com/rootimages/stikipad/daybackonline/ComparisonOperators2.png
https://archive.seedcode.com/rootimages/stikipad/daybackonline/ComparisonOperators2.png
https://www.seedcode.com/rootimages/stikipad/daybackonline/ComparisonOperators2.png
- Status= -cancelled ...would show all items except those that are cancelled
- Status: -cancelled ...would show all items except those that are cancelled
- Tim and Beth and Urgent - will return only events that have all three attributesTim or Beth or Urgent - will return events that have any of these three attributesTim or Beth and Urgent - will return Tim or ( Beth and Urgent )
- Tim and Beth and Urgent ...will return only events that have all three attributesTim or Beth or Urgent ...will return events that have any of these three attributesTim or Beth and Urgent ...will return Tim or ( Beth and Urgent )
- status: Hot - would find items where the status is Hot and items where the status is Hottersource: shared - would only pick up the source (calendar) named "Workload Shared", not an event in another source with "share" in the descriptionTitle: error OR Holidays In the United States - would return items with error in the title alongside all items in the calendar named: Holidays In the United StatesStatus: done OR Resource: Ann - Would return its where the status is done or the resource is set to Ann.
- status: Hot ...would find items where the status is Hot and items where the status is Hottersource: shared ...would only pick up the source (calendar) named "Workload Shared", not an event in another source with "share" in the descriptionTitle: error OR Holidays In the United States ...would return items with error in the title alongside all items in the calendar named: Holidays In the United StatesStatus: done OR Resource: Ann ...would return its where the status is done or the resource is set to Ann.
- location:* - would return only items that have a location entered.Workload Shared: * - would return everything in the "Workload Shared" calendar.Meetup OR Workload Shared: * - would return any events with "Meetup" in their text along with all events in the Workload Shared calendar.
- location:* ...would return only items that have a location entered.Workload Shared: * ...would return everything in the "Workload Shared" calendar.Meetup OR Workload Shared: * ...would return any events with "Meetup" in their text along with all events in the Workload Shared calendar.
- (vacation OR off) and James - would return any instances where James is on vacation of "off" for the day.(Proposed Value > 50000 OR Status = urgent) and Customer: Acme - would show the Acme events with more than $50k and those marked urgent
- (vacation OR off) and James ...would return any instances where James is on vacation of "off" for the day.(Proposed Value > 50000 OR Status = urgent) and Customer: Acme ...would show the Acme events with more than $50k and those marked urgent
- Status= -cancelled - would show all items except those that are cancelled- Workload Shared - show everything except the calendar named "Workload Shared". To be more explicit you could also use source: -Workload Shared
- Status= -cancelled ...would show all items except those that are cancelled- Workload Shared ...shows everything except the calendar named "Workload Shared". To be more explicit you could also use source: -Workload Shared
Parentheses
Comparison Operators
Wildcards
If you'd like to add filter criteria like this behind the scenes, so some users' are already constrained in what the can see, you can pre-filter the calendar by editing one of DayBack's FileMaker scripts.
If you'd like to add filter criteria like this behind the scenes, so some users are already constrained in what the can see, you can pre-filter the calendar by editing one of DayBack's FileMaker scripts.
Going Further
If you'd like to add filter criteria like this behind the scenes, so some users' are already constrained in what the can see, you can pre-filter the calendar by editing one of DayBack's FileMaker scripts.
%25center%25Introduced in DayBack version 10.27
Introduced in DayBack version 10.27
- Tim and Beth and Urgent - will return only events that have all three attributesTim or Beth or Urgent - will return events that have any of these three attributesTim or Beth and Urgent - will return Tim or ( Beth and Urgent )Tim and Beth or Urgent - will return (Tim and Beth) or Urgent which means events containing Tim and Beth, alongside any events containing Urgent
- Tim and Beth and Urgent - will return only events that have all three attributesTim or Beth or Urgent - will return events that have any of these three attributesTim or Beth and Urgent - will return Tim or ( Beth and Urgent )Tim and Beth or Urgent - will return (Tim and Beth) or Urgent which means events containing Tim and Beth, alongside any events containing Urgent
- status: Hot - would find items where the status is Hot and items where the status is Hottersource: shared - would only pick up the source (calendar) named "Workload Shared", not an event in another source with "share" in the descriptionTitle: error OR Holidays In the United States - would return items with error in the title alongside all items in the calendar named: Holidays In the United States
- status: Hot - would find items where the status is Hot and items where the status is Hottersource: shared - would only pick up the source (calendar) named "Workload Shared", not an event in another source with "share" in the descriptionTitle: error OR Holidays In the United States - would return items with error in the title alongside all items in the calendar named: Holidays In the United StatesStatus: done OR Resource: Ann - Would return its where the status is done or the resource is set to Ann.
You can also use AND and OR operators in your filters. When filters are chained together, the calendar will infer parentheses like this:
Field and Source Names
Coming Soon!
https://www.seedcode.com/rootimages/stikipad/daybackonline/textfilter.png
How can I use the text filter?
DayBack will filter its view against anything you type into the text filter and will look for your string in the following places:
Operators: AND & OR
You can also use AND and OR operators in your filters. When filters are chained together, the calendar will infer parentheses like this: