Directus v9.14.2 — Release Notes & Engineering Impact

## v9.14.2 (July 21, 2022) ### :rocket: Improvements - **App** - [#14541](https://github.com/directus/directus/pull/14541) Select multiple dropdown preview threshold (by @rijkvanzanten) - [#14412](https://github.com/directus/directus/pull/14412) Enable spellcheck on wysiwyg and markdown interfaces (by @licitdev) - [#14390](https://github.com/directus/directus/pull/14390) Fix strict relative dates showing "incorrect" (by @u12206050) - [#14021](https://github.com/directus/directus/pull/14021) Add raw editor toggle for using variables in flows operations (by @azrikahar) - [#10592](https://github.com/directus/directus/pull/10592) Optimize media loading across app (by @jaycammarano) - [#10488](https://github.com/directus/directus/pull/10488) Adding editor to image component (by @juancarlosjr97) - **API** - [#14499](https://github.com/directus/directus/pull/14499) Enable extensions cache (by @claytongulick) - [#9400](https://github.com/directus/directus/pull/9400) Add "security" commands to api CLI (by @danilopolani) - **Extensions** - [#14475](https://github.com/directus/directus/pull/14475) Improve extension create onboarding (by @u12206050) ### :bug: Bug Fixes - **App** - [#14543](https://github.com/directus/directus/pull/14543) Fix map layout not rendering items on search (by @rijkvanzanten) - [#14542](https://github.com/directus/directus/pull/14542) Fix singleton navigation temporarily using wrong ID (by @rijkvanzanten) - [#14539](https://github.com/directus/directus/pull/14539) Don't render explicit null values in md custom blocks (by @rijkvanzanten) - [#14538](https://github.com/directus/directus/pull/14538) Add max height to folder picker (by @rijkvanzanten) - [#14537](https://github.com/directus/directus/pull/14537) Don't disable distinct count based on integer type (by @rijkvanzanten) - [#14536](https://github.com/directus/directus/pull/14536) Default auth provider to first configured one if default is disabled (by @rijkvanzanten) - [#14532](https://github.com/directus/directus/pull/14532) Skip disabled field check when using set-field-value event (by @rijkvanzanten) - [#14530](https://github.com/directus/directus/pull/14530) Fix M2A filter scope on select existing (by @rijkvanzanten) - [#14511](https://github.com/directus/directus/pull/14511) Fix the preview not being updated after editing the image (by @qborisb) - [#14488](https://github.com/directus/directus/pull/14488) Conditions not working (partially) (by @br41nslug) - [#14438](https://github.com/directus/directus/pull/14438) Prevent app crash on empty manual flow config (by @rijkvanzanten) - [#14404](https://github.com/directus/directus/pull/14404) Fix/wysiwyg context menu (by @licitdev) - [#14402](https://github.com/directus/directus/pull/14402) Insights: Fix query primary field for system tables (by @joselcvarela) - [#14396](https://github.com/directus/directus/pull/14396) Fix list panel descending sort (by @azrikahar) - [#14369](https://github.com/directus/directus/pull/14369) Fixes nested groups in accordions not rendering fields (by @br41nslug) - [#14358](https://github.com/directus/directus/pull/14358) Fix disabled state for markdown interface (by @azrikahar) - [#14355](https://github.com/directus/directus/pull/14355) Fix translation in render-template (by @u12206050) - [#14322](https://github.com/directus/directus/pull/14322) Prevent empty title attribute in WYSIWYG links (by @azrikahar) - [#14256](https://github.com/directus/directus/pull/14256) Fix field aliasing not returning null after merging documents (by @addisonElliott) - [#10592](https://github.com/directus/directus/pull/10592) Optimize media loading across app (by @jaycammarano) - **API** - [#14540](https://github.com/directus/directus/pull/14540) Add missing _between/_nbetween filter operators to GQL (by @rijkvanzanten) - [#14520](https://github.com/directus/directus/pull/14520) Graphql: Do not try to convert Dates (considered an object) (by @joselcvarela) - [#14512](https://github.com/directus/directus/pull/14512) Disable foreign check on SQLite when deleting fields (by @licitdev) - [#14506](https://github.com/directus/directus/pull/14506) Fix apply snapshot for UUID primary keys (by @azrikahar) - [#14460](https://github.com/directus/directus/pull/14460) API/Graphql: Use same types as `count` for `countDistinct` (by @joselcvarela) - [#14423](https://github.com/directus/directus/pull/14423) Fix filter column aliasing (by @licitdev) - [#14418](https://github.com/directus/directus/pull/14418) Encoded the url using encodeURIComponent, so that the url gets sanitzed and so, we did not get 404 error. (by @zeel-pathak) - [#14416](https://github.com/directus/directus/pull/14416) fix generateJoi error due to empty permissions when creating new role (by @azrikahar) - [#14401](https://github.com/directus/directus/pull/14401) Don't use locales in generated camelCased values from env (by @rijkvanzanten) - [#14371](https://github.com/directus/directus/pull/14371) Add GraphQL query POST caching (by @rijkvanzanten) - [#13949](https://github.com/directus/directus/pull/13949) Fix: Error applying schemas with nested collection(s) (by @IanPirro) - [#13870](https://github.com/directus/directus/pull/13870) Process relational collection's permissions in functions (by @licitdev) - [#11462](https://github.com/directus/directus/pull/11462) Cache GraphQL POST queries (by @viters) ### :sponge: Optimizations - **Misc.** - [#14555](https://github.com/directus/directus/pull/14555) Resolve lint warnings (by @rijkvanzanten) - [#14525](https://github.com/directus/directus/pull/14525) Cancel all previous workflows in the branch (by @licitdev) - [#14350](https://github.com/directus/directus/pull/14350) Move repo to `pnpm` based workflow (by @rijkvanzanten) - [#14335](https://github.com/directus/directus/pull/14335) Move external packages to separate repos (by @rijkvanzanten) - **API** - [#13596](https://github.com/directus/directus/pull/13596) Generate joi merge (by @jaycammarano) ### :package: Dependency Updates - [#14509](https://github.com/directus/directus/pull/14509) Update Knex version to fix CockroachDB relationships showing multiple times (by @christopher-kapic) - [#14437](https://github.com/directus/directus/pull/14437) Update knex-schema-inspector to 2.0.3 (by @rijkvanzanten) Directus refs/tags/v9.14.2