I try to create on Project report, the list of activity link to this project.
On Cell, I write #[link_activity.refId;block=tbs:row], next right cell: [link_activity.refResponsible], next again: [link_activity.refName], and last: [link_activity.refStatus]
but nothing display.
It is not the good syntax ?
display on log file:
2019-01-25 13:36:13.926 ===== TRACE ===== SqlElement::getRefObj() : 'Activity' does not reference a valid object class
2019-01-25 14:36:43.748 ===== TRACE ===== SqlElement::getRefObj() : 'Activity' does not reference a valid object class
2019-01-25 13:41:01.985 ===== TRACE ===== SqlElement::getRefObj() : 'Ticket' does not reference a valid object class
2019-01-25 13:41:01.995 ===== TRACE ===== SqlElement::getRefObj() : 'Activity' does not reference a valid object class
2019-01-25 13:41:02.007 ===== TRACE ===== SqlElement::getRefObj() : 'Milestone' does not reference a valid object class
2019-01-25 13:42:12.320 ===== TRACE ===== SqlElement::getRefObj() : 'Ticket' does not reference a valid object class
2019-01-25 13:42:12.324 ===== TRACE ===== SqlElement::getRefObj() : 'Activity' does not reference a valid object class
2019-01-25 13:42:12.329 ===== TRACE ===== SqlElement::getRefObj() : 'Milestone' does not reference a valid object class
The log is no real issue.
We'll have a look to remove it.
Your issue is that you don't use correct codes.
You can have a help on Template Report.
In your case, I think you try and show
[link_activity.nameResponsible]
[link_activity.nameStatus]
[link_activity.refId;block=tbs:row]
does not work.
I cannot list the activities linked to the project.
Are you sure you have some activities "linked" to the project, I mean listed in "Linked Elements" ?
Your right. I was thinking that is tha activities of the project not the activities linked on project.
thks.
Another question: When I put on the report a boolean objectClass, on report it is write "1" or "0", how I could write instead "yes" or "no" or a picture OK or picture Not OK... ?
Not easy.
You can use some syntax with if .. then .. else
[onshow.image;if [val]='';then 'image0.gif'] [onshow.x;if [val]=1;then 'one';if [val]=2;then 'two';else 'more']
This will work fine to replace text or to display image in html templates.
For Office templates, you'll have to write this on a defined image (oyu'll find examples in template for PPT detail of project where we change icon depending on icon of health)
NB : we'll improve plugin so that is will propose referece to image checkedKO.png and checkedKO.png, so you'll have to reference field 'iconIdle' without having to manage if..then..else.