Hello,
I am trying to export a report from IT Shop once an attestation policy is completed. But when I click on export as csv/pdf, the exported report does not capture the action taken by the reviewer. Please see the attached screenshot. The information column is not exported in the csv or pdf file. Can someone please tell me how to make the information column viewable in the exported report?
Thanks,
Alok
Hi Geraldine,
Thanks for the reply. How can I enable this column for exporting? Should this be done in the Designer-Database Schema- AttestationCase table- Column Properties? Or is there any other way of enabling the column for exporting?
Thanks,
Alok
Hi Geraldine,
Thanks for the reply. Based on your earlier posts, I was able to make a copy of the VI_Attestation_EditCases_Default component and edit create date columns.
Regarding enabling the column export in csv or pdf, I right clicked on the Column container and exported the xml file. Can you please suggest what needs to be changed in the XML file so after exporting, this column will be displayed? Attached are the screenshots for your reference. Also, once the changes are made in the XML file, I assume I would need to import the updated XML file at the same container level.
Thanks,
Alok
Hi Alok,
see here the visibility condition:
If you delete it, then the alternative text of the images will be shown in the grid export shown below:
As you already have a object copy you can edit it.
But I still do NOT recommend what you are doing. I would add a column with the visibility condition variable("%gridexport%") = 'export', so it won't show up in the web, but will show up in the grid export.
In your case I think the text "Information" will be useless, if it is in every line.
What you need is the Attestation state. So add a column and give it the visibility condition:
variable("%gridexport%") = 'export'
Add a label in the Header row and behind text write:
translate('#LDS#Attestation state')
Then add a cell and a label to the cell and write behind the text:
Lower(if(not(select current IsClosed from AttestationCase)) then translate("#LDS#pending")
else(if(select current IsGranted from AttestationCase) then translate("#LDS#approved")
else translate("#LDS#denied")))
Regards,
Geraldine
