Skip to main content
Question

Error in PQL

  • March 4, 2026
  • 2 replies
  • 21 views
Gayatriiiii.B
Level 2
Forum|alt.badge.img+1

Hi everyone,

The table _CEL_O2C_ACTIVITIES exists in my Data Model and contains the column ACTIVITY_EN. The data model loads successfully.

However, when I reference it in my PQL, I get the following error:

A PQL error is preventing this query from executing.
Syntax error near [.] after reading [ "_CEL_O2C_ACTIVITIES"] at line 7.

I have verified:

  • The table exists

  • The column exists

  • No spelling mistakes

  • Data model is loaded correctly

Has anyone encountered this issue before?
Is there a specific reason why referencing _CEL_O2C_ACTIVITIES"."ACTIVITY_EN would trigger this syntax error?

Any suggestions would be appreciated.
 

 

2 replies

fabian.wende
Level 6
Forum|alt.badge.img+1

Hello,

you need to specify a column from the source_table which should be counted - the syntax of the PU_COUNT function is as following:

PU_COUNT ( target_table, source_table.column [, filter_expression] )

You only used a target_table and the filter_expression. Just use “ACTIVITY_EN” as source_table.column and you should be fine :)


Best regards,

Fabian

    Gayatriiiii.B
    Level 2
    Forum|alt.badge.img+1

    Thank You!

     

    Community Code of ConductAccessibility statement