Summary

"Sort by" function in "Page Properties Report" macro not working when key/value pair missing in one of the source pages which are being pulled into the macro.

Steps to reproduce

1. Create Page A with page properties macro with below key/value pairs.

   Target Date	09 Jan 2019
   Team	Lions
   Status	Triage
   id	900

2. Add label "test_lable" to Page B
3. Create Page A with page properties macro with below key/value pairs.

   Target Date	09 Aug 2018
   Team	Tigers
   Status	In Progress

4. Add label "test_lable" to Page B
5. # Create Page C with page properties macro with below key/value pairs.

   Target Date	09 Nov 2018
   Team	Deers
   Status	QA
   id	250

6. Add label "test_lable" to Page C
7. Now, create a new page Main Page and insert Page Properties Report macro. Configure the macro to pull the pages with label "test_lable" and add columns Target Date, Team, Status and id to show in the page and sort the content by "id" column.

Expected result

Page Properties Report macro in Main Page should sort the content and display as below.

Actual result

Content doesn't sort as expected.

Notes:

It's also observed that if the key/value pair font format is not same across all the pages, sort may not work as expected.

Workaround

Add key/value pair which is being used for sorting across all the pages so that sorting works as expected. (This does not work)