How can i search in firebase by different fields?

MIT App Inventor Help
21

Check this:

image

Regarding to the other problem "it always downloads in the labels the last one, the rest NOT.".

When you get the data from the Initialize block, you are receiving all the data in GotText, and setting the three labels with the info....for each element you are overwriting the labels...so only the last one remains... is this what you are referring to?

22

@Ramon

where is that from ?

23

He is checking the rules in "Rules playground" in firebase, and it didn't work for me there...but it works if I add that

24

if I do that, it allows me to pass the rules, but it does not hold and the app still does not search for anything.
thanks

image

25

Assuming "recambios" is a top line node:

https://yourProjectName.firebaseio.com > recambios

image

your rules should be (and you should be able to publish):

{
  "rules": {
      "recambios": {
         ".read": true,
         ".write": true,
         ".indexOn": [".value","Compatible","Descripcion","PN"]
       }
   }
}

(if you have any other rules set up, then show these as well)

26

error rules :

image
image1302×589 32.7 KB

database

image
image756×572 34.9 KB

27

move read & write rules out of "recambios" if not, then you have to put /recambios when you are testing your rules in the "Zona de pruebas".

@TIMAI2 Did you test your example? It doesn't work for me, it seems like the index are at "recambios" level and "Compatible" tag is nested one level more....

28

Yes, I tested it.

Firebase handles the nesting.

PN
image

Compatible
image

image

image
image706×642 67.2 KB

rules as above

29

yeeess It finally works for me

image
image1467×353 28.3 KB

:rofl: :rofl: :rofl: Sorry David, but I was also frustrated

30

David, Do you have still the same error?

I see double quoted in your values...maybe you will need \" in the beginning and end of your query value (in equalTo statement)

31

image
image1446×203 20.2 KB

perfect ramon modifying equalTo works fine.

do you know why it is saved with that double " feature?

thanks in advanced both

32

how are you saving the data?

33

Are you both going to write a rule for every single key?

34

What do you mean?

35

blocks (1)
blocks (1)1412×1272 175 KB

36

OK, two things going on.

  1. The positioning of the rules
  • You should not need to write a rule for every key in the node recambois. Just as I have shown.
  1. The double quotes around the values
  • If you use the experiemental firebase component to add records to your database, this will add a set of double quotes. Use the web component to add records.
  • or if using the experiemental firebase component, add double quotes as another set to the textbox.text ?
37

Thanks for the explanation,

if I use firebase component in App inventor, knowing that it uses double quotes, there is no problem .

For my part, I close the query by thanking you again for your help.

38

after getting it to search by " compatible " thanks to your indications, now I find a new problem, when there are two or more words it is not able to search, not even if you put both words... is there a solution or is it not possible to do that in firebase?

image
image836×202 32.3 KB

thanks in advanced

39

It is not really possible to carry out wildcard / partial string searches in firebase. There are some hacks, but I do not believe any of the ones I have seen will handle your requirement. To do it, you will need to restructure your data, I have a couple of ideas, but will have to carry out some testing....

40

many thanks Timai2