Hello, 

Is there a way to list up SQL elements in module?
I want to check all SQLs I've written.

Sincerely,
Moriya Takasi

Solution

Hi Takasi,

You could search for "SELECT", which will turn up all SQLs (at least those returning data, if you have update queries, you can search for "UPDATE" as well).

Solution

Hi Takasi, 

You can search with the keyword "SQL" and attached the sample search for easy understand.

Hi Takasi,

Service Studio doesn't have that specific functionality (list SQL elements inside a module).

Your best option is to follow Kilian's suggestion and search for key words used in SQL language ("select", "update", "where", "from").


Kind regards,

Rui Barradas

Hello all,

Thank you for comments.
I now understand that there aren't functionality to list by element type.

(Mahesh's suggestion is only for case that element's name contains string 'SQL'.)

Using SQL keywords like 'SELECT' leads multiple hits for same element which uses it more than 1 times.
It is helpful for me if there is a way to get distinct list.

I posted a new Idea.
https://www.outsystems.com/ideas/9374/service-studio-search-by-element-type

Takasi Moriya wrote:

Hello all,

Thank you for comments.
I now understand that there aren't functionality to list by element type.

(Mahesh's suggestion is only for case that element's name contains string 'SQL'.)

Using SQL keywords like 'SELECT' leads multiple hits for same element which uses it more than 1 times.
It is helpful for me if there is a way to get distinct list.

I posted a new Idea.
https://www.outsystems.com/ideas/9374/service-studio-search-by-element-type

 Good that you converted it to an idea