Part 5 - Creating the second component of the product manager dashboard

To complete the product manager dashboard, we'll make it so that the admin can filter the results based on UserDate and Status.

Source code

The following source code is shared using Confluence Storage Format, the XHTML-based format that Confluence uses to store the content of pages, page templates, blueprints, blog posts and comments.

For more information on how to use this source code on your Confluence, read the following article:

⚙️ Expand

Steps

  1. Continuing on from the Show If macro we created in Part 4, add a Deck of Cards macro under the Chart macro we already created there.
    Set its id parameter to "Admin View".

  2. Within the Deck of Cards macro, add three Card macros.
    Set their labels to "Filter By User", "Filter By Due Date", and "Filter By Status".

  3. Inside the "Filter By User" Card macro, do as follows:
    1. Add a 2x1 table, enter "Select User" in the first column and add a List Data macro in the second column.
      Set its name to "userSearch" and set its type to "auto complete"
    2. Add a User Options macro within the List Data macro.
    3. Create a Report Table macro and within it create an Expanding Reporter and set its Key and As parameters to "data:Task" and "Task" respectively.
    4. Within the Expanding Reporter macro, create a Local Reporter macro and set the Key parameter to "page:children".
    5. Within the Expanding Reporter macro, add a Text Filter macro. Set the Key and Exact Value to "data:User" and "%data:userSearch>1%" respectively.
    6. Within the Report Table add four Report columns and set their title to "Assignee", "Description", "Due Date" and "Status" respectively.
    7. In the "Assignee" Report column, add a Report Info macro and set its Key parameter to "Task>data:User".

    8. In the "Description" Report column, add a Report Info macro and set its Key parameter to "Task>data:Description".

    9. In the "Due Date" Report column, add a Report Info macro and set its Key parameter to "Task>data:Due Date".
    10. In the "Status" Report column, add a Report Info macro and set its Key parameter to "Task>data:Status".
    11. Add a Report Footer macro.
    12. Add a 1x1 table in the Report Footer macro. Color it as desired. (Orange is used in this example.)
    13. Within the Report Footer macro, write "Total Number of Tasks:" and add a Report Info macro and set its Key parameter to "Report:query>size".

  4. Inside the "Filter by Due Date" Card macro, do as follows: 
    1. Add a 2x1 table, write "Select Date" in the first column.
      Add a Date Data macro.
      Set its name to "dateSearch" in the second column.
    2. Create a Report Table macro.
    3. Within the Report Table macro, create an Expanding Reporter macro.
      Set its Key and As parameters to "data:Task"  and "Task" respectively.
    4. Within the Expanding Reporter macro, create a Local Reporter macro and set its Key parameter to "page:children".
    5. Within the Expanding Reporter macro, add a Number Filter macro.
      Set its Key and Above Value parameters to "data:Due Date>milliseconds" and "%data:dateSearch>milliseconds%" respectively
    6. Within the Report Table add four Report columns and set their title to "Assignee", "Description", "Due Date" and "Status" respectively.
    7. In the "Assignee" Report Column macro, add a Report Info macro and set its Key parameter to "Task>data:User".

    8. In the "Description" Report Column macro, add a Report Info macro and set its Key parameter to "Task>data:Description".

    9. In the "Due DateReport Column macro, add a Report Info macro and set its Key parameter to "Task>data:Due Date".
    10. In the "Status"Report Column macro, add a Report Info macro and set its Key parameter to "Task>data:Status".
    11. Add a Report Footer macro.
    12. Add a 1x1 table in the Report Footer macro. Color it as desired. (Orange is used in this example).
      Write  "Total Number of Tasks:"  and Add a Report Info macro and set its Key parameter to "Report:query>size".

  5. Inside the "Filter By StatusCard macro, do as follows:

    1. Add a 2x1 Table, write "Select Status" in the first column and add a List Data macro.
      Set its name to "statusSearch" in the second column.
    2. Within the List Data macro, add 3 List Option macros.
      Set their Value parameters to "Open", "In Progress", and "Done" respectively.
    3. Create a Report Table macro.
    4. Within the Report Table macro, create an Expanding Reporter macro.
      Set its Key and As parameters to "data:Task" and "Task" respectively.
    5. Within the Expanding Reporter macro, create a Local Reporter macro.
      Set its Key parameter to "page:children".
    6. Add a Text Filter macro within the Expanding Reporter macro.
      Set its Key and Exact Value to "data:Status" and "%data:statusSearch>1%" respectively.
    7. Within the Report Table macro, add four Report Column macros.
      Set their title to "Assignee", "Description", "Due Date" and "Status" respectively.
    8. In the "Assignee" Report Column macro, add a Report Info macro and set its Key parameter to "Task>data:User".

    9. In the "Description" Report Column macro, add a Report Info macro and set its Key parameter to "Task>data:Description".

    10. In the "Due DateReport Column macro, add a Report Info macro and set its Key parameter to "Task>data:Due Date".
    11. In the "Status"Report Column macro, add a Report Info macro and set its Key parameter to "Task>data:Status".
    12. Add a Report Footer macro.
    13. Add a 1x1 table in the Report Footer macro.
      Color it as desired. (Orange is used in this example.)
    14. Within the Report Footer macro, write "Total Number of Tasks:" and add a Report Info macro and set its Key parameter to "Report:query>size".

Macro structure

⚙️ Expand

approve YOU'RE DONE!