How show data from DB

Hi, i need to show data in a list from a prepopulated DB. So if i click a button calling a method
Select All
I can show all data in a list.
But i have a side-menu and i want to show data(go in another page where there is the list) when i select a voice of the menu.
I know maybe is very stupid thing, but i’m unable to do that!!! DAMN!!!
Maybe I need to set up a controller in app.js and controller.js??
I tried to use ng-click() in the menu voice but doesn’t work… 1000000000 dollar of prize!!! :wink:

This is the method to retrieve data from db in mi controller in app.js
_______________________________-
$scope.selectAll = function() {
var query = “SELECT rda_num, oggetto, richiesta,importo FROM tabella”;
$scope.allSessions = [];
$cordovaSQLite.execute(db, query, []).then(function(res) {
if(res.rows.length > 0) {

            for(var i = 0; i < res.rows.length; i++) {
              
              
               $scope.allSessions.push({
                rda_num: res.rows.item(i).rda_num,
                oggetto: res.rows.item(i).oggetto,
                richiesta: res.rows.item(i).richiesta,
                importo: res.rows.item(i).importo,
                });


               console.log("SELECTED -> " + res.rows.item(i).rda_num + " " + res.rows.item(i).oggetto + " " + res.rows.item(i).richiesta + " " + res.rows.item(i).importo);
            }
        } else {
            console.log("No results found");
        }
    }, function (err) {
        console.error(err);
    });
    
}

____________in the show page ____________

Select All

 <ion-list class="list">
    <ion-item ng-repeat="session in allSessions">
    <span class="note-data">Data: {{date | date: 'dd/MM/yyyy'}}</span>    
    RDA numero: <span class="note">{{session.rda_num}}</span>     
    Oggetto: <span class="note">{{session.oggetto}}</span>
    Richiesta: <span class="note">{{session.richiesta}}</span>     
    Importo: <span class="note">{{session.importo}}</span>
   
  </ion-item>
</ion-list>