Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Is there an SWQL equivalent to MS SQL's String_AGG function?

Is there an SWQL equivalent to MS SQL's String_AGG function? that takes a list of items a combines it into a delimited string.

Here is a sample SQL that I would like to do as a single SWQL statement.

SELECT top 10
    Nodes.Caption,
    Nodes.NodeID,
    ( SELECT String_AGG( '['+c.Name+']', ',' ) as GroupList FROM [dbo].[ContainerMemberSnapshots] cmss Left Join [dbo].[Containers] c on c.ContainerID = cmss.ContainerID   Where   cmss.EntityID = Nodes.NodeID and c.Owner = 'Core' and cmss.EntityType = 'Orion.Nodes' ) as Groups
FROM Nodes

This gets me a list of groups as a string list that looks like [group1],[group2],[group3], and I would prefer to do this in SWQL.

Find more posts tagged with

Accepted answers

All comments

Seashore

Is it CONCAT() you are looking for?

Concat(a, b, c, ...) - Takes one or more arguments and returns a single string that is the concatenation of the values of the arguments.

https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions

brscott

I did try that, but I cannot figure out how to make it take an SWQL subquery as a parameter. Do you have an example?

brscott

Or as in the example above, I cannot figure out how to make it work as an aggerate function inside the subquery.

Seashore

Read a bit more about String_Agg. Looks like it can take data from several ROWS and combine them, CONCAT can combine data from several COLUMNS.
Don't think there is anything in SWQL that matches String_Agg.

chad.every

This is not available in SWQL today. We are tracking it internally under OO-37715, but it is not on an active roadmap.