[Composite Datasource]: Lookup Parameter

Elixir Repertoire Repertoire Designer
1

The following steps allow a component to lookup another datasource parameter’s values.

To give you a feel, the parameterization syntax will support a new “lookup” type as follow:

${Company Name#lookup(Fruit,CompanyName)#B}

This will create a parameter on the UI with label Company Name with a combo box that reads its values from the datasource called Fruit using the field called “CompanyName”. The default selection will be company B.

Further, the datasource “Fruit” can be either:

  • the name of a Data Source within a Report (ERD)
  • the name of a Graphic Object within a Composite Diagram (Ensemble)
  • the name of a View using view: syntax (Perspective)
  • the name of a datasource in the Repository (All)

Also, further parameters can be passed in if the datasource requires parameters:
${Company Name#lookup(Fruit,CompanyName,User=Peter,Password=Peter)#B}

This then forms the basis for incorporating Cascading support with:
${Company Name#lookup(Fruit,CompanyName,Country=${Country}#B}

You can allow looking data source in the repository:
${Company Name#lookup( repository:/Sales/Fruit.ds,CompanyName,Country=${Country}#B}