Get values from custom Firebase

In a dropdown
I need to get all 2 items
Which belong to PARTE 1

From the month of ABRIL
should get

28/04/2024 18:00:00 a 28/04/2024 23:00:00
30/04/2024 22:00:00 a 01/05/2024 00:00:00

As you can see I am omitting the dates

Likewise when you choose the month of MAY

greetings

any suggestions?

Ramón
TIMAI2

I need to acquire what is marked with light blue

got to date with index 1

but when I put the incice 2
It combines values ​​1 and 2 making only 2 items appear
being 3

here is a detail

You must have asked this similar question 10 times over the last year, yet have learnt nothing!

  1. Start using Firebase properly, and set a tag for each item in your list, without repetition, this then makes it easy to return the data you want.

  2. If you do not want to do that, then return all the data for the tag ABRIL, and then parse the json returned into dictionaries/lists, then extract the data you need.

I understand

I have always acquired data by assigning the address through its equiteta

This time I jump from the month to the items, omitting the dates

thanks for the review I'll try it

Herewith an example of how you might store your data on Firebase:

BEFORE:

AFTER:

With this you should then be able to retrieve any value from any tag with a single call

(Unfortunately, Firebase sorts everything alphabetically in the console...)

with this example I can acquire only

PART 1
PART 2

should get
PART 1
PART 1
PART 2

That's why I can only get 2 items and that also affects the values.

I need to get this
image

thanks for the advice TIMAI2

This time I try to obtain for a table
obtaining it becomes more practical

I have this case where I would like to get the second items of "cero"
I mean:
{"B2"}, {"A2"}

The difference from the previous questions is that the "DATA/cero" labels are repeated in:
100-01 and 100-02

according to the image
image

image

will it be possible?

Something like this:

image

but you could do better, and probably only make one call, if you use indexing on your firebase data, and query the data using the web component.

It seems that the question was not understood

what I'm trying to get is:
{"B2"}, {"A2"}

the 2 at the same time in a list

image

you can count on a block from dictionary: list by walking key path

image

image

1 Like

This method is different from the dictionary block

and in the same example if I wanted to obtain
the "zero" items?

{"A1","A2","A3"}, {"B1","B2","B3"}

image

Make your mind up.

If you already solved the first query

this is another one for another case

Change to GotValue block to:

image

It should be noted that neither of your requested outputs are valid json.

1 Like

On this occasion I try to:
obtain 3 lists that belong to 3 different items of the values ​​of (CNC, EROCION 01)
The list of items will be: (1,2,8)

At the same time I try to filter so that it is not repeated, because in the labels (CNC and EROCION 01) the values ​​could be repeated again

What is happening to me is that the values ​​of the new list of the selected label are increasing

What I want is for the selected and filtered label values ​​to appear

FireBase


Untitled

BLOCKS

It seems to me that here is the problem

[image]

If you need to collect things into a list at the request of a selection action, you should empty out the place where you will be collecting the selected items.

That is done by executing a Set global list_of_collected_items to create empty list.

It is not enough to just init global the variable as create empty list.

I thought this would do it (FB_O_FILTRA)

If not, is it like this, where in the block would it go (list_of_collected_items)

always in (GotValue)?

I would put SET global FB_O_FILTRA to Create Empty List in the
When DESP_M.AfterSelecting event.

It's like counting.
You don't set the count to 0 each time you get a new thing to count.
You set the count to 0 before you start counting.

1 Like

I found the problem
thank you