Eclipse Community Forums: BIRT » where clause for parameter with blank value

Home » Archived » BIRT » where clause for parameter with blank value

where clause for parameter with blank value [message #183543]

Tue, 08 August 2006 18:11

Eclipse User

Originally posted by: reshmabhat.yahoo.com

hi,

i have a query which is like this

select table1.col1, table5.col3, sum(table3.col2)
from table1, table2, table3,..., table12
where table1.col1=table2.col3 and table2.col4=table3.col2... and so
on(just natural joins)
group by table.col1, table5.col3

i have a input parameter(have defined it as text filed) which shd go in
where clause of the above query.
this parameter say, param1(to be binded to table5.col3) can take a value
55101 or be empty in that case, i need to have all the rows of table5.col3
as the values for param1 in my "where table5.col3 = ?"
my where clause has table5.col3 = ? along with above mentioned joins.

how to write my query as well as define default value for param1/default
value for corresponding parameter defined for dataset so that i can get
this done?

i use webviewerexample application to run my reports. i just call my
test.rptdegign, dont pass any parameters...

thanx in advance.

Re: where clause for parameter with blank value [message #183551 is a reply to message #183543]

Tue, 08 August 2006 18:14

Eclipse User

I think using subselect/subquery during the dsign of the report you can
solve the problem. Birt has the flexibility of writing the subquery
directly into the sql during the design time. So you can write like this

where table2.col2 in (select col3 from table3)

Re: where clause for parameter with blank value [message #183578 is a reply to message #183551]

Tue, 08 August 2006 22:55

Eclipse User

Originally posted by: reshmabhat.yahoo.com

i want to design my report n not able to construct my query. i want a
query which looks like this.

"select col1, col2 from table1" to this i want to add "where col1 = ?"
only if i have a non null/non blank value being passed as the parameter.
if the parameter is blank/null i dont want the where clause at all.(in
other words its like having just "select col1, col2 from table1" in the
query. pls, note no where clause here. that wud result in not imposing any
restriction on col1 field thru' input parameter & retreiving all the
records from table1)

can someone suggest me how to do this?

thanx in advance.

Re: where clause for parameter with blank value [message #184174 is a reply to message #183578]

Wed, 09 August 2006 19:51

Eclipse User

I not certain this is what you are looking for but you should be able to do
something like:

if(params["city"] == null || params["city"].length <=0){
"select * from offices";
}else{
"select * from offices where CITY = " + "'" + params["city"] + "'";
}

Jason

"Reshma" <reshmabhat@yahoo.com> wrote in message
news:90d3489215c86227e6b0a6ae0a56abfc$1@www.eclipse.org...
>i want to design my report n not able to construct my query. i want a query
>which looks like this.
>
> "select col1, col2 from table1" to this i want to add "where col1 = ?"
> only if i have a non null/non blank value being passed as the parameter.
> if the parameter is blank/null i dont want the where clause at all.(in
> other words its like having just "select col1, col2 from table1" in the
> query. pls, note no where clause here. that wud result in not imposing any
> restriction on col1 field thru' input parameter & retreiving all the
> records from table1)
> can someone suggest me how to do this?
>
> thanx in advance.
>

Re: where clause for parameter with blank value [message #184209 is a reply to message #184174]

Thu, 10 August 2006 11:30

Eclipse User

Originally posted by: reshmabhat.yahoo.com

Hi Jason,

Yes, this is what I want. But I tried doing as what you said, dint get
success. I'm not sure, I did everything correctly as you said.

Here it goes...

I have a table called 'customers' & one of the columns is 'city' on which
I need to apply conditions.

I have created a datasource.
my dataset has the following query

select *
from customers
where city = ?

I have a parameter say,
name = cityparam
data type = string
direction = input/output
default value = "Brisbane"

set in my dataset as Parameters.

my dataset Property Binding has

if (params["paramCity"].length <= 0) {
"select * from customers;"
}
else {
"select * from customers where city = " + " ' " + params["paramCity"] + "
' ";
}

I have paramCity as report parameters that is of type string.

In dataset parameter binding option for my table i have
Parameter = cityparam
Data type = string
value = params["paramCity"]

When I place my report in my server(tomcat), & run it, i get the page to
enter input parameter for City & after that i dont get any errors or
anything. I have value in the customers table of my database(MS SQLSever
2000).

if i see in my report's preview button i see this error

The following items have errors:

Table (id = 4):
+ Cannot set the string value for parameter: 1
Cannot set preparedStatement parameter string value.
SQL error #1: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter
binding(s).

odaconsumer.CannotSetStringParameter ( 1 time(s) )
detail : org.eclipse.birt.data.engine.core.DataException: Cannot set the
string value for parameter: 1Cannot set preparedStatement parameter string
value.SQL error #1: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid
parameter binding(s). at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.d oSetString(PreparedStatement.java:3654)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etString(PreparedStatement.java:3332)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etParameterValue(PreparedStatement.java:2736)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etParameterValue(PreparedStatement.java:2681)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.setInp utParameterBinding(DataSourceQuery.java:545)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.addPar ameterDefns(DataSourceQuery.java:326)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:251)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:271)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:226)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:366)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:139)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:122)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:112)
at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:208)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1541)
at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:62)
at
org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:74)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:123)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
at
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:187)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
Source) at
org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.CertificatesValve.invoke(Certific atesValve.java:246)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardCont ext.java:2422)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(Error DispatcherValve.java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(E clipseErrorReportValve.java:153)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapte r.java:199)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:828)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:700)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp oint.java:584)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:595)Caused by:
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot set
preparedStatement parameter string value.SQL error #1:
[Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).
at
org.eclipse.birt.report.data.oda.jdbc.Statement.setString(St atement.java:526)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.setString(OdaQuery.java:711)
at
org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.d oSetString(PreparedStatement.java:3647)
... 64 moreCaused by: java.sql.SQLException: [Microsoft][SQLServer 2000
Driver for JDBC]Invalid parameter binding(s). at
com.microsoft.jdbc.base.BaseExceptions.createException(Unkno wn Source) at
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at
com.microsoft.jdbc.base.BasePreparedStatement.validateParame terIndex(Unknown
Source) at
com.microsoft.jdbc.base.BasePreparedStatement.setObjectInter nal(Unknown
Source) at com.microsoft.jdbc.base.BasePreparedStatement.setString(Unkn own
Source) at
org.eclipse.birt.report.data.oda.jdbc.Statement.setString(St atement.java:522)
... 66 more

Am I doing something terribly wrong?
Pls help me.

Thanx

Re: where clause for parameter with blank value [message #184246 is a reply to message #184209]

Fri, 11 August 2006 11:45

Eclipse User

Do not use a dataset parameter at all in this case.
Just use a report parameter.
You query should just be select * from customer.

Your property binding is fine.

Jason

"Reshma" <reshmabhat@yahoo.com> wrote in message
news:52d59040080b51af855ca0901f2dc6d7$1@www.eclipse.org...
> Hi Jason,
>
> Yes, this is what I want. But I tried doing as what you said, dint get
> success. I'm not sure, I did everything correctly as you said.
>
> Here it goes...
>
> I have a table called 'customers' & one of the columns is 'city' on which
> I need to apply conditions.
>
> I have created a datasource.
> my dataset has the following query
>
> select *
> from customers
> where city = ?
>
> I have a parameter say, name = cityparam
> data type = string
> direction = input/output
> default value = "Brisbane"
>
> set in my dataset as Parameters.
>
> my dataset Property Binding has
>
> if (params["paramCity"].length <= 0) {
> "select * from customers;"
> }
> else {
> "select * from customers where city = " + " ' " + params["paramCity"] + "
> ' ";
> }
>
> I have paramCity as report parameters that is of type string.
>
> In dataset parameter binding option for my table i have
> Parameter = cityparam
> Data type = string
> value = params["paramCity"]
>
> When I place my report in my server(tomcat), & run it, i get the page to
> enter input parameter for City & after that i dont get any errors or
> anything. I have value in the customers table of my database(MS SQLSever
> 2000).
>
> if i see in my report's preview button i see this error
>
>
>
> The following items have errors:
>
> Table (id = 4): + Cannot set the string value for parameter: 1
> Cannot set preparedStatement parameter string value.
> SQL error #1: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter
> binding(s).
>
> odaconsumer.CannotSetStringParameter ( 1 time(s) )
> detail : org.eclipse.birt.data.engine.core.DataException: Cannot set the
> string value for parameter: 1Cannot set preparedStatement parameter string
> value.SQL error #1: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid
> parameter binding(s). at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.d oSetString(PreparedStatement.java:3654)
> at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etString(PreparedStatement.java:3332)
> at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etParameterValue(PreparedStatement.java:2736)
> at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.s etParameterValue(PreparedStatement.java:2681)
> at
> org.eclipse.birt.data.engine.executor.DataSourceQuery.setInp utParameterBinding(DataSourceQuery.java:545)
> at
> org.eclipse.birt.data.engine.executor.DataSourceQuery.addPar ameterDefns(DataSourceQuery.java:326)
> at
> org.eclipse.birt.data.engine.executor.DataSourceQuery.prepar e(DataSourceQuery.java:251)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:271)
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:226)
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:366)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:139)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:122)
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:112)
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:208)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1541)
> at
> org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:62)
> at
> org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:74)
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:123)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:187)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
> at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:247)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:193)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:256)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:191)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
> at
> org.apache.catalina.valves.CertificatesValve.invoke(Certific atesValve.java:246)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
> at
> org.apache.catalina.core.StandardContext.invoke(StandardCont ext.java:2422)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:180)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(Error DispatcherValve.java:171)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
> at
> org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(E clipseErrorReportValve.java:153)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:174)
> at
> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
> at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapte r.java:199)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:828)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:700)
> at
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp oint.java:584)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:683)
> at java.lang.Thread.run(Thread.java:595)Caused by:
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot set
> preparedStatement parameter string value.SQL error #1:
> [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).
> at
> org.eclipse.birt.report.data.oda.jdbc.Statement.setString(St atement.java:526)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQu ery.setString(OdaQuery.java:711)
> at
> org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.d oSetString(PreparedStatement.java:3647)
> .. 64 moreCaused by: java.sql.SQLException: [Microsoft][SQLServer 2000
> Driver for JDBC]Invalid parameter binding(s). at
> com.microsoft.jdbc.base.BaseExceptions.createException(Unkno wn Source) at
> com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at
> com.microsoft.jdbc.base.BasePreparedStatement.validateParame terIndex(Unknown
> Source) at
> com.microsoft.jdbc.base.BasePreparedStatement.setObjectInter nal(Unknown
> Source) at com.microsoft.jdbc.base.BasePreparedStatement.setString(Unkn own
> Source) at
> org.eclipse.birt.report.data.oda.jdbc.Statement.setString(St atement.java:522)
> .. 66 more
>
> Am I doing something terribly wrong?
> Pls help me.
>
> Thanx
>
>

Re: where clause for parameter with blank value [message #184248 is a reply to message #184246]

Fri, 11 August 2006 12:36

Eclipse User

Originally posted by: reshmabhat.yahoo.com

Thanx a ton, Jason.
Its working :)

I have to build little complex query that has some multiple joins & group
by with that. Let me check whether I can get the output for that too.

One more question, can I use queryText var, to get the query written as my
query & append it in property binding? If so, do i need to write it in
beforeOpen() method?

Need some input on this.

Thanx again.

Re: where clause for parameter with blank value [message #184250 is a reply to message #184248]

Fri, 11 August 2006 12:59

Eclipse User

queryText will not work in property binding but will work in the beforeOpen.

Jason

"Reshma" <reshmabhat@yahoo.com> wrote in message
news:725d504f90d3da26813aa34be0ec1dfe$1@www.eclipse.org...
> Thanx a ton, Jason.
> Its working :)
>
> I have to build little complex query that has some multiple joins & group
> by with that. Let me check whether I can get the output for that too.
>
> One more question, can I use queryText var, to get the query written as my
> query & append it in property binding? If so, do i need to write it in
> beforeOpen() method?
>
> Need some input on this.
>
> Thanx again.
>

Re: where clause for parameter with blank value [message #184342 is a reply to message #184250]

Fri, 11 August 2006 13:22

Eclipse User

Originally posted by: reshmabhat.yahoo.com

oh ok.

where to use beforeOpen?

thanx

Re: where clause for parameter with blank value [message #184495 is a reply to message #184342]

Mon, 14 August 2006 02:07

Eclipse User

On the beforeOpen of the Data Set.

Jason

"Reshma" <reshmabhat@yahoo.com> wrote in message
news:dcd861a279d2c30acf0e1aec8500c80e$1@www.eclipse.org...
> oh ok.
>
> where to use beforeOpen?
>
> thanx
>

Re: where clause for parameter with blank value [message #184626 is a reply to message #184495]

Mon, 14 August 2006 10:34

Eclipse User

Originally posted by: reshmabhat.yahoo.com

Thanks a ton, Jason.

Is there any help page telling abt all these?

Re: where clause for parameter with blank value [message #184721 is a reply to message #184626]

Mon, 14 August 2006 12:34

Eclipse User

I am updating this page
http://www.eclipse.org/birt/phoenix/deploy/reportScripting.p hp

You can also check online help.

Jason

"Reshma" <reshmabhat@yahoo.com> wrote in message
news:9041bd21f10354cda69d5c789c16f647$1@www.eclipse.org...
> Thanks a ton, Jason.
>
> Is there any help page telling abt all these?
>

Previous Topic:	Version 2_0_2?
Next Topic:	Jason, can you help me?

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Aug 30 04:54:12 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter