Skip to Main Content
Need Support? Let’s guide you to the right answer or agent.
Status Future consideration
Workspace AssetWise ALIM
Categories Search / Reports
Created by Guest
Created on Aug 16, 2024

eQL - Support STUFF()

Enhance the eQL used for Reports to include the STUFF() function.

This would allow multi value columns or multiple related objects to be displayed on a single row as a comma separated list rather than one row per related object/value. This would remove the duplicate rows issue in the current Reports/Searches where a column has multiple values; eg Document Report with column showing related Tags.


This was originally logged as SR7001376327 on 16FEB22 as an enhancement request but unfortunately was not migrated; see attached snip.

What underlying problem is this idea trying to solve?

This would remove the duplicate rows issue where a Report column has multiple values.

eg

Documents Report - Column showing Files

Documents Report - Column showing related Tags

Documents Report - Column showing Responsibilities

....