#1 2021-03-02 09:26:35

jamil.mabrouk@gmail.com
Member
Registered: 2021-01-06

File selection parameter not loading list

I have a dynamic list which based on an input file (csv) returns the needed output from an oracle DataSource, below the query :
select culumn2 from my_table where  $X{IN, column1, param1}
after uploading the csv file , the list of values is not charged from the input file.

Query could not be prepared: Error preparing statement for executing the report query : SELECT * FROM (SELECT * FROM (select dn_id from directory_number where dn_num IN (?) ) wrappedQry) limitQry WHERE ROWNUM < 0 /* user: 6 */ /* report: 247422 */ /* token: 247422-6-1614676044904--710152053:0.38460852052284333 */ /* currentuser: 6 */

the file content is as below :
value1,
value2,
value3,

Last edited by jamil.mabrouk@gmail.com (2021-03-02 09:27:09)

Offline

#2 2021-03-03 13:28:35

eduardo
Administrator
Registered: 2016-11-01
Website

Re: File selection parameter not loading list

Hi jamil.mabrouk@gmail.com,

I don't quite get your configuration, can you pls post some screenshots?

You can use http://imgbb.com for this

Regards,
Eduardo

Offline

#3 2021-03-03 13:57:44

jamil.mabrouk@gmail.com
Member
Registered: 2021-01-06

Re: File selection parameter not loading list

Thanks Eduardo for your reply,

Below some screenshots from the configuration and the execution of the dynamic list :

https://ibb.co/rFtFjXh
https://ibb.co/Btc1v0C
https://ibb.co/7jcd3mj
https://ibb.co/ctkMVgJ

BR.

Offline

Board footer

Powered by FluxBB