Be.Smart ERP Picker
(EN) ERP Picker
(EN) ERP Picker
  • â„šī¸What is Be.Smart ERP Picker?
  • âš™ī¸System Requirements
  • 🔑Installation & Activation Guide
  • 🆕What's New
    • Version 2.2.1.0
    • Version 2.1.3.0
  • Common information
    • Application configuration
      • Configuration file structure
      • Configuration file location
      • Configuration file parameters
        • Section [Settings]
        • Section [Mappings]
        • Section [MappingsC]
      • Examples of connections to data sources
        • Text file (txt | csv)
        • MS Excel
        • MS Access
        • MS SQL
        • Autodesk Vault
    • Overview of error messages
  • ERP Picker (Inventor add-on)
    • Basic description of functionality
    • Overview of commands
      • Be.Smart ERP Picker
        • Pick & Exit
        • Pick & Exit (Custom)
        • Export to file
        • Cancel
        • About
        • Help
        • Filtering and searching
        • Panel of additional information
      • Config
        • Edit config
        • Open folder
        • Exit
        • About
        • Help
      • About
  • ERP Picker (standalone app)
    • Basic description of functionality
    • Overview of commands
      • Export to file
      • Open folder
      • Cancel
      • About
      • Help
      • Filtering and Searching
      • Panel of additional information
Powered by GitBook
On this page
  • Default filters
  • Sheet thickness to search filter transfer
  • Examples of filtering and searching
  • Numbers
  • Text values
  • Other settings
  1. ERP Picker (Inventor add-on)
  2. Overview of commands
  3. Be.Smart ERP Picker

Filtering and searching

PreviousHelpNextPanel of additional information

Last updated 1 year ago

Above each column of the table, there is a filter and search control. The display of data in the table is adjusted according to the set filters.

The display of numeric values can be limited by the minimum and maximum values (two fields are available), while only one field is available for searching text values.

The filtering can be started by pressing Enter or automatically after a set delay. This delay can be controlled in the configuration INI file by setting the ApplyFilterDelay variable.

"Reset" of the filter can be done by emptying all filter values + confirming with the Enter key.

Default filters

The configuration can be set so that the data table is filtered by the column and value in the configuration at startup. These are the InitiateFilterDbFieldName and InitiateFilterValue parameters.

Sheet thickness to search filter transfer

The sheet metal part thickness can be used for data table filtering - i.e. the configuration can be set so that the data table is filtered according to the value read from the sheet metal part definition in Inventor already when running over the sheet metal part.

The units used to express sheet thickness are mm.

If the sheet metal part has other units set internally, the search is set by converting to a value in millimeters.

Examples of filtering and searching

The images below contain examples of filtering numeric and text values.

Numbers

Text values

Other settings

Other settings for filtering are described in chapter Section [Settings].

Filtering of numbers
Filtering by sheet metal parameters
Unfiltered data table
Display values in column Count =< 4
Display values in column Count >= 10
Display of all sheet metals with a thickness of 0.8 mm