Question

Here is my scenario:

I have a topic, which lists database fields and additional information in a Twiki table. Additionally I have a kind of "table definition" - topic, which descibes, which fields are used for this "table definition".

Now I'm searching for an opportunity to include defined table rows from the "fields" - topic in the "table definition" - topic. A perfect solution would be, if the table format could be kept, so I only have to define the filter criteria for displaying the Twiki in the "table definition" - topic.

Are there any build-in opportunities, PlugIns or Add-Ons to get such a Twiki page ?

Thanks for any help.

---

Thx for the fast feedback. Here an example of the two topics:

The "fields" - topic

The content of this topic is a big table, which decribes the definition of "fields" of a kind of database. This table can be exported of special application and easily being transfered into Twiki - code.The table of this topics look like the following table:

Assigned Team	group	none
Assigned User	user	none
Impacted Version	shorttext	none
implements	relationship	(field[Task Type] = "Bug Report")
implemented in	relationship	none
Due Date	date	none
WBS Code	shorttext	(field[Task Type] = "Work Package")

The "Type" - topic

The content of this topic is a description of a workflow document used in that mentioned application. This desciption can also be exported and easily being transfered into Twiki code. A part of this description is a list of visible fields used in this workflow document. This used fields are the same fields listed in the "fields" - topic. The pof this topics look like the following table:

---------------------------- BUG Report

Type: Bug Report

Description:

• none

Image: none

Display Workflow in Issue: yes

Visible Fields:

• Assigned Team (everyone)
• Assigned User (everyone)
• Impacted Version (everyone)
• Due Date (everyone)
• WBS Code(everyone)

State Transitions:

• New -> New
• New -> Cancelled

The expected result :

The expected result is that all visible fields used in the "type" - topic are displayed in a detailed view like is the displayed in the "fields" - topic. So I would like to have an "INCLUDE" for the "fields" - topic. But the problem is, that I only want to see the rows of the "fields" - table, which are used in the "type" - topic. So it shall be possible to filter the INCLUDE command.

Here is an example of a possible solution:

---------------------------- BUG Report

Type: Bug Report

Description:

• none

Image: none

Display Workflow in Issue: yes

Visible Fields:

Assigned Team	group	none
Assigned User	user	none
Impacted Version	shorttext	none
Due Date	date	none
WBS Code	shorttext	(field[Task Type] = "Work Package")

State Transitions:

• New -> New
• New -> Cancelled

I hope this description will help to get a better understanding of my situation.

Environment

-- ThomasPieber - 04 Jun 2007

Answer

It is hard to help with the little information provided. Examples would help.

The VarSEARCH and FormattedSearch has a lot of flexibility to do custom reports.

-- PeterThoeny - 04 Jun 2007

If you don't mind losing the "(everyone)" somehthing like this might work (possibly abstracted with INCLUDE):

%SEARCH{"Assigned Team|Assigned User|Impacted Version|Due Date|WBS Code" regex="on" casesensitive="on" multiple="on" topic="TheFieldsTopic" nonoise="on" format="$text"}%

-- JustinLove - 05 Jun 2007

Change status to: AskedQuestions AssignedQuestions AnsweredQuestions ClosedUnanswered