Tag questions

[tkilshaw]

What I'm working towards is a way to present a task completion, or non-completion summary for all salespersons. So the query on this report is:

FIND RegularUser WHERE RegularUser.AccessLevel='SalesPerson' AND RegularUser.Active='Yes' ORDER BY RegularUser.LoginName.

The following rule in a tag works:

COUNT Task WHERE (Task IN RegularUser.Tasks)

But this one does not. I get a "Syntax error at token "AND" error.

COUNT Task WHERE (Task IN RegularUser.Tasks) AND (Task.StartTime < CURRENT_DATE)

How can I do what I need?

thanks,

Terry

[aware_support]

Try this rule:

COUNT Task WHERE (Task IN RegularUser.Tasks AND Task.StartTime < CURRENT_DATE)