I was trying to model an array field as a base for a taginput widget. The relation of the array field pointed to a child table with a related child column. The related child column didn’t have specified a foreign key to the parent table and column.
I was expecting the array field renders correctly
Instead I’ve got an error (even if the array field wasn’t exposed to API) when trying to change a value of any other field in the screensection based on the entity with the array field.
I think a good enough soulution would be to add a new model validation: whenever a field is used in a relation that is used in an array filed, it must have defined foreign key fields.
> 2025-03-03 18:25:06,386 [22] ERROR Origam.Server.Controller.AbstractController - Invalid usage of aggregate function Count() and Type: Guid.
> System.Data.DataException: Invalid usage of aggregate function Count() and Type: Guid.
> at System.Data.Common.ObjectStorage.Aggregate(Int32[] records, AggregateType kind)
> at System.Data.DataExpression.Evaluate(DataRow row, DataRowVersion version)
> at System.Data.DataTable.EvaluateDependentExpressions(List`1 columns, DataRow row, DataRowVersion version, List`1 cachedRows)
> at System.Data.DataTable.EvaluateExpressions(DataRow row, DataRowAction action, List`1 cachedRows)
> at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Boolean suppressEnsurePropertyChanged, Int32 position, Boolean fireEvent, Exception& deferredException)
> at System.Data.DataRow.EndEdit()
> at Origam.Server.SessionStore.UpdateRowValue(String property, Object newValue, DataRow row) in C:\Users\urbanek\Desktop\leco\origam-server\backend\Origam.Server\Session Stores\SessionStore.cs:line 1562
> at Origam.Server.SessionStore.UpdateRowColumn(String property, Object newValue, UserProfile profile, DataRow row) in C:\Users\urbanek\Desktop\leco\origam-server\backend\Origam.Server\Session Stores\SessionStore.cs:line 1523
> at Origam.Server.SessionStore.UpdateObjectInternal(String entity, Object id, String property, Object newValue) in C:\Users\urbanek\Desktop\leco\origam-server\backend\Origam.Server\Session Stores\SessionStore.cs:line 1452
> at Origam.Server.SessionStore.UpdateObject(String entity, Object id, String property, Object newValue) in C:\Users\urbanek\Desktop\leco\origam-server\backend\Origam.Server\Session Stores\SessionStore.cs:line 1400
> at Origam.Server.SaveableSessionStore.UpdateObjectWithDependenies(String entity, Object id, String property, Object newValue, Boolean isTopLevel) in C:\Users\urbanek\Desktop\leco\origam-server\backend\Origam.Server\Session Stores\SaveableSessionStore.cs:line 258
> at Origam.Server.SaveableSessionStore.UpdateObject(String entity, Object id, String property, Object newValue) in C:\Users\urbanek\Desktop\leco\origam-server\backend\Origam.Server\Session Stores\SaveableSessionStore.cs:line 220
> at Origam.Server.SessionStore.UpdateObjectBatch(String entity, UpdateData[] updateDataArray) in C:\Users\urbanek\Desktop\leco\origam-server\backend\Origam.Server\Session Stores\SessionStore.cs:line 1935
> at Origam.Server.ServerCoreUIService.UpdateObject(UpdateObjectInput input) in C:\Users\urbanek\Desktop\leco\origam-server\backend\Origam.Server\ServerCoreUIService.cs:line 354
> at Origam.Server.Controller.UIServiceController.<>c__DisplayClass22_0.<UpdateObject>b__0() in C:\Users\urbanek\Desktop\leco\origam-server\backend\Origam.Server\Controller\UIServiceController.cs:line 221
> at Origam.Server.Controller.AbstractController.<>c__DisplayClass9_0.<RunWithErrorHandler>g__AsynFunc|0() in C:\Users\urbanek\Desktop\leco\origam-server\backend\Origam.Server\Controller\AbstractController.cs:line 93
> at Origam.Server.Controller.AbstractController.RunWithErrorHandlerAsync(Func`1 func) in C:\Users\urbanek\Desktop\leco\origam-server\backend\Origam.Server\Controller\AbstractController.cs:line 111