Access Keys:
Skip to content (Access Key - 0)

Community Forum Closure Notification

Adaptavist would like tosay thank you to all of the forum visitors who have used the Adaptavist Community forums to post questions about our plugins.

Adaptavist have changed the way that we deal with support queries. These forums were closed on Monday the 25th February 2013, and will remain in read-only format. We will continue to deal with support queries via a contact form which will send all queries directly to our support engineers. If you have any questions or comments regarding this change you can contact us at plugin-support@adaptavist.com

All the latest updates and news on our plugins can now be found at www.adaptavist.com.

<< Back to Topics


Advanced Search cannot search a metadata field if its name contains a space

Advanced Search - Bug Report, made by François Nonnenmacher on Nov 01, 2011 01:08

Current Status: Awaiting Review

 

Plugin Version: 3.0.11

Confluence Version: 3.4.8

How to reproduce:

1. create a page with the following wiki markup:

|| MyMetadata | {list-data:MyMetadata|type=check|multiple=true}{list-option}Option A{list-option}{list-option}Option B{list-option}{list-data} ||

|| My Metadata | {list-data:My Metadata|type=check|multiple=true}{list-option}Option A{list-option}{list-option}Option B{list-option}{list-data} ||

2. Save and fill-in the form by selecting "Option A" for both metadata fields.

3. Create another page with the following wiki markup:

{search-form}{search-input:type=text|match=query}

{search-select:match=metadata|metadataKey=MyMetadata|nullLabel=All options}
{search-option}Option A{search-option}{search-option}Option B{search-option}
{search-select}

{search-select:match=metadata|metadataKey=My Metadata|nullLabel=All options}
{search-option}Option A{search-option}{search-option}Option B{search-option}
{search-select}

{search-submit:Search}
{search-form}

4. Save and search for "Option A" in the first "MyMetadata" drop-down menu. It will return your first page. Now search for "Option A" in the second "My Metadata" drop-down menu. It will return no result.

The plugin should be able to handle metadata fields that have spaces in their name.

(P.S. I wish I had known this bug before filling thousands of forms, now I'm looking for a way to rename the metadata fields in the database without having to edit all those forms . Guidance on how to do that much appreciated .)


  1. Nov 01, 2011

    François Nonnenmacher says:

    It looks like the following SQL statement will do for renaming the metadata key ...

    It looks like the following SQL statement will do for renaming the metadata key directly in the database:

    UPDATE os_propertyentry set text_val=replace(text_val,'<string>My Key</string>','<string>My_Key</string>') WHERE text_val like '%<string>My Key</string>%';

or log in to vote and add or reply to topics.


Adaptavist Theme Builder Powered by Atlassian Confluence