Question

I have a number of topics like this one:

%EDITTABLE{include="TimeSheetTable"}%
| *Project*   | *Day*   | *Task*   | *Hours*   | *Comment* |%EDITCELL{label}%|%EDITCELL{label}%|
| Sales.LeadershipDNAQuestionnaires | Monday | Design | 1.5 |  |%DAY%%EDITCELL{label}%|%TASK%%EDITCELL{label}%|
| Sales.LeadershipDNAQuestionnaires | Tuesday | Manufacture | 2 |  |%DAY%%EDITCELL{label}%|%TASK%%EDITCELL{label}%|
| Sales.LeadershipDNAQuestionnaires | Wednesday | Acceptance | 1.5 |  |%DAY%%EDITCELL{label}%|%TASK%%EDITCELL{label}%|
| Sales.LeadershipDNAQuestionnaires | Wednesday | Release | 1.25 |  |%DAY%%EDITCELL{label}%|%TASK%%EDITCELL{label}%|
| Sales.LeadershipDNAQuestionnaires | Thursday | Release | 1 |  |%DAY%%EDITCELL{label}%|%TASK%%EDITCELL{label}%|
| Sales.InfrastructureTasks | Monday | Design | 1 |  |%DAY%%EDITCELL{label}%|%TASK%%EDITCELL{label}%|
| Sales.LeadershipDNAQuestionnaires | Tuesday | Manufacture | 1 |  |%DAY%%EDITCELL{label}%|%TASK%%EDITCELL{label}%|
| Sales.LeadershipDNAQuestionnaires | Wednesday | Acceptance | 1 |  |%DAY%%EDITCELL{label}%|%TASK%%EDITCELL{label}%|
| Sales.InfrastructureTasks | Thursday | Release | 1 |  |%DAY%%EDITCELL{label}%|%TASK%%EDITCELL{label}%|
| Sales.InfrastructureTasks | Friday | Manufacture | 1 |  |%DAY%%EDITCELL{label}%|%TASK%%EDITCELL{label}%|
| Sales.InfrastructureTasks | Friday | Manufacture | 1 |  |%DAY%%EDITCELL{label}%|%TASK%%EDITCELL{label}%|
| Sales.InfrastructureTasks | Friday | Manufacture | 1 | another comment |%DAY%%EDITCELL{label}%|%TASK%%EDITCELL{label}%|


Sorry, closing this after more than 30 days of inactivity. Please feel free to re-open if needed.

-- Main.PeterThoeny - 01 Nov 2007
%COMMENT{ type="timesheet"}%

The table edit is defined by

%EDITTABLE{changerows="off" , format="| select, 1, %PROJS%| select, 1, %DYS%| select, 1, %TSKS%|  text, 10, 1 | text, 30 | label ,0 , $percntDAY$percnt  | label ,0 , $percntTASK$percnt |", header="| *Project*   | *Day*   | *Task*   | *Hours*   | *Comment* |%EDITCELL{label}%|%EDITCELL{label}%|"}%
| *Project*   | *Day*   | *Task*   | *Hours*   | *Comment* |%EDITCELL{label}%|%EDITCELL{label}%|

I view the information in a page which uses my DAYS and TASK variables to build a grid of projects agains days for timesheets.

This all works fine, but I'm currently viewing one week at a time. I want to extend this to a period, say a month, to be able to invoice for a project. I thought I'd use FormQueryPlugin, which I have working for other queries. I have a page with:

%TABLEFORMAT{name="sheet" header="| *Project*   | *Day*   | *Task*   | *Hours*   | *Comment* | |" format="| $topic | $TimeSheetTable.Hours|"}%


%FORMQUERY{name=sheeta search="form='TimeSheetForm'" }%
%FORMQUERY{name=sheetb query="sheeta"   search=" Weekending > 200707 AND Weekending < 20070801 AND Staff='Main\.ChrisHogan'"}%
%SHOWQUERY{query=sheetb format=sheet}%

I note that it really is $topic in the format & the search not $name as implied by the Plugin documentation.

I tried to add extract"TimeSheetTable" to my query "sheetb" , but this returns "No values returned "

I have followed some of the examples too, but it's obvious that I can't extract table data.

I have Set FORMQUERYPLUGIN_TABLES = TimeSheetTable in my WebPreferences (I had "all", but it makes no difference.

Can someone explain how to extract table data using FormQueryPlugin, or it's back to good old SEARCH for me.

Environment

-- ChrisHogan - 16 Sep 2007

Answer

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.