Community Support for OpenDocMan (Deprecated)
Unable to filter bu User Defined Field - Printable Version

+- Community Support for OpenDocMan (Deprecated) (https://forum.opendocman.com)
+-- Forum: OpenDocMan Community Discussion (https://forum.opendocman.com/forum-5.html)
+--- Forum: General Discussion (https://forum.opendocman.com/forum-9.html)
+--- Thread: Unable to filter bu User Defined Field (/thread-639.html)



Unable to filter bu User Defined Field - theboyroberts - 08-12-2013

Hi,

I'm in the middle of prototyping a openDocMan instance and I've a wall that i was hoping to get a little help with.

So, I've created a user Defined Field Called Release. It's ODM table is called: odm_udftbl_rel.

Within this UDF I have 4 values: Release1, Release2, Release3 and Release4. I have added documents to the repository and assigned them to Release1.

When I attempt to filter for documents from Release I get the following error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\opendocman\search.php on line 184

Any ideas what the problem could be?

Thanks a million

Shaun

PS

Running OpenDocMan v1.2.6.7


Re: Unable to filter bu User Defined Field - Stephen - 08-14-2013

Try reproducing this issue on our beta site:

<!-- m --><a class="postlink" href="http://www.opendocman.com/beta/">http://www.opendocman.com/beta/</a><!-- m -->

admin/admin


Re: Unable to filter bu User Defined Field - theboyroberts - 08-22-2013

Hi Stephen,

Thanks for getting back to me, greatly appreciated.

I've tried to replicate the issue on the demo site, and although I have not been able to replicate the exact error i receive on my system, I have not been able to return any successful results from the demo site.

Here's a run down of what I've done:

1: Created a UDF Select list called Release
2: Added data to this list - Release1, Release2 & Release3
3: Checked in various documents into the system, added a selection to both Release1 and Release2.
4: Approved the documents
5: From the main page, Selected: Filter By -> Release1/2 -> Acceding/Decending
6: OpenDocMan reports that no files can be found.

Any ideas?

Many thanks

Shaun


Re: Unable to filter bu User Defined Field - Stephen - 08-22-2013

Right, ok. Sorry I mis-read your issue and was using the Search function to find the UDF.

https://github.com/opendocman/opendocman/issues/123