Searching a field with valuelists

[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

[shannah]

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

-Steve

[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

[shannah]

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

-Steve

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

[shannah]

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

-Steve

[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

[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

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

[shannah]

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

[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


[wisni1rr]

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

Any Ideas?

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

[wisni1rr]

Thank you.