Maximo where clause in BIRT

Hi All,

Can anyone tell me significance of where, appnum, paramstring and paramdelimiter parameters which comes with maximo report templates in BIRT? How they work in Maximo environment?

I am trying to deploy a BIRT report in two different application, in one the report works fine but not in other. As per my understanding appnum plays important role here, but I am not sure how to use it.

It would be grate if someone suggest me link or doc on the same.

Thanks in advance
Santosh

Find more posts tagged with

Comments

micajblock

These are all parameters that are passed by the Maximo application itself.

Santosh86

Thanks for reply......

I understood that where parameter pass the maximo where clause from maximo and appname parameter pass application name from maximo.

But I am still confused with paramdelimiter and paramstring. What these parameters do?

micajblock

I think paramdelimiter and paramstring are also parameters used by Maximo (although I have never used them). I think it is their way to pass additional unknown parameters.

wwilliams

From the developer guide Chapter 5;
http://publib.boulder.ibm.com/infocenter/tivihelp/v3r1/topic/com.ibm.mam.doc_7.1/pdf/mam71_report_dev_guide.pdf

Unbound parameters are passed to the report in a comma-delimited string and may contain operators, so the values must be parsed before being included in theBound and Unbound Parameters in SQL Statements
report SQL. The following method parses these values so you can include them in the report SQL:

MXReportSqlFormat.createParamWhereClause(String columnName, StringparamValue)

This method creates a SQL Where clause based on a comma separated list of
values contained in paramValue. The parameter value can be specified with a
prefix operator. The operator can be any one of these symbols: <=, <, >=, >, !=, = . If
you do not specify an operator, the system assumes that the search is based on
operator SQL LIKE as in the following example:
createParamWhereClause("siteid", "=BEDFORD,=MCLEAN")
evaluates to:
((siteid = 'BEDFORD') or (siteid = 'MCLEAN'))
createParamWhereClause("siteid", "!=BEDFORD,!=MCLEAN,TEXAS")
evaluates to:
((siteid != 'BEDFORD') and (siteid != 'MCLEAN')) or ((siteid like
'%TEXAS%'))

Siva Rao

<p>In my report maximo is passing wrong time in where parameter</p>