For me is not working distinct="true" !!!
var query = xtk.queryDef.create(<queryDef schema="nms:broadLogRcp" distinct="true" operation="select">
<select>
<node expr="count(@account_id)" alias="total"/>
</select>
<where>
<condition boolOperator="AND" expr={("@status = '1'")}/>
</where>
</queryDef>).ExecuteQuery();
var results = query.broadLogRcp;
logInfo("results count= " +results.total);
I have the same number for "totalC" if I run the query with distinct="true" or without it.
Can somebody explain why?
Thank you!