Tag Archives: advanced query

OutSystems – How the Count output parameter counts rows

In OutSystems you can use the “Count” output parameter, supplied with both aggregates and advanced queries, to count the number of rows that would be returned by the aggregate or advanced query. Aggregates When using “Count” for an aggregate, the OutSystems platform will count the number of records by using SELECT COUNT(1) FROM <tables, join conditions and filters> Advanced Queries When… Read more »

OutSystems – Use of comments in Advanced Queries

I was creating an advanced query (see post OutSystems – Getting Database Information) for the DBCleaner application to display table space usage. When I executed the query in OutSystems Service Studio using the “Test” button, it gave a (the expected) result, so publish the application an go! Publishing the application went fine, but when I went to the page with… Read more »