Custom Columns in LMS PRD Report SQL Query

[assravichandr]

Hi Experts,

Good day! I am currently creating a custom report in LMS. I need your help to please let me know how many custom columns I can use in my query?

The requirement I have is I need to put 5 custom columns under User but I am unable to do so because the query is giving me an error. I have used USER_VALUE and COL_NUM (for specification)

Example Query:

suser.USER_VALUE as JOB_GRADE,

But how I will use another column for different custom column under User?

Can anyone please enlighten me? Thank you!

Regards,

Wayne

[Matt-Everett]

Hi Wayne

there is no limit.  You might check LMS-Pros to see if they already have what you’re looking for.  If not they could help you with your file.