@George Can you see something wrong on this?
I see no data
<!doctype html>
<html>
<head>
<script src="dmxAppConnect/dmxAppConnect.js"></script>
<meta charset="UTF-8">
<title>Untitled Document</title>
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, minimum-scale=1, user-scalable=no, viewport-fit=cover">
<meta name="mobile-web-app-capable" content="yes">
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="apple-mobile-web-app-status-bar-style" content="black-translucent">
<meta name="format-detection" content="telephone=no">
<meta name="msapplication-tap-highlight" content="no">
<meta http-equiv="Content-Security-Policy" content="default-src * 'self' 'unsafe-inline' 'unsafe-eval' data: gap: content:">
<link rel="stylesheet" href="dmxFramework7_icons/css/framework7-icons.css" />
<script src="capacitor.js"></script>
<link rel="stylesheet" href="css/style.css" />
<script src="js/plugins/sqlite/plugin.js" defer></script>
<script src="js/jeep-sqlite/dist/jeep-sqlite/jeep-sqlite.esm.js" type="module"></script>
<script src="dmxAppConnect/dmxCapacitorSQLite/dmxCapacitorSQLite.js" defer></script>
<script src="js/connections/mydb.js" defer></script>
<link rel="stylesheet" href="Framework7/5/css/framework7.bundle.min.css" />
<script src="Framework7/5/js/framework7.bundle.min.js"></script>
<script src="js/routes.js"></script>
<script src="dmxAppConnect/dmxFramework7/dmxFramework7.js" defer></script>
</head>
<body is="dmx-app" id="index">
<div id="app" is="dmx-f7-app">
<div id="view1" class="view view-main">
<div class="page">
<script is="dmx-flow" id="flow1" type="text/dmx-flow" autorun="true">{
Capacitor.sqlite.select: {
connection: "mydb",
sql: {
type: "select",
columns: [
{table: "users", column: "id"},
{table: "users", column: "firstname"},
{table: "users", column: "lastname"}
],
params: [],
table: {name: "users"},
primary: "id",
joins: [],
query: "select `id`, `firstname`, `lastname` from `users`"
},
name: "query",
output: true,
outputType: "array"
}
}</script>
<div class="page-content">
<h1>asd</h1>
<div class="row" dmx-repeat:repeat1="flow1.data.query">
<div class="col-auto">
<p dmx-text="firstname"></p>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>
Tried with a simple Api and works as expected:
<dmx-api-action id="api1" url="http://dummy.restapiexample.com/api/v1/employees"></dmx-api-action>
<div class="row" dmx-repeat:repeat2="api1.data.data">
<div class="col-auto">
<p dmx-text="employee_name"></p>
</div>
</div>