I am using a Custom List View , lv1, in Retool to populate a series of rows returned by a query, q1. I have a nested Custom List view, lv2, within lv1, which I want to populate using a query q2 that uses a variable returned by the q1. Example: -- q1 (SQL): populates `lv1` data = SELECT * FROM tabl…

Hi, welcome to the forums So it sounds like you want a parent/child structure with your nested lists. That's perfectly possible but the i variable you're trying to use is only an internal property of that list so won't be available, as you've discovered. What I would recommend is you have your 2 q…

Using Variable `i` from Custom List View in New SQL Query

💬 Queries and Resources

victoria February 25, 2023, 5:45am 3

Hey @shubham

Thank you for the super helpful reply as always @dcartlidge!

This recent Community post might also be helpful:

http://community.retool.com/t/listview-component-value-in-rest-api/17531/14

2 Likes

Topic		Replies	Views
ListView and {{i}} 💬 Queries and Resources bug , sql	10	3293	March 13, 2023
Use API Rest Json Data from one query in another API Rest query 💬 Queries and Resources	8	3125	July 27, 2023
How to reference the parent index in a nested list view 💬 App Building	5	230	February 10, 2025
Listview sometimes can't access {{i}} 💬 App Building	4	386	May 10, 2024
How to access nested listview 💬 Queries and Resources javascript	2	1542	January 29, 2024

Using Variable `i` from Custom List View in New SQL Query

Related topics