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)
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)
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.
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?
@anon78309838 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!
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 :-/
@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.
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.
Hello, currently I’ve the same issue/bug. Looking into the forum I’m very surprised that after so many months/year stills not solved. Even is mentioned in other discussions but Adalo’s support team fails fixing it or its solution isn’t well published. @Victor@Lukasz do you know why it has not been solved?
