Adding Multiple Values to Query Expressions
  • 20 Sep 2022
  • 1 Minute to read
  • Dark
    Light
  • PDF

Adding Multiple Values to Query Expressions

  • Dark
    Light
  • PDF

You can copy a list of multiple values from an external file into the Query Wizard by using the In operator to streamline the process. Multiple values from an existing list can be separated by a comma, semicolon, Enter, or Tab key. In addition, you can copy the values listed in the Query Wizard to an external file.

To copy a list of multiple values to Query Expression

  1. From an external text editor or spreadsheet, highlight the list of values and right-click and select Copy from the dropdown. The values are copied to the Clipboard.

  2. From the Query, select a query expression, such as Host Name.

  3. From the dropdown to the right of the query expression, select in.

  4. From the dropdown to the right of the in selection, right-click and select Paste. Alternatively, select Ctrl+V or Command+V (depending on your OS). The values from the Clipboard are pasted into the Query Expression.
    InQuery

  5. Deselect a value from the list by clicking the value. Toggle DownArrow (Down Arrow) to collapse/expand the list. Click Clear All to remove all values from the list.

To copy a list of multiple values to an external file

  1. From the Query, select a query expression, such as Host Name.
  2. From the dropdown to the right of the query expression, select in.
  3. If the list is collapsed, click DownArrow (Down Arrow) to expand the list.
  4. Exclude a value from the list by clicking its value.
  5. Copy the values in the list by selecting Copy Selected Tags.

CopyTags

  1. From your text editor or spreadsheet, select Ctrl+V or Command+V (depending on your operating system). The values are pasted into the external file and separated by commas.

What's Next
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.