Dynamic Query is a query that contains in the where clause one or more values of certain issue fields.
...
- Create some custom fields in JIRA and remember their ids. They should be of the form customfield_yyyyy, where yyyyy is a number. To find out a custom field id, go to Custom Fields section in JIRA administration, locate your custom field and click on Configure item from the actions menu in the right. You can then see your custom field id as a parameter in the url: /secure/admin/ConfigureCustomField!default.jspa?customFieldId=yyyyy
- After you go through the steps from the configuration page and the data source configuration page, go to Administration -> Kepler General Parameters CPRIME PLUGINS CONFIGURATION -> Database Custom Field and fill in the "Sql Query" field for the main database custom field: customfield_xxxxx with the dynamic clause of the form, for example, "WHERE col1={customfield_yyyyy} AND col2={customfield_zzzzz} OR col2={customfield_ttttt}").
- Save the configuration.
...