Work Task Report - Task Step Photos

Pictures as in Media Files attached to the task ? (Or to the task step ?)

It’s likely possible, now if you use a standard report designer thing, I’m not too familiar with how you’d accomplish that (I don’t have much experience with it), although this would definitely be possible in a Crystal Report Layout

Pictures are just BLOBs, just like Customer/Engineer Signatures done on Mobile Work Order, and my work task report does show the signatures, so it’s just a matter of joining/getting the right library item BLOB and displaying it in the report :)

The idea is for the technician to attach the image as either a media object or document. Not sure which, we’ll have to try it. 

This would then appear on the printed report. 

Like you say, it’s similar to Crystal Reports, which I used to work with years ago, it feels do-able. Just haven’t seen it in action yet.

I’ll have a go today and see if we can get something working. If you have any breakthrough let me know :)

I’ve had a go at this, but when I look at the export data from printing a Work Report, there is no reference in the data to attachments. 

See below task step data. So I guess we’d need to pass that attachment data through, as a URL I’d guess. But not sure if it can be displayed. The Report Builder tool is super frustrating to work with. 

There are likely to be more than one images/attachment per step, so this would need iterating through also.

   <TASK_STEP>

                        <TASK_SEQ>20385</TASK_SEQ>

                        <TASK_STEP_SEQ>66</TASK_STEP_SEQ>

                        <ORDER_NO>10</ORDER_NO>

                        <CREATED_BY>JAMARCHANT</CREATED_BY>

                        <CREATED_DATE>2024-08-22T10:48:02</CREATED_DATE>

                        <DESCRIPTION>Step 1</DESCRIPTION>

                        <NOTE_ID>252466</NOTE_ID>

                        <REMARK xsi:nil="1"/>

                        <CANCEL_CAUSE xsi:nil="1"/>

                        <OBJECT_CONNECTION_TYPE>EQUIPMENT</OBJECT_CONNECTION_TYPE>

                        <OBJECT_CONNECTION_TYPE_DB>EQUIPMENT</OBJECT_CONNECTION_TYPE_DB>

                        <OBJECT_CONNECTION_LU_NAME>EQUIPMENT OBJECT</OBJECT_CONNECTION_LU_NAME>

                        <OBJECT_CONNECTION_LU_NAME_DB>EquipmentObject</OBJECT_CONNECTION_LU_NAME_DB>

                        <OBJECT_CONNECTION_ROWKEY>FC45A1846D1747F6E053E45AF20A09E7</OBJECT_CONNECTION_ROWKEY>

                        <SOURCE_CONNECTION_LU_NAME xsi:nil="1"/>

                        <SOURCE_CONNECTION_LU_NAME_DB xsi:nil="1"/>

                        <SOURCE_CONNECTION_ROWKEY xsi:nil="1"/>

                        <SOURCE_REF1 xsi:nil="1"/>

                        <SOURCE_REF2 xsi:nil="1"/>

                        <SOURCE_REF3 xsi:nil="1"/>

                        <SOURCE_REF4 xsi:nil="1"/>

                        <INSPECTION_NOTE xsi:nil="1"/>

                        <GENERATE_NOTE>FALSE</GENERATE_NOTE>

                        <OBJSTATE>DONE</OBJSTATE>

                        <OBJEVENTS>InComplete^</OBJEVENTS>

                        <STATE>Done</STATE>

                        <OBJECT_SITE>1040</OBJECT_SITE>

                        <OBJECT_ID>NNG1_H19</OBJECT_ID>

                        <OBJECT_DESCRIPTION>WTG H19 (BH 92)</OBJECT_DESCRIPTION>

                        <WORK_COMPLETED>TRUE</WORK_COMPLETED>

                        <JOB_DESCRIPTION xsi:nil="1"/>

                        <OBJKEY>2042E8A2C4CF9F54E063255BF20AFF4C</OBJKEY>

                        <OBJVERSION>3</OBJVERSION>

                        <OBJID>AAAacMACcAAEQB0AAL</OBJID>

                    </TASK_STEP>

I can’t really help you with report designer logic as I’m super unfamiliar with it, that being said you have the task and task step, so that’s enough to find the attached BLOBs from the media library for sure.

That being said, I don’t know at all whether Report Designer has a way, in the report design, to do a database call to the right tables to retrieve the BLOB information, or if it NEEDS the data (including BLOB Data) to be parsed as XML and recorded as part of the resultkey xml dataset.

In Crystal Report you could iterate on this and retrieve the BLOBs quite easily as database calls, I’m just not sure if the IFS Report Designer tool offers similar capability, never really worked with it :(

@dfsjmarchant ,

I think the logic would be pull the information based on the “ConnectedObjSource”.

I’ve had a similar report built to pull pictures attached to the work task, I’’ll see if I can track my documentation down.

I would be very interested of knowing how to retrieve images / media objects from Work Tasks to Report Designer reports. 

Hello,

Has anyone found the solution?

Thank’s