Data Source

What is it?

• In the Rule Decision Table Data definition screen,

• when the parameter value needs to be selected via a combobox (dropdown list),

• this definition is made to populate the combobox list.

How is it Defined?

->

All data sources are listed on the page.

The data source definition screen opens via the button.

The data source’s code, name, and type are specified.

The data source is saved by clicking the button.

Data Source Type: SQL

• When SQL is selected as the data source type;

• you can create a data source using an SQL query to fetch data either from the database used by Pulsar or from another database you define.

• It is also possible to configure a connection to a different database.

🔍 SQL Query Format

• Your query should return "text" and "value" fields in the SELECT clause.

• Additionally, the query must be able to accept parameters.

Example format:

SELECT column_name AS text, id_column AS value FROM table_name WHERE condition = :${PARAM1}

Adding parameters to the query is not mandatory.