Page Comparison

The Column which you want to get data. Columns are fetched from the database.

Please be sure the connection with the database is successful.

It is possible to define different delimiters for different attributes.

This field available for Asset List, Asset List By Form, Checkbox, List Box - Multiple, Jira Multiple Users attributes. 

The concatenator is for the concatenate more than one query columns.

Example: 

Assume that for an Employee asset type, the asset name field needs to imported from two different columns like first_name and last_name

and concatenator is defined as "-". The asset name field will be imported as First-Name.

The identifier is to search if the imported asset is existing in the system. If asset exist, the asset will be updated.

Otherwise, new asset will be created.

Decide which way to fill asset list fields.

If Query Column selected, the asset name search will be held with the imported value.

(For Example: referenceAssets("asset.name", "imported value"))

With the given parameters if multiple assets found in search result, decide match:

      ALL: References all found assets

      FIRST: References the assets with the lowest ID

      NONE: References none of them

referenceAsset("asset.name", "${asset_name}", "Country", "Turkey", "City", "${city})
referenceAssetByType("Employee", "asset.name", "${asset_name}")To perform an EXACT query, surround the variable with an escaped double quotes: "\"${c_emp_id}\""For example:Search ScriptCurrent row valueAssets to match matchreferenceAssetByType("Employee", "Employee ID", "${c_emp_id}")Emp 001Emp 001Emp 002referenceAssetByType("Employee", "Employee ID", "\"${c_emp_id}\"")Emp 001Emp 001

The value between "${}" must be the name of the column of the database from where you get the search parameter.

For example:

     At the first line of the Scripted Column referenceAsset() function will get the asset.name and City fields parameters from the columns asset_name and city of the database.