Advanced Search

Modified on Thu, 1 Jun, 2023 at 5:33 PM

The Advanced Search in Labregister allows you to not only find everything effortlessly, but also to use it as a filter so that you can work with a selection of Items. You can use different criteria to refine your search with logical operators. In the following instructions, you can find all the information to start with this feature:


TABLE OF CONTENTS


Terminology: Criteria, Logical Operators, Conditions, Blocks, Values, and Elements/Rows

As the Advanced Search is very complex, the picture below aims to give you an overview of the terms used in this article:


Overview of Usable Criteria

Note: We are developing the Advanced Search further to also support file and relationship queries!


To refine your search, you can use the following criteria:

  • Item ID Search for a specific Item by its Item ID or use a part of the Item ID to use by the creation date. 
  • Item name: Search for an Item by its name.
  • Category Name: Search for Items in a specific Category by using the name of the Category.
  • Attribute in Category When selecting this option, you are able to enter the Attribute Name of the below listed Attributes. Depending on the Attribute Type different conditions will be displayed.
    • Short Text Attribute
    • Long Text Attribute
    • Date Attribute
    • Number Attribute
    • Hyperlink Attribute
    • Barcode Attribute
  • File name: Search for an Item by attachment name.
  • Item Relationship: Parent/Child relationship of Items:
    • Parent name: Search for all Child Items by Parent Item name.
    • Parent ID:Search for all Child Items by Parent Item ID.
    • Child name: Search for all Parent Items by Child Item name.
    • Child ID:Search for all Parent Items by Child Item ID.


Apply Advanced Search with different Elements

Note: Please note, if you haven't performed the Advanced Search and collapsed the panel, everything you entered will not be saved. If you want to check an Attribute Name, for example, please always perform the Search first and then go back to the Advanced Search afterward.


To perform the Advanced Search with different Elements, please follow the following steps:

  1. Click on Advanced Search in the right upper right-hand corner.
  2. Choose a criterion from the drop-down selection. If you select Attribute in Category, please enter the name of the Attribute you want to search/filter for. 
  3. Depending on the criterion you choose, select a condition from the second drop-down window.
  4. Enter a value to search/filter for, or, if you choose Attribute in Category and enter the Attribute name, as in this example, choose a value from the drop-down selection.
  5. Use the + icon to add an additional element to your search.
  6. Specify the logical operator (either and or or) for the new element.
  7. Repeat steps 2-4 to add all information about the second element.
  8. Repeat step 5 to add an additional element or click on the bin icon to remove the element.
  9. To clear the search, click on CLEAR and to perform the search, click on SEARCH.
  10. To collapse the panel, click the arrow in the bottom right of the advanced search panel. Please note, if you haven't performed the Advanced Search, everything you entered will not be saved. If you want to check an Attribute Name, for example, please always perform the search first.


Tip: As the Item ID follows the structure LR-YYYYMMDD-{incremental number}, it's possible to search for Items created on a specific date. To do so, select Item ID as the search criterion and "contains" as the condition. Finally, enter the date of creation in the format YYYYMMDD, for example, 20221206 for the 6th of December, 2022.


Apply Advanced Search with Blocks

Note: Currently, we have a limitation of 5 blocks, each with 5 Elements.


With blocks, the Advanced Search is even more powerful, as it enables users to set brackets around search queries, e.g., ((A and B) or (A and C)). To perform the Advanced Search with different elements, please follow the previously described steps and the steps below to add Blocks:

  1. Click on + ADD BLOCK to add a block to your Advanced Search.
  2. As described in the previous paragraph "Apply Advanced Search with different elements", you can now specify each element you want to search for.


Wildcards

As in the Simple Search, it's possible to use wildcards when specifying filter criteria. You can use them as placeholders for different characters for the Item ID, Item name, Category name or Attribute values, when "contains" or "does not contain" is chosen. Wildcards do NOT work for "is" or "is not". We support the following operators:

  • ?, matches any single character
  • *, can match zero or more characters, including an empty one
  • \, used before ? or *, disables the wildcard function

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article