cat_item_id(...)

cat_item_id(...) / catalogue_item_id(...)

This function searches a table in the catalogue for any criteria and returns the Data record ID of the first item found.

 

Syntax

cat_item_id('table';('column';'value');('column2';'value2');...) or

catalogue_item_id('table';('column';'value');('column2';'value2');...)

 

The first parameter is the internal name of the table to be searched in the catalogue. You can obtain this by right-clicking on the desired table in the Catalogue Editor and selecting the entry Change alias name in the context menu. The internal name of the table is then displayed in the Entry field in the dialogue box that appears. You can then close this dialogue by clicking on the Cancel button.

 

You can also specify any number of search filters, but at least one. Search filters consist of a list, which consists of the name of the column as a string and the value to be searched for as a number or string. Examples of search filters are:

The brackets are necessary to identify the list and cannot be omitted.

As a return value, this function returns the record ID of the first entry that matches all search filters. If there is no matching entry, 0 will be returned.

 

Example:

Let's take a look at the table below:

 


Outdated: item_id(...), item_id_v(...), item_id_sv(...)

The following formulas have been replaced by the cat_item_id(...) function, but will continue to be evaluated if available.

These functions search for IDs from any HiCAD standard files (IPT files) based on given criteria.

Feature Parameter Formulas