Page 1 of 1

Searching a field with valuelists

PostPosted: Thu Feb 23, 2012 10:31 am
by wisni1rr
I notice that I cannot choose two or more items when using the find tab to search fields that have a valuelist associated with them.

Is this a bug or is there a way to modify the searching function to accommodate searching for NONE, ONE, and MORE THAN ONE?

Thanks

Re: Searching a field with valuelists

PostPosted: Thu Feb 23, 2012 10:52 am
by shannah
You should be able to choose multiple by holding down CTRL (on windows) or command ( on mac).

-Steve

Re: Searching a field with valuelists

PostPosted: Thu Feb 23, 2012 12:07 pm
by wisni1rr
Thanks Steve,

I don't have a problem selecting the values. The problem is with the query itself. If I select more than one choice my query always returns "No records match your request".

Thanks,

Rich

Re: Searching a field with valuelists

PostPosted: Thu Feb 23, 2012 12:14 pm
by shannah
What version of Xataface are you using?
Can you provide a simple minimal example?

-Steve

Re: Searching a field with valuelists

PostPosted: Thu Feb 23, 2012 12:41 pm
by wisni1rr
I'm not entirely sure on my Xataface version. I know it is in the 1.3 branch.

Here is my search criterion:

Image

Which displays:

Image

Here is the proof that a matching record exists:

Image

Hope that helps.

Thank you for Xataface, it is a godsend!!!

Re: Searching a field with valuelists

PostPosted: Thu Feb 23, 2012 12:45 pm
by shannah
Thanks for this. Can you also post the query string portion of the URL that results in the No results found.

-Steve

Re: Searching a field with valuelists

PostPosted: Thu Feb 23, 2012 12:55 pm
by wisni1rr
After my domain and path the URL is this:

Code: Select all
-action=list&-table=GENERAL&-cursor=0&-skip=0&-limit=30&-mode=find&-recordid=GENERAL%3FBWA_ID%3D9&-edit=1&Foundation%2FFoundationType=%3DBASEMENT

Re: Searching a field with valuelists

PostPosted: Thu Feb 23, 2012 2:12 pm
by shannah
That looks like the URL resulting from a search only for BASEMENT. Are you sure that this is what is produced when you select both BASEMENT and CRAWL?

-STeve

Re: Searching a field with valuelists

PostPosted: Thu Feb 23, 2012 2:26 pm
by wisni1rr
Thank Steve,

Yes, I'm sure I selected both.

If you would like you may visit my site:
Code: Select all
[url]bwaxatatest.elementfx.com/index.php[/url]


A guest account is available:
Username: Guest
Pass: Guest

Thank you soooo much for you help!!!

Re: Searching a field with valuelists

PostPosted: Thu Feb 23, 2012 2:53 pm
by shannah
Can you post the fields.ini field definition for that field so I can see how the field is set up?

Re: Searching a field with valuelists

PostPosted: Thu Feb 23, 2012 3:08 pm
by wisni1rr
Here is my fields.ini file for the table in question:

Code: Select all
[BWA_ID]
widget:type = hidden

[Exterior]
widget:type = checkbox
vocabulary = Exterior


Here is my valuelists.ini:

Code: Select all
[Exterior]
ALUMINUM = ALUMINUM
ASBESTOS = ASBESTOS
BLOCK = BLOCK
BRICK = BRICK
VINYL = VINYL
WOOD = WOOD
STONE = STONE
UNKNOWN = UNKNOWN

Re: Searching a field with valuelists

PostPosted: Fri Feb 24, 2012 2:30 pm
by wisni1rr
I updated to the 1.3.1 release and still am having this problem...

Any Ideas?

Re: Searching a field with valuelists

PostPosted: Fri Feb 24, 2012 2:36 pm
by shannah
There appears to be a problem with AND queries within multi-select fields. I'll need to look into this at a later time. I'm not sure if this error is still in the SVN trunk or not.

Re: Searching a field with valuelists

PostPosted: Fri Feb 24, 2012 2:42 pm
by wisni1rr
Thank you.