...
- Is – the results returned will contain the exact value entered in the search criteria field
- Is not – the results returned will contain results that contain everything except the value entered in the search criteria field
- Contains – the results returned will include any items that have the characters entered in the search criteria field
- Example – [Clients]Last_Name contains Smith will return results with clients whose last name is Smith and Smithfield
- Does not contain – the results returned will include any items that do not have the characters entered in the search criteria field
- Starts with – the results returned will include any items that have the characters entered in the search criteria field at the beginning of the field being searched
- Ends with – the results returned will include any items that have the characters entered in the search criteria field at the end of the field being searched
- Is empty – the field contains no data
- Is not empty – the field contains data
- Contains word(s) - Searches for the keyword(s). After entering the keyword(s), you have a choice between the "all words" (the field must contain all the words entered) or "some words" (the field must contain at least one of the words entered) option.
- Does not contain word(s) – will return results that don’t contain the word(s) entered in the value field
- Is or is after – when searching for a date or time, this option will search for values that are equal to or greater than the value entered in the value field
- Is after - when searching for a date or time, this option will search for values that are greater than the value entered in the value field
- Is or is before - when searching for a date or time, this option will search for values that are equal to or less than the value entered in the value field
- Is before - when searching for a date or time, this option will search for values that are less than the value entered in the value field
- Is between – this option will search for values between the two search options entered, including the values entered
- Is between (excluded) - this option will search for values between the two search options entered, and NOT include the values entered
- Equals – will search for an exact match to the search value entered
- Is different from – when searching for a number value, this option will return results that are not equal to the value entered
- Is greater than or equal to – when searching for a number value, this option will return results that are greater than or equal to the number entered in the search criteria field
- Is strictly greater than - when searching for a number value, this option will return results that are only greater than and not including the number entered in the search criteria field
- Is lower than or equal to - when searching for a number value, this option will return results that are less than or equal to the number entered in the search criteria field
- Is strictly lower than - when searching for a number value, this option will return results that are only less than and not equal to the number entered in the search criteria field
- Is between - this option will search for values between the two search options entered, including the values entered
- Is between (excluded) - this option will search for values between the two search options entered, and NOT include the values entered
- Is today – searches for current date
- Is within current - Possible values: - week (Sun-Sat) - week (Mon-Sun) - week (Mon-Fri) - month - quarter - year. These values are calculated with respect to the current date.
- Is yesterday – searches for day earlier than the current date
- Is within last - Possible values: - hours - minutes - seconds. These values are calculated with respect to the current time.
- Is within the last – searches within a given time frame. These values are calculated with respect to the current date.
- Is tomorrow – searches for the day following the current date
- Is within next – searches upcoming time frames. Possible values: - hours - minutes - seconds. These values are calculated with respect to the current time.
- Is within the next – searches within upcoming date ranges
- Is up to - The field value is less than or equal to the value entered
- Is before - The field value is strictly less than the value entered
- Starts from - The field value is greater than or equal to the value entered
- Is after - The field value is strictly greater than the value entered
- Is between - The first date must be prior to the second. The query finds fields containing the dates entered (inclusive)
- Is after and before - The first date must be prior to the second. The query does not find fields containing the dates entered (exclusive)
...
- Load – Load/import a general search that has been saved to a location outside of DVMAX
- Save – Searches that will be used frequently can be saved to a location outside of DVMAX be loaded for use in the future.
- Copy formula to Clipboard – copy the formula to paste in another location. Example of pasted result - ([Clients]Last_Name="@Smith@")&([Clients]Inactive=False)
- Reset – clear the current search and return to default query windowIf you click on the arrow in the Create new selection, you will see a number of different ways to search a selection of data
- Create new selection – will search the entire section of data
- Search in selection – if you have already performed one search, and then have chosen to do a second general search, search in selection will perform the next search only on the subset of data for which you already had displayed
- Add to selection – if you have already performed one search, and then have chosen to do a second general search, add to selection will add the results of this search to the list of results generated with the previous search.
- Remove from selection – if you have already performed one search, and then have chosen to do a second general search, remove from selection will exclude the results of this search from the previous search results Recent queries – after you have performed at least one search a recent queries option will be available. The last 10 searches performed on the workstation will be available from the pull-down menu.
8. If you click on the arrow in the Create new selection, you will see a number of different ways to search a selection of data
...