...
- 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". - Within the Deck of Cards (Archived) macro, add three Card (Archived) macros.
Set their labels to "Filter By User", "Filter By Due Date", and "Filter By Status".
- Inside the "Filter By User" Card macro,do as follows:
- 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" - Add a User Options macro within the List Data macro.
- 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. - Within the Expanding Reporter macro, create a Local Reporter macro and set the Key parameter to "
page:children
". - Within the Expanding Reporter macro, add a Text Filter macro. Set the Key and Exact Value to "
data:User
" and "%data:userSearch>1%
" respectively. - Within the Report Table add four Report columns and set their title to "Assignee", "Description", "Due Date" and "Status" respectively.
In the "Assignee" Report column, add a Report Info macro and set its Key parameter to "
Task>data:User
".In the "Description" Report column, add a Report Info macro and set its Key parameter to "
Task>data:Description
".- In the "Due Date" Report column, add a Report Info macro and set its Key parameter to "
Task>data:Due Date
". - In the "Status" Report column, add a Report Info macro and set its Key parameter to "
Task>data:Status
". - Add a Report Footer macro.
- Add a 1x1 table in the Report Footer macro. Color it as desired. (Orange is used in this example.)
- 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
".
- Add a 2x1 table, enter "Select User" in the first column and add a List Data macro in the second column.
- Inside the "Filter by Due Date" Card (Archived) macro, do as follows:
- 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. - Create a Report Table macro.
- Within the Report Table macro, create an Expanding Reporter macro.
Set its Key and As parameters to "data:Task
" and "Task" respectively. - Within the Expanding Reporter macro, create a Local Reporter macro and set its Key parameter to "
page:children
". - 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 - Within the Report Table add four Report columns and set their title to "Assignee", "Description", "Due Date" and "Status" respectively.
In the "Assignee" Report Column macro, add a Report Info macro and set its Key parameter to "
Task>data:User
".In the "Description" Report Column macro, add a Report Info macro and set its Key parameter to "
Task>data:Description
".- In the "Due Date" Report Column macro, add a Report Info macro and set its Key parameter to "
Task>data:Due Date
". - In the "Status"Report Column macro, add a Report Info macro and set its Key parameter to "
Task>data:Status
". - Add a Report Footer macro.
- 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
".
- Add a 2x1 table, write "Select Date" in the first column.
Inside the "Filter By Status" Card (Archived) macro, do as follows:
- 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. - Within the List Data macro, add 3 List Option macros.
Set their Value parameters to "Open", "In Progress", and "Done" respectively. - Create a Report Table macro.
- Within the Report Table macro, create an Expanding Reporter macro.
Set its Key and As parameters to "data:Task
" and "Task" respectively. - Within the Expanding Reporter macro, create a Local Reporter macro.
Set its Key parameter to "page:children
". - Add a Text Filter macro within the Expanding Reporter macro.
Set its Key and Exact Value to "data:Status
" and "%data:statusSearch>1%
" respectively. - Within the Report Table macro, add four Report Column macros.
Set their title to "Assignee", "Description", "Due Date" and "Status" respectively. In the "Assignee" Report Column macro, add a Report Info macro and set its Key parameter to "
Task>data:User
".In the "Description" Report Column macro, add a Report Info macro and set its Key parameter to "
Task>data:Description
".- In the "Due Date" Report Column macro, add a Report Info macro and set its Key parameter to "
Task>data:Due Date
". - In the "Status"Report Column macro, add a Report Info macro and set its Key parameter to "
Task>data:Status
". - Add aReport Footer macro.
- Add a 1x1 table in the Report Footer macro.
Color it as desired. (Orange is used in this example.) - 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
".
- Add a 2x1 Table, write "Select Status" in the first column and add a List Data macro.
...