AnsweredAssumed Answered

Nintex O365 - Query list using a calculated column as a filter?

Question asked by calmaguer on Sep 25, 2018

We know it's not an option to filter query list results with a calculated column.  In my case, I have:

 

A list with a choice column containing Status

A Date column containing "the date an item was moved into In Progress status"

A Date column (calculated) containing "Due Date"

A Date column containing "the date an item was moved into Completed status"

A number column (calculated)  containing "SLA days +/-"

A Yes/No column (calculated)  containng "SLA met?"

 

A workflow runs when an item is moved into "In Progress" and populates the date an item was moved into In Progress.

A workflow runs when an item is moved into "Completed" and populates the date an item was moved into Completed.

 

A calculation in "SLA days +/-" subtracts the date item was moved into Completed FROM the date item was moved into in progress and gets the difference, then subtracts 14 (the SLA is 14 days).

 

A calculation in "SLA met?" displays a Yes if the value is less than 0 and No if it's 0 or greater.

 

I'm trying to query the list to collect all the items where SLA was met and it's unavailable in the Query action.  I feel like I was able to do this easily on prem.

 

Any ideas?

Outcomes