Question

Hi all, i have just installed Twiki for our project purpose. Our main usage is with tables of data. I have installed EditTablePlugin plugin which allows me to do sorting. But i want to do FILTERing as well with sorting, the same way we can do in Excel or Access database. I tried with some plugins but it didn't work out the way i want.

Environment

-- DarshitaShah - 15 Dec 2006

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.

You need to create custom SEARCHes for this. Have a look at BlogAddOn, topic BlogPost, to see how it is done there.

-- ArthurClemens - 15 Dec 2006

You'll also find an example here on TWiki.org with TWikiInstallation.

-- LynnwoodBrown - 15 Dec 2006

Ya, i want the same kind of format mentioned in TWikiinstallation. But i have another question here is, do i need to install any plugin for this filter to work. I tried doing the mentioned way, but after clicking "Filter" table comes in the situation when it should come after clicking "Edit". I hope i m clear enough to explain the situation.

-- DarshitaShah - 21 Dec 2006

Darshita - I'm sorry, i don't understand what you're asking. Are you saying you want to apply the filter while your editing the table? That won't work. Otherwise, I don't thing TWikiInstallation requires any special plugins.

-- LynnwoodBrown - 21 Dec 2006

Hi Lynnwood - ya, i was not clear. Let me try with an example.

I have made a table using EditTablePlugin. %EDITTABLE{ header="|*Sr.No*|*Emp No*|*Name*|*Certification*|*Date of Certification*|*Percentage*|" format="| row, -1 | text, 07,  | text, 30, null | select, 1,  , CCNA, CCNP, SCJP, Basic PE, MCSE, MCP | date, 14, (01 Jan 2006),  | text, 05, 00 |" changerows="on" }%

Here i want to put filter so that i can extract data on the basis of employee name or certification. So i did the changes like

on the TWikiInstallation, Entry Form is linked with Table to do Filtering. I dont know how to link EditTablePlugin with Filter of my example.

In the example, clicking on "FILTER" after selecting any value from drop down list, i m finding the form of EditTablePlugin.

I hope this time i m quite clear.

-- DarshitaShah - 22 Dec 2006

You can't apply a filter to an edit table. It is however posssible to show a report with filter on the same topic or another topic that shows the edit table data. Do that with a FormattedSearch (aka a VarSEARCH using multiple="on" and URLPARAMs in the search string)

The table you see in the TWikiInstallation is generated dynamically with a FormattedSearch; data is pulled from topics with TWikiForms. You can apply a filter to this setup.

-- PeterThoeny - 24 Dec 2006