search

openlab / OGDI-DataLab

Open Government Data Initiative
http://ogdi.codeplex.com
Microsoft Public License
57 stars 17 forks source link

Query CASE Sensitivity #18

Closed nikg closed 12 years ago

nikg commented 12 years ago

DataService: Fix case sensitivity in field name

ERROR: http://datadotgcds2.cloudapp.net/v1/nipoc1/OGSCemeteryIndexNIPOC1/?$filter=TOWNSHIP%20eq%20'Grimsby' http://datadotgcds2.cloudapp.net/v1/nipoc1/OGSCemeteryIndexNIPOC1/?$filter=township%20eq%20'grimsby'

WORKING: (both "township" and "Grimsby" must be case sensitive: http://datadotgcds2.cloudapp.net/v1/nipoc1/OGSCemeteryIndexNIPOC1/?$filter=township%20eq%20'Grimsby'

DataBrowser: Ensure Text Query builder returns results regardless of case sensitivity:

http://datadotgcds2.cloudapp.net/v1/nipoc1/OGSCemeteryIndexNIPOC1/?$filter=TOWNSHIP%20eq%20'Grimsby'

should work, just as:

http://datadotgc2.cloudapp.net/DataBrowser/nipoc1/OGSCemeteryIndexNIPOC1#param=township%2520eq%2520%2527Grimsby%2527--DataView--Results

SyntaxC4 commented 12 years ago

As per the Windows Azure Table Storage documentation on Querying Tables and Entities all Filter text in a Query is case sensitive.