Confiform Database within a Form

[Maximilian Neufeld]

Hello there,

so as usual I will try to describe as precise as possible what my problem is:

I created a custom layout form via Confiform. In the end of this form I want to insert a "Capacity Matrix".

Example of this matrix:

...

*Upper part of the form where general data about the person is asked*

.....

Matrix:

Category               Type                             Amount                       Size

---

Dogfood         *ConfiFormField*          *ConfiFormField*       *ConfiFormField*

                        *ConfiFormField*          *ConfiFormField*      *ConfiFormField*

Catfood           *ConfiFormField*          *ConfiFormField*      *ConfiFormField*

                        *ConfiFormField*          *ConfiFormField*      *ConfiFormField*

........

And so on.....

The problem with that is: I cant really analyse the total amount of dogfood (Type XYZ) through all entries. Any ideas what the best approach would be to get this down?
Would the integration of a database solve this problem. But how can I do this without getting too much out of Confluence and still be able to analyse the entries.
Overall the result should be that anyone can fill in how much he needs of what and i want to analyse and interprete the results through all entries.

Best wishes 
Max

[Andrew Frayling · Accepted solution]

Ah, ok, I tried all sorts of combinations and this is the closest I got with a search with 2 pages:

SomeTitleOne

SomeTitleTwo

{search:title:sometitle?*}

returns both pages.

So it looks like you can do a regex of sorts, just not have * as the first wildcard.

Not sure if that would work for you?

[Jobin Kuruvilla [Adaptavist]]

Awesome! Interesting observation:

{search:title:SomeTitle?*}

didn't work but the following did! I don't mind though ;)

{search:title:sometitle?*}

[Tom Towkach]

Unless your site contains Japanese characters, then a search on title without "" around it finds both regarless. Not sure about any other language, but I just verified that in japanese. I guess the developers didnt' talk to each other?

[Andrew Frayling]

Try:

{search:title:sometitle\*|maxLimit=10|spacekey=TEST}

i.e. escape the * with a \

As Confluence uses Lucene it treats the * as a literal when searching on fields unless you escape it.

I tried this on the Demonstration Space on my install and :

{search:title:tutorial*}

returned zero results, but:

{search:title:tutorial\*}

returned 2 results as expected.

Hope that helps,

Andrew.

[Andrew Frayling]

When I searched for:

{search:title:tutorial\*}

I got:

"Tutorial"

"Tutorial (all on one page)"

[Jobin Kuruvilla [Adaptavist]]

Doesn't work for me. What are the titles of the results you got?

[Jobin Kuruvilla [Adaptavist]]

I see. Here 'Tutorial' is a single word. If you have a page with TutorialInASingleWord as title, it won't be in the search results. That is exactly the problem for me!

For me, I am getting titles with sometitle in it but not titles with sometitleone.

[Jobin Kuruvilla [Adaptavist]]

Awesome! Interesting observation:

{search:title:SomeTitle?*}

didn't work but the following did! I don't mind though ;)

{search:title:sometitle?*}

[Lionel Hutz]

I know regular expressions don't work when doing a regular confluence search on metadata (use the default search box and search for "title:SomeTitle*"). It could be that this carries over to the search macro.

[Jobin Kuruvilla [Adaptavist]]

That's what I thought too. Just wanted to confirm. Also wanted to see if there are any plugins that supports this!