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

Community .adaptavist.com

Community Forum Closure Notification

Adaptavist would like to extend our thanks to all of the forum visitors who have used the Adaptavist Community forums to post questions about our plugins.
In order to improve our plugin support, Adaptavist are upgrading the way that we deal with support queries. Since Monday the 25th February 2013, these forums were closed 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, please reach out to us on plugin-support@adaptavist.com
Please keep a look out for our upcoming blogging area for updates and news on our plugins.

<< 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 .)

Comments (1)

 

  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>%';

Sign up or log in to vote and add or reply to topics.
Adaptavist Theme Builder Powered by Atlassian Confluence