Multi select query shows only one row

[dirk.wouters]

I use a cascading input query:

SELECT account_analytic_account.code, account_analytic_account.namefrom project_projectLEFT JOIN  account_analytic_account ON account_analytic_account.id = project_project.analytic_account_idwhere account_analytic_account.company_id = $P{company} and substr(account_analytic_account.code,1,2) = 'P-'order by account_analytic_account.code[/code]

In the input control appears only one row. If I run the query against the database it gives hundreds of rows. What is happening here?

[Alex42]

in the Input Control Tab you have the Value and Visible Columns pannel. You can add additional columns there.Hope it helps

[riodavid]

I'm not sure if it is a valid cascading input control query cause you used "$P{}". I haven't tried that yet.

But usually we use $X{} to pass the parent value to child in a cascading input control.

 

[dirk.wouters]

Changing the visible columns does not have any effect. I 've used the "$P{}" before without problems and in this case '$X{}' is not applicable.