Newbie : Returning only 1 row in SQL in ListView component on a page

Hi, I am a newbie so please forgive me, as I wish there was a detailed course on UI Bakery. Although I think it is powerful.

  1. I have a page component, with a listview component from structure
  2. I also have a database table called Jurisdictions, with a field called full_name for a country.
  3. I created an action on the input component on the listview to do the following:

SQL “Select * from Jurisdiction” and set a Transform modify result to this:

{{ui.publicIzTbJurisdictionForm.value.tb_juris_full_name}}

My problem it is returning only one row and I would like it to return all rows, so all the input columns on this list view get filled up with different countries.

Can anyone direct me as to what I am doing wrong?

Thanks

Resolved, loaded all the data at listview level and then at individual element level referred to it by item name. Newbie error. Now I have to got to figure out how to put checkboxes and then read and insert the chosen checkboxes into a database table

1 Like