SQL/ Output Entities / Structures Is there a way to be more Generic?

SQL/ Output Entities / Structures Is there a way to be more Generic?

  

Hello guys,

I'm new to OutSystems and so far i'm enjoying the platform.

After some Courses I've created one Widget that implements https://querybuilder.js.org/ the maximum Generic way, so we can use Advanced Filters in all tables if needed with only "some" steps before the implementation.

e.g.

These "some" steps are actually chase after me at what I'm currently doing at OutSystems and is not cool :)

In this example I need to change at least 4 or 5 Aggregates/SQL for each table and pass as parameter the name of the table to work, because i'm getting the fields of the table (and type of the fields) to be possible to select at the Advanced Filter with the right conditions and to generate a SQL statement with the querybuilder, after that i need to do another call with that query to refresh the table.

Right now I'm creating another Widget to use Highcharts but in a way that the User can create their own charts and Reports from the tables at OutSystems with a lot of options, in short like this http://editor.highcharts.com/full.html but a little more advanced.

e.g.


I need to have a lot of SQL/Aggregate to do this and Output Entities/Structures as well.

So.. The questions (finally :|):

There's any way to retrieve the Data in a Generic way?

Can I use the Integrations Studio to do a Server Action and pass the parameters the name of the table and the query and will return maybe a JSON?

Can you guys give me some ideas? :)

Thanks a lot and sorry for the long post.

Solution

Hey Rafael,

there is way for you can do that.

You can use this extension https://www.outsystems.com/forge/component/1305/advancequery/

This extension allow to get any SQL and return a JSON.

Solution

PAULO RICARDO FAGUNDES JUNIOR wrote:

Hey Rafael,

there is way for you can do that.

You can use this extension https://www.outsystems.com/forge/component/1305/advancequery/

This extension allow to get any SQL and return a JSON.

Hey Paulo,

Thanks for the fast reply, I think this is it :) I will investigate and report back if it is enough.

Cheers.