Loading Profile...
How to Report data on children on their children pages?
Hello,
I already have Reporting plugin working, however I need a bit different solution.
What we have:
Each user has own tasks page. For each task, we need to create a report (as children page). My task and report pages are based on scaffold plugin.
In my report template, there is a check list, which contains 3 options -- Completed, Partially Completed, Not completed. What I have to do is to count how many completed, partially completed and not completed tasks each user has.
Basically, the structure is:
My solution works if I put my reporting code on "Joe Black Tasks" and all reports are children on this page. However, each report is children to its task page.
I need to put my code on "Joe Black Tasks" page and gather data from My Report X pages.
What I have is:
I tried to use space-reporter:space=@self, but it didn't work.
What could you advice?
I already have Reporting plugin working, however I need a bit different solution.
What we have:
Each user has own tasks page. For each task, we need to create a report (as children page). My task and report pages are based on scaffold plugin.
In my report template, there is a check list, which contains 3 options -- Completed, Partially Completed, Not completed. What I have to do is to count how many completed, partially completed and not completed tasks each user has.
Basically, the structure is:
Joe Black Tasks --> My task 1 --> My Report 1
Joe Black Tasks --> My task 2 --> My Report 2
Joe Black Tasks --> My task 3 --> My Report 3
My solution works if I put my reporting code on "Joe Black Tasks" and all reports are children on this page. However, each report is children to its task page.
I need to put my code on "Joe Black Tasks" page and gather data from My Report X pages.
What I have is:
|| Completed Tasks | {report-block}
{local-reporter:children}
{text-filter:data:TaskStatus|include=COMPLETED}
{local-reporter}
{report-body}{report-body}
{report-footer}{report-info:report:item number}{report-footer}
{report-block} |
|| Partially Completed | {report-block}
{local-reporter:children}
{text-filter:data:TaskStatus|include=PARTIALLY COMPLETED}
{local-reporter}
{report-body}{report-body}
{report-footer}{report-info:report:item number}{report-footer}
{report-block} |
|| Not Completed | {report-block}
{local-reporter:children}
{text-filter:data:TaskStatus|include=NOT COMPLETED}
{local-reporter}
{report-body}{report-body}
{report-footer}{report-info:report:item number}{report-footer}
{report-block}|
I tried to use space-reporter:space=@self, but it didn't work.
What could you advice?
I’m confused
1
person has this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
-
Inappropriate?By the way, I think I have found a solution using:
{content-reporter:space=@self|types=page|scope=Joe Black Tasks > descendents}
-
Inappropriate?Hi Joe,
The content reporter looks correct to me however I just wanted to give some advice to help with the performance and improve scalability, the content-reporter is very flexible but the performance does not scale well over time, typically it is recommended to use local-reporter (like you were originally trying to do) where possible.
Using the same concept as your content-reporter, try using:
{local-reporter:page:descendents | source=Joe Black Tasks}
Good luck building your reports, I find them very useful as well in keeping track of things I need to do :)
Regards,
Bo Wang
CustomWare -
Inappropriate?Bo,
Firstly, thank you so much for your answer and advice.
Secondly, I have another question, a little bit complicated and I am not sure that there is a solution for this.
Let's say we already have our tasks and reports counter working. I see I have 3 reports with status "Not Completed". Is it possible, 3 to be a hyperlink, so when I click to see a list of pages/reports marked as "Not completed". Otherwise, it's not possible to keep track of my reports - I know I have 3 not completed tasks, but I have no idea which they are.
Label based solution is not acceptable for now, due to some issues.
I’m undecided
-
Inappropriate?Hi Joe,
You can try inserting a link to the page as part of the report-body (which currently looks to be empty in your example)
{report-body}
{report-info:content:title|link=true}{report-info}
{report-body}
This puts the title of the child page (in this case a report) which is a hyperlink to the page itself, which should achieve what you are aiming to do.
Give it a try and see if it works for you :)
Let me know how you go with it.
Regards,
Bo Wang
CustomWare -
Inappropriate?Hello Bo,
It works, thank you.
Find attached a picture.
Now it shows how many reports are marked as "Completed", for example, it also shows links to reports, but is it somehow possible to improve the way it displays all of this? For example,
3 -- Test Report X -- Test Report Y -- Test Report Z
Something like this. -
Inappropriate?Hi Joe,
Try using one of the other types of reports for this, for example, here is the code to show all COMPLETED tasks as a report-table (within the original table), embedded tables :)
|| Completed Tasks | {report-table:displayTitles=false}
{local-reporter:children}
{text-filter:data:TaskStatus|include=COMPLETED}
{local-reporter}
{report-column:title=Report Name|summaryValue=Total Count}{report-info:content:title|link=true}{report-info}{report-column}
{report-column:title=Report Name|summaryType=count|summaryFormat=#}{report-info:content:modifier|link=true}{report-info}{report-column}
{report-table} |
Give that a try, I also included the last person to modify the report so you can also get a sense of who is responsible for each particular report.
Hope it suits what you are looking for.
Regards,
Bo Wang
CustomWare -
Inappropriate?Hi Bo,
It works like a charm :) Brilliant work, thank you so much.
That is exactly what I am looking for.
I have several questions to be completely happy.
Firstly, is it possible to add in the table, report creator as well?
Secondly, I have fields called "Decision Maker" and "Decision needed until".
Is it somehow possible to create a report (in the same or different table) where all "pending" reports awaiting for decision to be listed? (the same as TaskStatus reports, including report name, report creator, last modifier, decision needed until (date field) and total count).
Here is my scaffold report template:
|| Name of Employee: | {list-data:TaskOwner|required=true}
{user-options:groups=empl.all}
{list-data} |
|| Project/Task name: | {text-data:Notes1|type=area|width=650px|height=15px}{text-data} |
|| Project/Task Status: | {list-data:TaskStatus|type=check}
{list-option}COMPLETED{list-option}
{list-option}PARTIALLY COMPLETED{list-option}
{list-option}NOT COMPLETED{list-option}
{list-data} |
| Fact-based reasons: | {text-data:Notes2|type=area|width=650px|height=45px}{text-data} |
|| Up to date in InLoox: | {list-data:InLooxStatus}
{list-option}Yes{list-option}
{list-option}No{list-option}
{list-option}Not Applicable{list-option}
{list-data} |
| Fact-based reasons: | {text-data:Notes3|type=area|width=650px|height=45px}{text-data} |
|| Desicion is needed ? | {list-data:DesNeeded}
{list-option}Yes{list-option}
{list-option}No{list-option}
{list-data} |
| Desicion maker: | {list-data:Desicion Maker|required=true}
{user-options:groups=empl.all}
{list-data} |
| Desicion needed until: | {date-data:Due Date|format=dd-MMM-yyyy}now{date-data} |
|| More information: | {text-data:Notes|type=area|width=650px|height=90px}{text-data} |
I’m thankful
EMPLOYEE
