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 (0)
Category
Applications, 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