SQL Editor for DML operations

SQL Editor for DML operations

  

Hi,

 I have a sample UI . In that i will peform DML operations

Eg: select * from employees

In the bottom it should display the information. How can i achieve this.

You want something like a query editor in OutSystems?

First of all, I would like to strongly advise you not to create this, because once this is available it can be misused to query your database / clean your database. Make sure that there is no data in your database that is private / critical for your business.

Here is a work-around to create something like this:

1. create a generic structure with only text-fields (enough to place all fields of your biggest query)

2. Create an advanced query with an input parameter that has "Expand Inline" set to true.

3. Create a screen with a text-box (attached to a text-variable)

4. Button to run the query you typed in the text-box (run action that has the advanced query with the input parameter)

5. table with result from the query (generic structure).

This is the basics and might work, but it might also be that you need to automatically rewrite your query before running and convert the entity names to physical table names.

Kind regards,

Remco Dekkinga

Thanks for the reply Remco.

Yes , I want to query editor. I am newbie to this outsystems. Can you send me sample OML file. 

So that it will be easy for me.

Thanks in advance


Sandeep

Solution

Hi Sandeep,

See this post from me for a very simple example.

https://www.outsystems.com/forums/discussion/22922/advance-query-editor/#Post90018

Kind regards,

Remco Dekkinga

Solution