Hello
Developed Custom Query at Web component level using reference of below document link
https://wiki.servoy.com/display/DOCS/Fo ... perty+type
https://wiki.servoy.com/display/DOCS/QBSelect
Code :
var childFoundset = parentFoundset.duplicateFoundSet();
var query = parentFoundset.getQuery();
query.result.addPk();
var pkColumns = query.result.getColumns();
query.result.clear();
for (var pkIndex = 0; pkIndex < pkColumns.length; pkIndex++) {
query.result.clear();
query.result.add(pkColumns[pkIndex].min);
query.result.add(query.columns.article_id.count, 'maximum_items')
query.groupBy.add(groupColumn);
query.sort.clear();
}
childFoundset.loadRecords(query);
Query Genereated:- select top 201 max(article_id), count(article_id) as maximum_items from article group by articlestatus_id order by articlestatus_id asc
Error:- ERROR org.sablo.websocket.WebsocketEndpoint - Error: Wrapped java.lang.IllegalArgumentException: The query does not have the correct number of pks in the select
Please provide guild for find group count using QBselect query