Advanced searching using Aproove's Query Language
Of course, Aproove has many in-built filters to help your workforce find and filter on the projects and assets that matter the most.
However, each business is different, so you need a flexible system to provide search and filter capabilities tailored to your exact business needs.
Aprooves' powerful advanced search and filter tool allows users (with appropriate permissions) to create and store searches to prevent repeating the exact search each time they use the system. The advanced search is also able to include bespoke metadata that you have stored inside Aproove.
Whatsmore (again, with the appropriate permissions), the user can not only store the search for themselves, but they can also share it with different users and groups.
When they share the search with other users, they can even give those users different permissions on the shared search. Those permissions are;
Users you share the search/filter with can then decide if they want to display the search/filter in their dashboard.
Aproove also has an "Expert" mode for advanced users, giving access to the "Aproove Query Language," allowing for queries to be built directly in the search interface with user prompts around the syntax
Get Started
The video above illustrates;
Start using your search filter
The video above illustrates;
Sharing your search filter
The video above illustrates;
Enabling a shared search filter
The video above illustrates;
For advanced users, Aproove have "Expert" search filter mode
"Expert" mode for advanced users gives access to the "Aproove Query Language," allowing for simple or complex queries to be built directly in the search interface with user prompts around the syntax.
Of course, you want to hide complexity from your users, so just as with the advanced search filters, you can save and share your expert searches and allow other users to execute those search filters with the click of a button!
Build your expert search filters!
The video above shows;
Operators Explained
Value | Description | Example |
AND | Join to filters, where both conditions need to be met | NbProof < 10 AND ProjectName = "Test Project" |
OR | Join to filters, where at least one condition needs to be met | NbProof < 10 OR ProjectName = "Test Project" |
( ) | Group filters | (NbProof < 10 OR ProjectName = "Test Project") AND ProjectDescription CONTAINS "test" |
< | Less Than | NbProof < 10 |
> | Greater Than | NbProof > 10 |
= | Equals | ProjectName = "Test Project" |
!=, <>, >< | Not Equals | NbProof != 0 |
<=, =< | Less Than or Equal | NbProof =< 10 |
>=, => | Greater Than or Equal | NbProof >= 10 |
IS EMPTY | Does not contain a value | ProjectDescription IS EMPTY |
IS NOT EMPTY | Contains any value | ProjectDescription IS NOT EMPTY |
CONTAINS | Contains a specific value, anywhere in the field, case-insensitive | ProjectName CONTAINS "test" |
+ | Add days | ProjectDeadline >= (NOW + 7) |
- | Subtract days | ProjectDeadline >= (NOW - 7) |
"Out the Box" System items with the supported operators
System | Supported Operators | Additional Information |
TasksOnTime | <, >, =, !=, <>, >=, <=, =<, =>, ><, is empty, is not empty | Number (ie TasksOnTime > 5) |
TasksAtRisk | <, >, =, !=, <>, >=, <=, =<, =>, ><, is empty, is not empty | Number (ie TasksAtRisk > 5) |
TasksDone | <, >, =, !=, <>, >=, <=, =<, =>, ><, is empty, is not empty | Number (ie TasksDone > 5) |
TasksSent | <, >, =, !=, <>, >=, <=, =<, =>, ><, is empty, is not empty | Number (ie TasksSent > 5) |
TasksPending (2022R5+) | <, >, =, !=, <>, >=, <=, =<, =>, ><, is empty, is not empty | Number (ie TasksPending > 5) |
TasksInProgress (2022R5+) | <, >, =, !=, <>, >=, <=, =<, =>, ><, is empty, is not empty | Number (ie TasksInProgress > 5) |
TasksAnswered (2022R5+) | <, >, =, !=, <>, >=, <=, =<, =>, ><, is empty, is not empty | Number (ie TasksAnswered > 5) |
TasksCanceled (2022R5+) | <, >, =, !=, <>, >=, <=, =<, =>, ><, is empty, is not empty | Number (ie TasksCanceled > 5) |
ProjectName | =, !=, <>, contains, like, is empty, is not empty | Any text in double-quotes, unless you use the IS EMPTY or IS NOT EMPTY, in which case you don't supply a value |
ProjectStatus | =, !=, <>, contains, like | One of the following: "All", "Warning", "Empty", "loaded", "loading", "Error", "Approved", "Processing", "Waiting", "Monitored" |
ProjectDescription | =, !=, <>, contains, like, is empty, is not empty | Any text in double-quotes, unless you use the IS EMPTY or IS NOT EMPTY, in which case you don't supply a value |
ProjectTreePath | =, !=, <>, contains, like, is empty, is not empty | A path, in double quotes - "Client1/Fall/CampaignA", unless you use the IS EMPTY or IS NOT EMPTY, in which case you don't supply a value |
ProjectID | <, >, =, !=, <>, >=, <=, =<, =>, >< | Number (ie ProjectId = 5) |
NbProof | <, >, =, !=, <>, >=, <=, =<, =>, >< | Number (ie NbProof > 5) |
ProjectStartDate | <, >, =, !=, <>, >=, <=, =<, =>, ><, +, - | Date and time, in double quotes, in YYYY-MM-DD HH:MM:SS format. (ie ProjectStartDate <= "2021-01-01 15:34:00"). The time portion can be omitted, and the system will assume 00:00:00. You can also use the keywords "now" or "currentdate" (without the quotes) to specify the date and time at which the search is executed. The keywords "now" and "currentdate" support adding and substracting days using + and - followed by a number (ie ProjectStartDate <= (NOW - 7) ) |
ProjectDeadline | <, >, =, !=, <>, >=, <=, =<, =>, ><, +, - | Date and time, in double quote, in YYYY-MM-DD HH:MM:SS format. (ie ProjectDeadline <= "2021-01-01 15:34:00"). The time portion can be omitted, and the system will assume 00:00:00. You can also use the keywords "now" or "currentdate" (without the quotes) to specify the date and time at which the search is executed. The keywords "now" and "currentdate" support adding and substracting days using + and - followed by a number (ieProjectDeadline <= (NOW - 7) ) |
ProjectArchived | N/A | This item is added with no operator or value. By default, the search will not include archived projects unless you add this keyword (ie TasksOnTime > 5 AND ProjectArchived) |
Is_Archived | N/A | This item is added with no operator or value. By default, the search will not include archived projects unless you add this keyword (ie TasksOnTime > 5 AND Is_Archived) |
NoteContent | =, !=, <>, contains, like, is empty, is not empty | Any text in double-quotes |
ProjectTag | =, !=, <> | The ID of the tag. The Tags dropdown will automatically insert the ID of the tag, and add a comment with the name of the tag |
SectionTag | =, !=, <> | The ID of the tag. The Tags dropdown will automatically insert the ID of the tag, and add a comment with the name of the tag |
PageTag | =, !=, <> | The ID of the tag. The Tags dropdown will automatically insert the ID of the tag, and add a comment with the name of the tag |
Custom Metadata System Items
System | Supported Operators | Additional Information |
Custom Metadata Values (any enabled values will show in the system list) | The supported operators depend on the type of custom metadata key | |
Text Keys | =, !=, <>, contains, like, is empty, is not empty | Any text in double-quotes, unless you use the IS EMPTY or IS NOT EMPTY, in which case you don't supply a value. You can also use special values "me" and "email" that resolves to the logged-in user's login and email. |
Number Keys | <, >, =, !=, <>, >=, <=, =<, =>, ><, is empty, is not empty | Numerical value, unless you use the IS EMPTY or IS NOT EMPTY, in which case you don't supply a value |
Boolean Keys | =, !=, is empty, is not empty | True, False, unless you use the IS EMPTY or IS NOT EMPTY, in which case you don't supply a value |
Date Keys | <, >, =, !=, <>, >=, <=, =<, =>, ><, +, -, is empty, is not empty |
Date and time, in double quote, in YYYY-MM-DD HH:MM:SS format. (ie ProjectStartDate <= "2021-01-01 15:34:00"),unless you use the IS EMPTY or IS NOT EMPTY, in which case you don't supply a value. The time portion can be omitted, and the system will assume 00:00:00. You can also use the keywords "now" or "currentdate" (without the quotes) to specify the date and time at which the search is executed. The keywords "now" and "currentdate" support adding and substracting days using + and - followed by a number (ieProjectDeadline <= (NOW - 7) ) |
Adding Comments to your lines
/*, */, /**, **/ | Anything enclosed in single comment tags, /* comment */, or double comment tags, /** comment **/, is ignored in the search |
Aproove WM has powerful in-built search capabilities that allow users to quickly find projects, assets, and files and even find content within the proofs themselves.
Full-Text & Content Search is a fantastic feature that enables you to find text content within your proofs. Not only can you find text content, but you are also able to apply annotations from within the search results across single or multiple search results.
Perhaps you found a misspelling in one of your proofs and want to search all the proofs to ensure it was a one-off. Maybe you want to replace a specific word or term with new copy, or you want to search for an ingredient on a packaging file or search for a product code or policy number. Whatever the reason, the Full-Text Search is user-friendly, fast, and reliable.
Get Started
Navigate your search results
Annotate your search results