Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    concat summaryFunction with customSelectExpression

    SNAPSHOT_v13.0d_2021-09-21/Enterprise Deployment

    Oracle db

    Hello, I'm trying to use the concat summaryFunction, ie:

    Code:
                <summaryFunctions>
                    <ROLE>concat</ROLE>
                    <USER_PERMISSION_NAME>concat</USER_PERMISSION_NAME>
                </summaryFunctions>
    USER_PERMISSION_NAME is an includedFrom field, while ROLE is a customSelectExpression field.

    For USER_PERMISSION_NAME I obtain a working LISTAGG, while for ROLE I get a CONCAT(ROLES.ROLE) AS ROLE which obviously doesn't work, so I'm wondering if the concat summary function is supported for a customSelectExpression field.

    #2
    We've made changes to support concat summary function for a field with customSelectExpression, which are available in 13.0 nightly build since Oct 2 (today). Let us know please if it works for you once you try it.

    Comment


      #3
      SmartClient Version: SNAPSHOT_v13.0d_2021-10-02/Enterprise Deployment (built 2021-10-02)

      yes, I can confirm it's working, thank you very much!

      Comment

      Working...
      X