Categories
Data set in Data Model which doesnt work
Answers
-
I'm not sure I understand your post but when I downloaded my XML file, there is nothing that corresponds to shipment debrief in it:
As for the link I wanted to create it was more of a test than anything else but before trying to make a link I would like to make it work without any link, as it doesn't atm.
Afterwards (but that will come in a second time, I don't want to bother about it now), I want to display, in my template, the shipment debrief of the stop per Shipment_GID (e.g: in the case of a multishipment report ; for shipment A display shipment debrief of stop 1 of this shipment, then display shipment debrief of stop 2 etc...and for shipment B - same thing - display shipment debrief of stop 1, then display shipment debrief of stop 2 etc) but I will probably make this work with for end loops.
0 -
I obtained the xml by clicking on export here :
But it doesn't seem to be taking the new data set into account. Do you have an email on which I can send you the xml ? Because even in advanced mode I don't have the option to attach any files to my post.
0 -
Ok so I got some help on the SQL and this is what I have now :
SELECT t1.shipment_gid, t1.ITEM_PACKAGE_COUNT as ITEM_PACKAGE_COUNT_DEBRIEF
FROM
(select t.*, row_number() over (partition by s_ship_unit_gid ORDER BY INSERT_DATE DESC) rn
FROM shipment_stop_debrief t ) t1
where rownum=1
The ITEM_PACKAGE_COUNT_DEBRIEF is now displayed in my report because i've created another field but the one I want to display here doesn't work and this must be coming from the fact that it is in a for-end loop (so I need to work on this) :
0 -
Hello,
Ok, let´s go step by step.
Can you attach the downloaded xml?
I am a litle confused, how did you obtained that xml? Was executing the data model with the new query(
SELECT ITEM_PACKAGE_COUNT FROM
(
select t.*, row_number() over (partition by s_ship_unit_gid ORDER BY INSERT_DATE DESC) rn
FROM shipment_stop_debrief t) ITEM_PACKAGE_COUNT_DEBRIEF
where rn = 1
) in the data set, or without?
BR
Carlos
0 -
Hello,
For what i´ve seen so far you have a DS named: 'archivec' where you´re shipment_debrief is connected to, and all others are connected to another DS named 'otmoltp' (this is defined has default).
This means you´re data is coming from different DB/schemas, right?
What is the types of your DS connections(jdbc/jndi/...)?
Thanks
Carlos
0 -
Well, i was thinking it could be something about the DS´s.
BTW, the shipment_debrief sql test was made on wich DS/DB?Can you run it in the same, AKA:otmoltp ?Does it still works and return data?
BR
Carlos
0 -
The problem comes from the fact that the loop is on the ITEM Data Set whereas my field is in the Shipment_Debrief Data Set. Do you know how iI can counter that ? I havent done enough research, maybe I can put several groups in this loop.
0 -
As indicated in my post from yesterday, yes I have made the changes from data source to make them all the same and the results are the same. I havent made changes to my files appart from the SQL query. As my field works when I get it out of my for-end loop, I assume the problem is coming from this loop which repeats data that come from the same table (whereas the data from item_package_count_debrief comes from another table which would make it unable to work when it is in the loop I assume)
0 -
Hello,
Before MSWord there is an issue with the Data Model has you have no data from G_1(aka Shipment_Debrief) data set.
Therefore you have no fields from G_1(aka Shipment_Debrief) dataset to use in MSWord.
This is something i´ve never seen before and not being able to run and try is time consuming.Can you create a simple sample(a script with few DB tables and some data in them and a new data model) in order to run in my DB and BIP?
BR
Carlos
0 -
One thing for the moment, like previously said: one step a time.
The DS were different - have you change them to be all the same?
Have you tried to run the data set with all DS pointing to the same?
The result is the same of the one you sent me(i attach in this)?
The data model is still the same(i don´t mind the sql query enhancements)(i also attach it)?
If answer to all these questions is 'no' provide new samples.xml and data set.xdmz, pls.
I can not run the Data model cause i do not have the tables and data.
Thanks
Carlos
0
