Using SQL to update the status and why Page Properties report could not get the lastest status ?

Question

Hi Everybody ,

I need your help on this problem.

I am using Page properties and Page properties report in confluence.

when I used SQL to update the status in Page Properties and then used Page properties report to sync allover summary from page properties.

why Page properties report  could not get the lastest status (This status changed by SQL)?? Anyone can help me to fix thsi problem ? very grateful

page properties :

the status is "123".

Using SQL to update the Auto-track Status Date to "Very late"

page properties as below , (after SQL )

Page properties report as below ? why could not get lastest status "Very late"

Page properties report

Lawrance Huang · Answer

Thanks. Stiltsoft support

I got it. I will use Table Excerpt Include macro to replace Page properties Marco.

Thanks for the help.

Stiltsoft support · Answer

Hi @Lawrance Huang ,

Please refer to our support.

Attach page storage formats of the two pages: your master page where you collect your report and one of your child pages.

From your screenshot I see that smth is still wrong: your Table Excerpt Include macro is wrapped in the Page Properties macro. And you need to collect your tables via the Table Excerpt Include macro only.

On the upper screenshot you've chosen the name of your Table Excerpts (ABS), then you choose from what pages you need to collect your Table Excerpts (pages with specific labels, child pages, etc.) and then you tick the "Show as a report table" option.

The Table Excerpt Include macro then collects all your Table Excerpts with the ABS names and builds a master report. You don't need Page Properties/Page Properties Report macros for the case at all.

Lawrance Huang · Answer

Hi Stiltsoft support

I tried your suggestion way.

But still not workable.

Would you help me to find others way to solve this problem ?