15
Views
6
Comments
Solved
Is there some away to do query fast, only to search without include in project

In Outsystems there is a away to do query fast, without include in project ?

Because in SqlServer there is o Management Studio where we can do query fast only to search without include in project. 


Captura de tela 2024-09-13 103942.png
2023-01-19 12-23-07
Abhinav Shilwant
Solution

Hi @Vivian Mattos,

OutSystems doesn't have a dedicated tool like SQL Server Management Studio where you can quickly run adhoc queries outside of the project. However, there are a few ways you can achieve something similar,

1. Using External tools, if you’re using an on-premises OutSystems environment, you can connect directly to the database using tools like SQL Server Management Studio for quick queries. Just make sure to follow your organization’s guidelines when accessing the database directly to avoid any unintended impacts on performance or security.

2. Custom Test Page, you can also create a temporary test screen within your application to run queries or aggregates for quick data searches. This isn’t as fast as SQL Management Studio but can be useful for debugging purposes.

3. SQL sandbox forge, as mentioned above by @Dorine Boudry you can use this component to query fast your data on all the environments.

Hope this helps!


UserImage.jpg
Vivian Mattos

Thank so much @Abhinav Shilwant 

2018-05-30 14-43-10
Wouter Teensma

Not sure what you mean by 'include in project', but in general I would say yes. Reference an OutSystems entity from within a module and then in that module you can right click and View Data (provided the environment is in Dev mode). Or you can create an Adv SQL, write the query yourself and then use Test SQL. 

This is all quite basic OutSystems knowlegde so if you follow the introductory course you should be able to do this.

2021-09-06 15-09-53
Dorine Boudry
 
MVP

you can make use of SQL sandbox forge asset

UserImage.jpg
Vivian Mattos
2023-01-19 12-23-07
Abhinav Shilwant
Solution

Hi @Vivian Mattos,

OutSystems doesn't have a dedicated tool like SQL Server Management Studio where you can quickly run adhoc queries outside of the project. However, there are a few ways you can achieve something similar,

1. Using External tools, if you’re using an on-premises OutSystems environment, you can connect directly to the database using tools like SQL Server Management Studio for quick queries. Just make sure to follow your organization’s guidelines when accessing the database directly to avoid any unintended impacts on performance or security.

2. Custom Test Page, you can also create a temporary test screen within your application to run queries or aggregates for quick data searches. This isn’t as fast as SQL Management Studio but can be useful for debugging purposes.

3. SQL sandbox forge, as mentioned above by @Dorine Boudry you can use this component to query fast your data on all the environments.

Hope this helps!


UserImage.jpg
Vivian Mattos

Thank so much @Abhinav Shilwant 

2022-05-19 19-10-01
felipe.castilla

Hello,

If you're using Outsystems Cloud, it's possible to gain direct access to the database.

You can refer to the following documentation for more details: Access the Database of Your Outsystems Cloud.

To establish this connection, you'll need assistance from Outsystems Support to configure a VPN. Once set up, you'll be able to use SQL Server Management Studio to connect to your Outsystems Cloud database.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.