Develop > Wizards > Troubleshooting > Query returned a list of records rather than a single record

Query returned a list of records rather than a single record

According to the wizard setup, a single record should be returned from the query entered in the Usage tab. Instead, a true search was performed.

Cause

Incorrect query syntax was used. For example, agreement.id in $L.file=168. Query statements should not include the file variable.

Fix

Use correct query syntax. For example, "agreement.id="168.