How to pass in multiple variables

[neilfernandez]

Hello,

Just wondering if it is possible to pass in multiple variables. I am trying by defining an extra with my attributes, I can pull up the value in my nested report query with the ## syntax as a column but when using the extra param in a where clause it bombs.

Any help is appreciated.

[bostrowski]

@neilfernandez
please reproduce where you have stuck at apex.oracle.com and send me developer login credentials to ostrowski.bartosz[at]gmail.com.

[neilfernandez]

@bostrowski
I was able to find my issue.

When having the following type of query in my nested LOV source it has issues:

select *
from table1 t1
full outer join table2 t2 on t1.dl_id = t2.document_library_id and t1.item_id = t2.item_id
where (t1.document_library_id = #DOC_LIB_ID# and t1.company_id = #COMPANY_ID#)
       or  (t2.dl_id = #DOC_LIB_ID# and t2.company_id = #COMPANY_ID#)

But when I add a new line to separate the replacement strings, it works:

select *
from table1 t1
full outer join table2 t2 on t1.dl_id = t2.document_library_id and t1.item_id = t2.item_id
where (t1.document_library_id = #DOC_LIB_ID# 
             and t1.company_id = #COMPANY_ID#)
       or  (t2.dl_id = #DOC_LIB_ID# 
              and t2.company_id = #COMPANY_ID#)

I tested on the plugin function getColumnNamesFromQuery to see what it produced. The first query produced this:

"{
"queryColumns":[
"DOC_LIB_ID#\" and t1.company_id = #COMPANY_ID"
,"DOC_LIB_ID# and t2.company_id = #COMPANY_ID"
]
}
"

The second query produced this and worked:

"{
"queryColumns":[
"DOC_LIB_ID"
,"COMPANY_ID"
,"DOC_LIB_ID"
,"COMPANY_ID"
]
}
"

The issue seems to be in getColumnNamesFromQuery when using multiple params. Seems to require a new line. I can reproduce and post here later today! Thank you.

[mathiasmaciel97]

Hi @neilfernandez,

How do you set derived column attributes to hold multiple values?

Regards,
Mathias