Using the Advanced Database Row Field

Owned by Cristian Pintea
Last updated: Oct 16, 2023
3 min read

For read-only fields, the usage is pretty straight forward as the look & feel of these fields resembles what you’re normally used to regarding single select/multi select/autocomplete fields. The values available for selection are obtained by running the SEARCH script ().

The generic field, however, is a little more complex but we assume it is normal, considering the rich functionality it provides.

You can set a value to the field, update it or clear it, all of these depending on the field’s security type configuration

Set the value of a generic field

To set a value to the field, you have two options: either search and select from existing database records or insert a new record in the database.

If you want to use an existing value, you should click the Search icon:

This launches a dialog in which you can set values to some inputs (the ones marked as ‘Searchable’ in the field config ), then trigger the Search. The results shown are obtained via running the SEARCH script ( ):

Clicking on a result will set it to the field.

If you want to insert a new record in the database, you should use the Insert option:

This will open a form with inputs for each of the configured columns and allow you to fill the desired values:

When done, click on the ‘Insert & Set’ button to do both actions at once:

  • insert the new record in the database (run the );

  • set the field’s Jira value (+ run the , if configured).

Change the value of a generic field

To change the value of a field, you have two options: either search and select from existing database records or update the currently selected record in the database.

If you want to update the record in the database, you should use the Update option:

This will open a similar form to the Insert one, except that the Primary Key value is read-only. After you update the desired values, the submit button will accomplish two actions:

  • update the database (run the );

  • set the field’s Jira value ( + run the if configured).

Clear the value of a generic field

To clear the value of a field, you have two options: either delete the record from the database or just clear the value of the field in Jira (the database record remains unchanged).

To delete the record from the database, you should use the Delete option:

This will show you a last preview of the record, submitting the action will accomplish two things:

  • delete the record from the database (run the );

  • clear the field’s Jira value (+ run the if configured).

Clearing the value of the field in Jira only is done by clicking on the Clear button:

This will not have any effect on the database record. You will still be able to find and select it in a subsequent search.