Hi, i have 2 tables
1°
id (AUTOINCREMENT)
caseTaskId
DV_Caseidentifier_for_eni_OdA
CaseFolderId
rifiutata
approvata
archiviata
DV_NAMECL_POS_ODA
DV_EBELP_ODA
DV_EINDT_ODA
DV_NETPR_WAERS_POS_ODA
DV_MENGE_MEINS_POS_ODA
DV_MATNR_TXZ01_POS_ODA
DV_MATNR_TXZ01_POS_ODA
DV_PEINH_POS
stepName
2°
id (AUTOINCREMENT)
caseTaskId
DV_Caseidentifier_for_eni_OdA
CaseFolderId
rifiutata
approvata
archiviata
DV_EBELN_ODA
DV_AEDAT_ODA
DV_EKGRP_EKNAM_ODA
DV_NETPR_WAERS_ODA
DV_StatoPraticaOdA
DV_NAME_ODA
DV_NAME_CR
DateCreated
I need to show the data under the line ------- in the view…How can i do? Using angular??
I used this to show the first view
$scope.selectAllODLC2 = function() {
//$scope.tabelle();
//visualizzo da tabella vera
var queryB = “SELECT * FROM Tab_OdL2 WHERE archiviata = 0”;
$rootScope.allODLC2 = [];
$cordovaSQLite.execute(db, queryB, []).then(function(res) {
if(res.rows.length > 0) {
for(var i = 0; i < res.rows.length; i++) {
$rootScope.allODLC2.push({
id: res.rows.item(i).id,
caseFolderId: res.rows.item(i).caseFolderId,
DV_EBELN_ODA: res.rows.item(i).DV_EBELN_ODA,
DV_AEDAT_ODA: res.rows.item(i).DV_AEDAT_ODA,
DV_EKGRP_EKNAM_ODA: res.rows.item(i).DV_EKGRP_EKNAM_ODA,
DV_NETPR_WAERS_ODA: res.rows.item(i).DV_NETPR_WAERS_ODA,
DV_StatoPraticaOdA: res.rows.item(i).DV_StatoPraticaOdA,
DV_NAME_ODA: res.rows.item(i).DV_NAME_ODA,
DV_NAME_CR: res.rows.item(i).DV_NAME_CR,
DateCreated: res.rows.item(i).DateCreated,
DV_Caseidentifier_for_eni_OdA: res.rows.item(i).DV_Caseidentifier_for_eni_OdA,
archiviata: res.rows.item(i).archiviata,
approvata: res.rows.item(i).approvata,
rifiutata: res.rows.item(i).rifiutata,
});
$rootScope.allODLJSON2 = JSON.stringify($rootScope.allODL2);
//console.log("json Tabella_OdL" + JSON.stringify($rootScope.allODL));
}
} else {
console.log("No results found Tab_OdL2");
}
}, function (err) {
console.error(err);
});
}
to show first view
ion-item class="wrapword" ng-repeat="object in allODLC2 | filter: searchQuery | orderBy:sortType:sortReverse " href="#/app/detailOdl/{{object.id}}">
div ng-repeat="row in [1] track by $index">
span class="note-data">{{object.DateCreated | date :"dd/MM/yyyy"}}</span>
br>
<p id="rdaTit">Case Po: <span class="note">{{object.DV_Caseidentifier_for_eni_OdA}}</span>/p>
p>Total Value: <span class="note">{{object.DV_NETPR_WAERS_ODA}}</span></p>
p>Purchasing Doc: <span class="note">{{object.DV_EBELN_ODA}}</span></p>
p>Purchasing Gr: <span class="note">{{object.DV_EKGRP_EKNAM_ODA}}</span></p>
p>Vendor: <span class="note">{{object.DV_NAME_ODA}}</span></p>
p>caseFolderId: <span class="note">{{object.caseFolderId}}</span></p>
/div>
/ion-item>