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

We found a solution to retrieve images to either work tasks or work steps and one photo / item is printed to the work task report. The solution is quite technical as there is no standard solution for this.

1. We created custom fields to the work task and work task step page in IFS Cloud. The intent with these custom fields is that they retrieve the media item id that is attached to e.g. to the work task and has the media print option set to TRUE.  
2. In report designer we added a image element to the layout and connected the above custom field to a SQL query statement that retrieve the media item id (note one result should only be retrieved)

   

    

Now users attach media items to the work task or work steps. After the image is attached to the work task or task step the user needs to open the “manage media” page and change the “Media Print Option” to “PRINT”

After this the image is printed to the work task report.