Firebase Search Query startAt endAt

Question

I am having a problem when querying for search process with Firebase Rest api. I use the startAt and endAt parameters for the first and last search, but it still doesn't list it.

https://myprojectdemo.firebaseio.com/posts.json?orderBy="title"&startAt="Car"&endAt="Caruf8ff"&print=pretty

I make a GET request this way.

"-WE2QEYJx8gaOUkOsvWkV": {
  "title" : "Red Car",
  "category" : "Other" 
},
"-WE2KSBJx8gaOUkOsvWkV": {
  "title" : "White Car",
  "category" : "Other" 
}

I have an output like above. There are two shipments titled White Car and Red Car. When I search for car, I want both of them to come out. Where am I making a mistake?

Answer 1

It looks like what you're trying to do is find strings the end with some substring. You can only search for strings that begin with some substring. Realtime Database does not support substring queries in any other way except for string prefixes.

If you want to be able to search for items that are cars, consider adding another piece of data to each child indicating that it is a car type object, and use that to filter your result set. Using the title as you have it now will not work.