Hello,
I'd like to create a contacts lists fro an App (not run php/asp code) with every name grouped with the first letter (a,b,c, etc.):
framework7.io/docs/contacts-list.html

First question:
Is possibile to create a query that allow to distinct every group for the first letter?
A
Aaron
Abbie
...
B
Bailey
Barclay
...
C
...

Second question:
How can I create the repeat behaviours with "App Connect" for the eventual above query?

<div class="list-group">
      <ul>
        <li class="list-group-title">A</li>
        <li>
          <div class="item-content">
            <div class="item-inner">
              <div class="item-title">Aaron </div>
            </div>
          </div>
        </li>
        <li>
          <div class="item-content">
            <div class="item-inner">
              <div class="item-title">Abbie</div>
            </div>
          </div>
        </li>
      </ul>
</div>
<div class="list-group">
      <ul>
        <li class="list-group-title">B</li>
        <li>
          <div class="item-content">
            <div class="item-inner">
              <div class="item-title">Bailey</div>
            </div>
          </div>
        </li>
        <li>
          <div class="item-content">
            <div class="item-inner">
              <div class="item-title">Barclay</div>
            </div>
          </div>
        </li>
     </ul>
</div>

Thanks in advance for the help.

Hi Michele,
Is the first letter coming from a database?

Yes Teodor,
is the first letter of a text in the field ("company_name", type "varchar" ) of a table (database MySQL).

You will need to use the group by filter, select the value to group by and then apply the sub filter with start set to 0 and length of 1, to group by the first letter:

Thanks Teodor, I solved.
FYI, I had problems with Connect Data Formatting, with no possibilities to use it in the Site's folder of the app.
I had to work on the Site's folder where there are the php files for remote connection with the database (then I moved the generate code on the page of the app).

On the app site folder, every time I try to use the Data Formatting receive this error:

Hi Michele,
we will check this issue.