List of lists external collection

Hello Guys,
i am trying to build a list of lists (actually list of lists of lists) by using external collections.
I integrated the collections, all seems to work fine. However when I want to filter the end list by “current” magic text from previous list element the filter does not work.

The values are available in the magic text so Adalo seems to understand them however when I input them the filters is totally off.
I am using @xano and checked both regular filtering by inputs and external - using json in Adalo but nothing seems to work.
My API works fine when I use hardcoded values to input for testing in Adalo (both for input filtering and JSON approach) however magic text that passes a value of current list element does not work (all elements are displayed like a filter would be empty)

Would you guys be able to help?

2 Likes

I was trying to debug it and it seems that sub-list receives right data from the overriding list (red text is basically the same) however if list receives the same magic text as filter value (both for Json / or simple filtering) it is not able to use them.
if the data however are passed as magic text from the previous screen and used as a filter, in this case list is also filtered properly.

I am trying to understand what makes this use case different but for now it seems that Adalo cannot create list of lists from external collection which of course is super limiting for building any type of apps.

Sub list receives proper date in magic text (current element) - how is not able to filter by it)

1 Like

Any idea how to solve it anyone?

Hi @Lukasz,

Your issue seem similar to this one: Nested List Query parameter don't work with magic words

Not sure there is a solution available :frowning:

Best,
Victor.

Hi.
If you realy need this specific fonctionality, you should use Adalo’s API to create and update a copied table of your data and use it inside your main list.
With this solution your nested list will be inside adalo’s storage and will be filtered with adalo system and you can update it externaly with your own API (using adalo’s api request to update the table inside adalo’s storage.)
Link of documentation : Collections - Adalo Resources

If you don’t want to do that, just change your navigation system to do not show multiples lists of external collection on one page.

1 Like

Thanks Nicolas, it is actually super helpful. Amending UX does not really solve my issue - It is only about presenting things in clear way not about access directory. Using Adalo collection can actually work but only if I do temporary (populate when user lands on the page and then clear it) - did you try it?

@Colin any idea where you guys stand with this fix?

I’m also stuck with this, it’s a bummer I can’t show the order items in the list of orders, as the filter doesn’t pass the order_id parameter. I noticed all API calls go out asynchronously, so it basically triggers the API call for the second list before it even receives the response for the first list. This looks to me like a bug, not lack of functionality. Please fix!

1 Like

Hi @emycarlan,

Just for information - when I added timer in similar setup (trying to make sure the data is received), it didn’t help… so I guess the bug is more complex as it seems :-/

Best,
Victor

@adalo @Ben Guys this is a bug that wasn’t fixed for quite a while now. I am raising it every time I receive your email on how to help - always promised that you look into this but our iteration never last more than two replies and than it is dropped again.

1 Like

Running into this issue right now.

Yep still an issue, the other problem is that when I stry to query the parent along with a list of the children by extending the output, that causes another set of bugs.

This still seems to be an issue. Has anyone found a solution yet?

I think this is what you are looking for

Go to PragmaFlow Adalo Toolkit and watch the video labeled Displaying nested arrays from an API. I believe this is what people are trying to do.

Skip to 15:50 in the video to see if this is the results you are looking for, if it is then you can watch the whole video.

1 Like