Advance Query

Stable Version 11.0.1 (O11)
Also available for 10, 9.1
Published on 20 December 2019 by 
Created on 27 May 2016
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 .
Read More

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 .


What’s new (11.0.1)
  • Connection Management:
    Now is possible do rollback or commit transaction independent of Outsystems main transaction.

  • Error Handler: 
    None exception is thrown out side extension. The exceptions that occur inside extension are return by one specific parameter called ErrorHandle.

  • Bootstrap Excel (only SQL for now):
    Imagine can insert excel lines directly and dynamic your database table.
    This functionality allows that. You just make sure your excel has the same name columns as your entity. do not forget about ID, it's autonumber most of times your cannot put it in excel.

  • Refactoring:
    As part of my effort to help Outsystems developers understand how outsystems works, I have working at this refactoring to provide a clearly code and understandable.
Reviews (1)
16 Apr
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?
Category
Developer Tools
Support Options
This component is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from Paulo Fagundes Jr. who created this component.
Dependencies
See all 1 dependencies
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
Component Consumers
No consumers yet.
Weekly Downloads