Extend relation by custom parameterized SQL of timeseries_datapoints
⟩
⟩
⟩
⟩ Extend relation by custom parameterized SQL of timeseries_datapoints

Extend relation by custom parameterized SQL of timeseries_datapoints

Perform the following steps to extend relation by custom parameterized SQL of
timeseries_datapoints
:
  1. Drag and drop the
    New Custom SQL
     from the left pane and place it next to the timeseries table.
    The
    Edit Custom SQL
     dialog box is displayed.
  2. Provide the following custom SQL query. 
    select * from public.timeseries_datapoints where timeseriesid =
    IMPORTANT: It is recommended to always specify the table with the
    public.
     nomenclature when writing custom queries. For example, to query from
    timeseries
     table, use
    select columns from public.timeseries
    .
  3. Select the
    Create a New Parameter
     option from the
    Insert Parameter
     drop-down list.
    Select Create Parameter
    The
    Create Parameter
     window is displayed.
  4. Provide the following details:
    • Name: Provide the name of the parameter.
    • Data type: Select
      Integer
       from the drop-down list.
    • Display format: Keep the default value.
    • Current value: Keep the default value.
    • Value when workbook opens: Keep the default option.
    • Allowable values: Select the
      List
       option.
  5. Select the
    When workbook opens
     option.
  6. Select
    Id(Timeseries)
     from the drop-down list.
  7. Click
    OK
    .
    Create Parameter Dialog
  8. In the
    Edit Custom SQL
     dialog box, click
    OK
    .
    Edit Custom SQL Dialog
  9. Select
    Id (Timeseries)
     from the timeseries drop-down list.
    By default,
    =
     symbol is selected in the
    Operator
     drop-down list.
  10. Select
    timeseriesid
     from the
    Custom SQL Query
     drop-down list.
  11. Click
    Update Now
    .
    Drop-down Selection
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal