ian

Issue can also be replicated in GraphQL.  

@JonathanSchndr Thank you for the fast updates! The following merge in https://github.com/directus/directus/commit/e68e45bafa87ab05226484cd5c7ce4844643b102 led to an error when opening the `v-drawer` in the `files` interface. 🤔  @Nitwel Any thoughts on...

Yes it's somewhat related as the typecasting of filter value was fixed for aliased fields. For this issue, the app sends a request with an invalid ID in the following...

The `_contains` operator does not currently support all DB vendors as there some vendors may require the column to be casted as `text` type. Related discussion on `json` filtering: #7277

@madc This is resulting from #14829 where the filter is validated against the following allowable filter operators. https://github.com/directus/directus/blob/bbe7cb96a49e506140fcfe7fb00e87cf0aec182f/packages/shared/src/utils/get-filter-operators-for-type.ts#L44-L45

@rijkvanzanten The blackbox tests currently do not cover the dynamic variables and functions in filtering tests. I'm adding additional permissions testing capabilities which will then allow for the testing of...

Closing in favour of https://github.com/directus/directus/pull/14887. 👍

MSSQL might be an issue as it requires `IDENTITY_INSERT` to be turned `off` for manual insertion into identity column. 🤔 Ref: https://docs.microsoft.com/en-us/sql/t-sql/statements/set-identity-insert-transact-sql?view=sql-server-ver15

### Test notes The relational field `product_id` is not populated when validating in the API. If manually populated (just for testing), it has to be in the following format where...

`await trx.schema.dropTable(collectionKey);` was shifted to the start of the transaction instead of after relational fields are deleted. Thus resulting in the error as the table no longer exists. Ref: https://github.com/directus/directus/pull/11279/commits/24b96dc2c01f53a8134ba1cd84f9d4e39dd4a380