Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Developing Analytics Applications
Can not access dataset row across datasources
Migrateduser
Hi,
Currently we have faced a problem.
Below is our scenario, you can jump over if you want to see problems:
The data is separated to 2 parts.
The customer sequence number is coming from a messaging API, and the mobile number and customer sequence number are from JDBC database data source.
The goal is only displaying customer mobile numbers which equals to customer sequence numbers in the response xml which was returned by calling messaging API.
Example:
Database:
SeqNo Mobile
001 12345678
002 22220000
003 33330000
004 98765432
Report:
[Customer Seq No.] [Customer Mobile]
[001] [12345678]
[004] [98765432]
Where 001 and 005 are exists in the message queue response XML.
What I have done in BIRT:
2 datasources were created in BIRT report design, the "scripted data source" and the "jdbc data source". The scripted datasource will fetch the datasetRow["customerNo"] which stands for customer sequence number and the the JDBC datasource will provide the datasetRow["mobile"] and datasetRow["custSeqNo"].
The next step, a filter was created in "jdbc data source". The filter is ["customerNo"] "equalsto" datasetRow["seqNo"].
The problem is coming:
When I access datasetrow[seqNo](scripted data source mapping) from the jdbc datasource, the BIRT complier does NOT throw any error.
But there is an error when I run the report on application server, which says "invalid field name 'customerNo'".
Please help to look into this across datasource accessing datasetRow error, which does not display as an error in BIRT designer but throws an error after running the report.
Thank you.
Regards,
Yufan
Find more posts tagged with
Comments
There are no comments yet