The Scripts tab allows you to configure the field’s scripts that will be run for each of the operations that the field supports. The supported operations can vary depending on the field’s display type.
For read-only fields, only a subset of operations are supported: DEFAULT, GET and SEARCH. More details here Configuring scripts for read-only fields
The generic fields allow you to configure the full list of operations: DEFAULT, GET, SET, INSERT, UPDATE, DELETE, SEARCH, SEQ. For a more detailed presentation check out Configuring scripts for generic fields
By default, the scripts are expected to contain SQL syntax, notice the lozenge next to each of the operations. If needed, SIL scripts can be used instead. To switch between the script types, simply right-click on the operation and select the desired option:
You don’t need to align all operations to the same script type, a mix of the two (SQL and SIL) is perfectly fine.
The presence or absence of scripts for each operation is highlighted by writing the operation label in a certain color. Operations marked in green already have a script configured, while the operations marked in red are lacking scripts.
For SIL scripts we offer the Check functionality that allows you to verify a script’s syntax but for SQL we don’t have it. Please make sure that the SQL scripts that you configure are syntactically correct in relationship with the DBMS that you are using.
When selecting a certain script, an extra Details panel opens:
For each script you are able to use extra parameters, which can be either screen or issue Jira fields (standard or custom fields). More details on how to use script parameters here How to Use Script Parameters