APEX

See https://apex.oracle.com/pls/apex/f?p=134181:19

The list region uses a Dynamic list with the following query and the Media List template for display with the Show Badges template option enabled.

select
  level lvl,
 'link' link,
 'text' text,
 'a01' a01,
 'a02' a02,
 'a03' a03,
 'a04' a04,
 'a05' a05,
 'a06' a06
from dual
connect by level <= 10

The (default) list template is

<li class="t-MediaList-item is-active #A04#">

    <a href="#LINK#" class="t-MediaList-itemWrap #A05#" #A03#>

        <div class="t-MediaList-iconWrap">

            <span class="t-MediaList-icon u-color #A06#"><span class="t-Icon #ICON_CSS_CLASSES# u-color #A06#" #IMAGE_ATTR#></span></span>

        </div>

        <div class="t-MediaList-body">

            <h3 class="t-MediaList-title">#TEXT#</h3>

            <p class="t-MediaList-desc">#A01#</p>

        </div>

        <div class="t-MediaList-badgeWrap">

            <span class="t-MediaList-badge">#A02#</span>

        </div>

    </a>

</li>

Several things don't make sense to me

1. Why does the list show only 1 row from the query?
2. Why doesn't the rendered output match the template? e.g. #TEXT# and #A01# are the visible elements but the page shows link and a05 which are HTML tag attributes
3. Line 11 of the template says to display #A02# as but #A06# is displayed instead

I am trying to implement the Variation A pattern demonstrated here but that uses a Static list so I can't follow along. That shouldn't matter really as long as the SQL query produces the output with the column names the template is looking for, right?

What am I missing here?

Thanks