We’ve developed some resources to help you work effectively from home during COVID-19 Click to learn more

"Operators for int[] fields require a FieldInfo argument of type FKArray; got appointment.task_idx FK"

Hi,

using the REST API I'm issuing the following call to get a list of documents.

GET /CustXXXXX/api/v1/Archive/findDocument?$select=documentId,date,type,text,contactId,contact/nameDepartment,projectId,project/name,saleId,person/personId,person/fullName,sale/heading,associate/associateDbId,associate/assocName&$filter=(contactId=1 or projectId=1 or saleId=1) and type oneof (1,4,3,5,6,106,2,59,60,104)&$orderBy=date desc

This has been working fine for several databases, but now we have one installation in SOD that throws the following 500 Internal Error:

Operators for int[] fields require a FieldInfo argument of type FKArray; got appointment.task_idx FK
 
If I change the type criteria from "oneof" to "in" it seems to work.
 
type oneof (1,4,3,5,6,106,2,59,60,104)
changed to
type in (1,4,3,5,6,106,2,59,60,104)
 
 
Any idea what causes this? Has something changed with the int[] operators lately?

RE: "Operators for int[] fields require a FieldInfo argument of type FKArray; got appointment.task_idx FK"

FKArray is not new, it was introduced with Service Tags..

Sorry for any inconvenience...will have to investigate.

Von: Tony Yates 19. Jun 2020

RE: "Operators for int[] fields require a FieldInfo argument of type FKArray; got appointment.task_idx FK"

Weird thing is that I've used this code with both 8.5 and G9 in SOD for many weeks, but sometime this last week it stopped working. Gut feeling is that something changed in the 9.1 patch I'm on.

Von: Frode Lillerud 19. Jun 2020

RE: "Operators for int[] fields require a FieldInfo argument of type FKArray; got appointment.task_idx FK"

Odata support for intArray operators landed last week. Your tenant was one of the early partner tenants for 9.1 and it was running the patch version with not completed features. 
I will upgrade your tenant now to the release branch.

Von: Margrethe Romnes 22. Jun 2020

RE: "Operators for int[] fields require a FieldInfo argument of type FKArray; got appointment.task_idx FK"

Thanks!

Von: Frode Lillerud 22. Jun 2020