Skip to main content

[en] Blue icon showing light filtering through a prism. Filter In-DB Tool

[en] Use Filter In-DB to filter records with a basic filter or with a custom expression using the native language of the database, like SQL. Use the Filter In-DB tool to query records and return records that meet the specified criteria.

[en] In-Database enables blending and analysis against large sets of data without moving the data out of a database and can provide significant performance improvements over traditional analysis methods. For more about the In-Database tool category, visit In-Database Overview.

注意

[en] While most In-DB tools do not require SQL commands, this tool requires SQL for more advanced processing.

[en] Configure the Tool

  1. [en] Select the appropriate filter type.

    • [en] Basic Filter: Use the basic filter to construct a simple query on a single field in the database.

      1. [en] Use the dropdown to select the column to filter on.

      2. [en] Use the dropdown to select an operator to use.

        [en] Operator

        [en] Meaning

        =

        [en] Equals

        [en] <>

        [en] Does Not Equal

        >

        [en] Is Greater Than

        [en] >=

        [en] Is Greater Than or Equal To

        <

        [en] Is Less Than

        [en] <=

        [en] Is Less Than or Equal To

        [en] IS NULL

        [en] Is a missing or unknown value.

        [en] IS NOT NULL

        [en] Is not a missing or unknown value.

        [en] LIKE

        [en] Is similar to a specified pattern in a column.

      3. [en] Enter the value to complete the query.

    • [en] Custom Filter: The Custom Filter acts like a SQL WHERE query. Use the custom filter to construct a more complex expression or to query from multiple fields in the database.

      1. [en] Use Insert Fields to pick from available fields to construct your expression.

      2. [en] Enter the rest of the query in the box using the native language of the database.

    注意

    [en] If a query is constructed using the Basic Filter, a read-only query displays in the Custom Filter area. If the Custom Filter option is then selected, the query is editable.

  2. [en] Validate expression here at runtime: An option that sends a query to the database to report errors contained in the expression in the results window of this tool. By default, errors are reported in the results window of downstream tools.

[en] View the Output

  • [en] T anchor: Records that meet the specified criteria.

  • [en] F anchor: Records that do not meet the specified criteria.

: