Expand my Community achievements bar.

SOLVED

Proof report that filter by date a stage was activated

Avatar

Level 4

Does anyone have any code that would allow a proof approval or document version report to filter and only show proofs where a specific stage was activated in the last day? I thought about using deadline but many users don't set them so that would pull in far too many.

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi there, for a Proof Approval report, you can filter to only pending in X stage name, that should help filter it down? 

Madalyn_Destafney_0-1677607314298.png

 

If this helped you, please mark correct to help others : )

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi there, for a Proof Approval report, you can filter to only pending in X stage name, that should help filter it down? 

Madalyn_Destafney_0-1677607314298.png

 

If this helped you, please mark correct to help others : )

The following has evaluated to null or missing: ==> liql("SELECT id, subject, body, depth, post_time, author.login, author.id, author.rank, metrics.views FROM messages WHERE topic.id = '${topicId}' AND is_solution = true").data.items[0] [in template "analytics-container" at line 82, column 31] ---- Tip: It's the final [] step that caused this error, not those before it. ---- Tip: If the failing expression is known to be legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: #assign acceptedAnswer = liql("SELECT... [in template "analytics-container" at line 82, column 5] ----