Page 1 of 1
Searching a field with valuelists
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
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:
Which displays:
Here is the proof that a matching record exists:
Hope that helps.
Thank you for Xataface, it is a godsend!!!
Re: Searching a field with valuelists
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
Fri Feb 24, 2012 2:42 pm
by wisni1rr
Thank you.