Question

I am using FormQueries to help generate weekly reports (in the form of tables).

I need to extract all of the new entries from last week (for one table) and all of the entires that were "closed" last week (for another table).

How would I do this? I have looked at the Spreadsheet plugin but I am having difficulty serialising and unserialising dates within the query.

An example of the type of code I am using, which doesn't include any code to extract only last weeks data:

%FORMQUERY{name=SupIssuesForm moan="off" search="form='SupportIssueForm'"}% %FORMQUERY{name=AllSupIssues query=SupIssuesForm moan="off" search="topic!='SupportIssueTemplate'"}% %FORMQUERY{name=ClosedSupIssues query=AllSupIssues moan="off" search="Status='Closed'" extract=ClosedIssues}% %FORMQUERY{name=RecentlyClosedIssues query=ClosedSupIssues moan="off" search="Date Closed='Closed'"}%

%TABLEFORMAT{ name=ClosedSupTable format="|$topic|$Summary|$AssignedTo|$DateClosed|$Customer|" header="|*ID*|*Summary*|*AssignedTo*|*DateClosed*|*Customer*|" sort="logNumber"}% %SHOWQUERY{ query=ClosedSupIssues format=ClosedSupTable }%

Any ideas would be much appreciated, or even a pointer to a plugin or code that could do what I need would be helpful.

Environment

-- GarrethMorgan - 05 May 2005

Answer

Found the answer under "FormattedSearch - Examples - Search with Conditional Ouput".

-- GarrethMorgan - 09 May 2005