Skip to main content

Assessment Read Only fields displaying error

In this article we explain how you can resolve invalid configuration within Assessment Read Only fields.

C
Written by Connor Baeza

You may see an invalid configuration for the Assessment Read Only field error if the SQL used in the read‑only field contains a line break directly after the SELECT keyword.

This formatting issue prevents the system from reading the SQL correctly.


Why this happens

If the SQL is written like this:

Select
Top 1 Code, CodeDescription

The line break after Select causes the configuration to fail.


How to fix it

Make sure the SQL is written on a single line, with a space after Select instead of a new line, like this:

Select Top 1 Code, CodeDescription

Once the SQL is in this format, the read‑only output will display correctly.

Did this answer your question?