Searching a field with valuelists

Archived from the Xataface Users forum.

wisni1rr — Thu Feb 23, 2012 10:31 am

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

shannah — Thu Feb 23, 2012 10:52 am

You should be able to choose multiple by holding down CTRL (on windows) or command ( on mac).

-Steve

wisni1rr — Thu Feb 23, 2012 12:07 pm

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

shannah — Thu Feb 23, 2012 12:14 pm

What version of Xataface are you using?
Can you provide a simple minimal example?

-Steve

wisni1rr — Thu Feb 23, 2012 12:41 pm

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!!!

shannah — Thu Feb 23, 2012 12:45 pm

Thanks for this. Can you also post the query string portion of the URL that results in the No results found.

-Steve

wisni1rr — Thu Feb 23, 2012 12:55 pm

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

shannah — Thu Feb 23, 2012 2:12 pm

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

wisni1rr — Thu Feb 23, 2012 2:26 pm

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!!!

shannah — Thu Feb 23, 2012 2:53 pm

Can you post the fields.ini field definition for that field so I can see how the field is set up?

wisni1rr — Thu Feb 23, 2012 3:08 pm

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

wisni1rr — Fri Feb 24, 2012 2:30 pm

I updated to the 1.3.1 release and still am having this problem…

Any Ideas?

shannah — Fri Feb 24, 2012 2:36 pm

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.

wisni1rr — Fri Feb 24, 2012 2:42 pm

Thank you.

wisni1rr — Thu Feb 23, 2012 3:08 pm

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

wisni1rr — Fri Feb 24, 2012 2:30 pm

I updated to the 1.3.1 release and still am having this problem…

Any Ideas?

shannah — Fri Feb 24, 2012 2:36 pm

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.

wisni1rr — Fri Feb 24, 2012 2:42 pm

Thank you.