Advance Query - Overview (O11) | OutSystems

Log in

Give us feedback

Stable version 11.0.4 (Compatible with OutSystems 11)

Other versions available for 10 and Older

Uploaded on 29 October 2022 by

4.8

(13 ratings)

advancequery

Details

You can execute command in database using Database Connections of the Service Center or direct using current connection. Export a return query sql dynamic to Excel, JSON, HTML TABLE .

Asset screenshot_0

You can execute command in database using Database Connections of the Service Center or direct using current connection. Export a return query sql dynamic to Excel, JSON, HTML TABLE .

Release notes (11.0.4)

Extension and demo module split into two applications.

Reviews (1)

by

2020-04-16

in version 11.0.1

How to fix the Date? when export to excel, the as long as it is DATE or Time, it will set to a number. have to manually change in the excel. But if we have hundred of report and many DATE format in each excel.. very troublesome to change it one by one. Any idea?

Team

Champion

Related assets

Discovery is a visual tool to help analyze, measure and understand how to improve your factory architecture

data-migration-manager-dmm

Data Migration Manager is a robust, cost-efficient, and intuitive data management solution. DMM - Data Migration Manager enables you to reduce costs by saving hundreds of hours that were spent in building custom scripts, allowing you to increase quality and unprecedented flexibility and speed in managing your data. DMM enables data and BPT migration across/into/out of OutSystems environments (onPrem, Hybrid, Cloud, PaaS), databases (mySQL, Oracle, SQLServer) and OS versions (v9 , v10 or v11) using a simple user interface without the need of building custom scripts. It also supports features like data anonymization, data scramble and data deletion, essential to comply with GDPR.

TestFramework is an open-source application that offers simple management and automated execution of OutSystems Unit and API tests. With seamless integration with BDD Framework and Unit Testing Framework , it allows automated regression tests setup and execution. With the recent addition of Ghost Inspector integration, it now also allows the inclusion of automated UI tests in the test suites. TestFramework is provided by Indigo, an OutSystems partner, with ample experience in automated testing strategy and implementation. With the latest update, it’s now possible to analyze, track, and produce reports of your project’s code coverage, load tests from other environments and schedule your test runs! Take a tour!

More from Paulo Fagundes Jr.

human-readable-change-history

Create human-readable audits by simply supplying the changed record(s). Example: Name changed from 'John' to 'Peter' Age defined to '32' Country changed from 'England' to Portugal'

daterangepicker

The Date Range Picker can be attached to any webpage element to pop up two calendars for selecting dates, times, or from predefined ranges like "Last 30 Days".

multilingual-helper

Multilingual Helper is a resX editor file, it's made to help to manage Outsystems Translations, but can be used to manage any resX file. The idea of this app is to be able to join all translation labels in just one place, so those labels can be easily translated, exported and then imported into Outsystems. This application is not a replacement for any translation, it's a tool to help you to work with Outsystems translations instead of using Outsystems spreadsheets. I intend to address things that will help the teams to identify new labels added and labels changes that might need their translations reviewed.