Incorrect Syntax near ',' using scaffolding

Incorrect Syntax near ',' using scaffolding

I have a task status type table (i.e. Closed, Open, etc) and a task status table with a foreign key to the task status type table. I created the Task Status and Task Status Detail screens with scaffolding, and the combo box for Status Type ID was generated automatically but throws a syntax error when viewing the status detail view as a new or edited record. Could someone please help? I am new to outsystems and can't seem to decipher the message or find a direction to try. This is actually happening on a few different tables with similar set ups.

I'm not sure how to do that- but there is some sensitive customer data in the attached database. Can I copy and paste some screenshots from a certain area for you? I've also sent this on as a support case to outsystems at their request.

Thanks for the info- would you just like the project (oml file?) Also I have debugged it, it gets past the preparation just fine, but stops on rendering the combo box Status_TypeID. I have valid StatusType records, and the views for those work fine.

I've attached the OML. The error happens as the screen renders the combo box. In debugging it gets past preparation but fails as the combo box is loading. An end user would just see the error page as the page doesn't finish loading after the exception.

In outsystems everything looks correct. Did you try to get all the records from TaskStatusType with an aggregate and use that list on combobox source record list instead of using source entity. Check if this way it works and you also can check if you are getting any strange values from TaskStatusType

The error happens when the system tries to fetch data from the TaskStatusType entity to fill the combo box.The Incorrect syntax near ',' tells me that the query is being ill formed.

This can be a bug in the platform, or possibly (and more probable), your external tables, when imported, are not properly configured.

In any case, I would do a simple test. If you open the TaskStatusTypes screen, do you get any kind of error?If not, follow Marcelo's advice and change the combo box to fetch data from an aggregate instead of directly from the Entity. It's a workaround.