Versions Compared

Old Version 8

changes.mady.by.user Service Account

Saved on

compared with

New Version Current

changes.mady.by.user Elena Kolesnik

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

After After you complete the steps from the Configuration page are complete Configuring Power Database Fields PRO™ page, configure the Data Table Custom Field data table custom field following the steps below. You do that on the following pages:

...

Database General Configuration

  1. Log into your Jira as Admin.
  2. Go to Administration > Add-ons > DataTable Custom Field configuration page.
  3. Configure the parameters on this page.
    1. Thread Local Caching
      If you are not fully aware of what this implies,
    it is recommended
    1. we recommend that you leave the option
    off
    1. as "false".
      Because multiple calls to get the value of a SIL Script Custom Field for a certain issue are inevitable, we implemented an option to generate the value only once per HTTP request. This
    can improve
    1. improves performance, but might have
    some
    1. certain side effects.
    1. For example, if the value is
    generated
    1. generated before
    some
    1.  certain other values that it depends on are modified, the
    result
    1. result might
    not
    1.  not reflect latest updates.
    Choose from the combo box the desired
    1. Custom Field
      Here you select the necessary custom field of
    type Data
    1. the Data Table Information type, see example below.

    Image Removed
  4. Choose from the available options for 'Data Source' like in the image below:
    Image Removed
  5. If Data Source is Database, another 2 parameters are available to be configured: - JNDI name and SQL Query.(Please see the Configuration page for details.)
  6. If Data Source is set to SIL, SIL Script is the editor where you should type a script like in the image below:  

          Image Removed

...


    1. Image Added

Datatable Custom Field configuration page

After you complete steps on the general configuration page, perform the Datatable configuration.

Image Added

  1. Data Source – select data source, SIL™ or database.
    1. If you selected "Database" for the Data Source field, additional parameters become available to be configured, for more details see Configuration page.
      • JNDI name
      • SQL Query

    2. If you selected "SIL" for the Data Source field, type a script  in the SIL Script editor.
      Before saving the script, make sure the syntax is correct. You do that using the Check button. You can also check the log files if needed.

      Info
      For more examples of SIL scripts,

...

    1. see the

...

   7.  Save the settings using the "Save configuration" button.

Thread Local Caching

Note

If you are not fully aware of what this implies, it is recommended that you leave the option off.

Because multiple calls to get the value of a Data Table Custom Field for a certain issue are inevitable, we implemented an option to generate the value only once per HTTP request. This can improve performance, but might have some side effects.

...

    1. Power Scripts™ for Jira documentation.


      Image Added


  2. Click Save.

See also

Data Source Configuration

What's next

After you configure the data tables, see User Guide for details on how to use database custom fields.