Question

Hello,

I am working on my dissertation and I came across some problems, which I am afraid am not able to solve it.

Is it possible to have a search form (similar as default search form is) which would search just the particular topic and would extract hits from a table to another topic e.g. ResultsOfSearch topic.

My table looks like:

Nr	Name and Surname	Name and surname of big shot	Relationship to big shot	Importance of relationship	Date of editing	Notes
3	MickeyRourke	PaulMcCartney	Broader Family Member	3	15 Jul 2006 20:56 GeorgeMatthew	Nothin' to tell about them.
1	PaulMcCartney	GeorgeHarrison	Close friends	4	11 Jul 2006 19:08	First notes.
2	MilletBullison	GeorgeHarrison	Best friends and other good friends	4	12 Jul 2006 12:05	Second notes'

e.g. If I would search for GeorgeHarrison I should get the extracted first and second row, or if I would search for Importance of relationship greater than 3 - or if this is to hard to find at least option where e.g. the Importance is equal to 4, I should get again 1st and 2nd row.

I've read about Form plugin but couldn't find anything similiar.

And one thing more. Extracted table should contained just 2nd, 3rd, 4th and 5th coloumn (from Name ... to Importance of relationship) and not the whole row.

Any kind of help would be more than welcome! Cheers,

George

Environment

-- TWikiGuest - 19 Jul 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.

Hm, one could use FormQueryPlugin for these kind of searches I guess. Did you have a look at it yet?
Or you make each row a TWikiForms and build the table via a filterable search.
I'm sure there are still other solutions to your filter problem without the need to switch to a database. It depends (as my russian professor for database systems used to say) on the amount and structure of the data in your TWikiApplication.

-- FranzJosefSilli - 19 Jul 2006

Yes I look at it, so I have another question Do I need to have a form to use a FormQueryPlugin (so < form > < /form >) or can you use this plugin on my example (look at the upper table example). If so, I tried before to create a form, but couldn't find solution how the form entries from different users can be saved in a table as a new row. In my case users got the same form with the entries filled in from previous user. "Or you make each row a TWikiForms and build the table via a filterable search" - How it is possible to create a row form - all examples from TWiki's sites are not presented in a row. I've tried to use SearchToTable plugin but is obviously not ported to Dakar release. I think the project is medium sized few hundreds of entries maybe 1000 - 2000, but search result should contain less than 100 hits. Anyway does FormQueryPlugin provide a form like e.g. Search plugins web fobler users to search the entries or you need to type special syntax for this. In my case final users won't be probably able to edit the page. Now the Web page is created that users just click the Edit button (EditTable plugin). This page should also provide option to search and extract the results and this should be extracted to another page (e.g. SearchinResults). Searching results won't be stored so next time another user will search should delete the previous results on this page (SearchingResults). Is this possible or not?

George

-- TWikiGuest - 19 Jul 2006

No, you don't need a form to take advantage of FormQueryPlugin. It easily operates on EditTablePlugin tables (and even attachment attributes if needed).

But be aware that at the beginning it is tricky to understand what it's doing (give it some time for adapting to your mind ) and how YOU can make it do what you want it to do.

Good luck (as my mathematics professor used to say on his test sheets).

-- FranzJosefSilli - 19 Jul 2006

So this plugin provides an option to extract results to another topic? And another Q can the searching syntax be included in a search form like the form at the (right) top of this page and how? ?:| When the data are extracted to another topic are previous data in this topic deleted or is the new search just added. In my case should be previous result deleted! Why? Because this page is a starting page for a DirectedGraph plugin.

Thank you! G.

-- TWikiGuest - 19 Jul 2006

You can also use a FormattedSearch with multiple="on". That way you can search multiple times within a topic. I tried to do that at the top of this topic, but it needs some more tweaks. I have no time to debug the query, but you should get the idea.

-- PeterThoeny - 19 Jul 2006

Thank you Peter and Franz I will try harder :|. But still one thing concern me the most how to extract this results to another topic not the same page? As I mentioned before I will use DurectedGraphPlugin to show the relationships between persons. I almost find solution for replacing the existing text to appropriate format for DirectedGraph syntax, but for this the results should be in another topic. Because the DirectedGraph topic will include search and replace plugin which will be pointed to the topic where data from table will be extracted this topic should contain just one search results and not also previous ones. Is this possible to do in TWiki?

Once more thank you guys for your help

-- TWikiGuest - 19 Jul 2006

OK, I got the query to work. Also with correct search for 3-4 for importance 4.

You can search across topics. Simply point the topic="" to the right topic.

-- PeterThoeny - 20 Jul 2006