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.

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?