Question

Hi, I'm trying to create a table of which the contents are coming from 3 other tables in other Wiki's.

3 other tables, each on different Wikis look like this
Wiki1

Wiki2

Wiki3

_OR_ (alternative search result output)

 | *Name* | 
%SEARCH{ "\| john \|" topic="CreateTableBasedOnOtherTableSearch" regex="on" multiple="on" nonoise="on" format="$pattern(^\|[^\|]*(\|[^\|]*\|).*)" }% 

Problem: Only the name field is shown, would like to automatically see the other fields aswell

Other question

• What if the table format in the other Wikis are different? (but the first field is the same everywhere, "name")

To see when 'john' has visited I would like to create a table that searches 3 tables (on 3 wiki's) and returns the full rows

Any ideas? Thankyou! DJ

Environment

-- DirkVandenBerg - 24 Oct 2007

Answer

If you answer a question - or have a question you asked answered by someone - please remember to edit the page and set the status to answered. The status is in a drop-down list below the edit box.

-- FranzJosefGigler - 24 Oct 2007

Franz, Thankyou very much. Last question based on this info: Is it possible to do a search where you get content our of a specific TABLE on a wiki? What if "John" is on 5 tables and I just want to search for "John" in one of those tables.

How can I narrow down that search? (I noticed that the TablePlugin has an "id" field. Couldn't find what that is used for)

Cheers!

-- DirkVandenBerg - 20 Nov 2007

If the tables are all on separate topics this is easy, if several topics are on one topic this is difficult till the TopicObjectModel has been implemented.

-- FranzJosefGigler - 20 Nov 2007

And of course there's always the infamous FormQueryPlugin.

-- FranzJosefGigler - 20 Nov 2007

Thankyou!

-- DirkVandenBerg - 10 Dec 2007