What is the difference between Simple, Advanced and Parameter data sets?
The Jazz Data Source for custom BIRT reports offers Simple, Advanced and Parameter data sets. What is the difference between them? when to use which?
|
One answer
|
SIMPLE Data Set lets you fetch data from a particular table. You can select which columns you want selected and which columns you want to filter on. The columns you filter on will be exposed as data set parameters. So with the simple data set, you can only express filters of the form: COL1 = val1 and COL2 = val2....
val1 and val2 can be hardcoded in the data set parameter page or can be bound to a report parameter. ADVANCED Data Set lets you fetch data from a particular table. You can select which columns you want selected. You can also type in a filter that can be something like (e.g.) (COL1 = 'bla') or (COL2 < 2) and (COL3 like param_1).... The syntax is SQL like. param_1 is a data set parameter. PARAMETER Data Set lets you fetch data from a particular table. You can select which columns you want selected but the filtering is limited to the columns you select. This data set also returns distinct rows. This data set type is usually used to feed values to the report parameters that get listed in the UI so users can pick the values from the list. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.