Orderby Rand() not working on Postgres

[gijsstegehuis]

Describe the bug

->orderBy('RAND()'); is hardcoded here, but in Postgres RAND() it's called RANDOM()

formie/src/base/ElementField.php

Line 716 in af9c9f6

$query = $this->getElementsQuery()->orderBy('RAND()');

Steps to reproduce

1. Setup Postgres backed Craft instance
2. Visit some action that triggers actions/formie/email/preview

Form settings

• not relevant -

Craft CMS version

Craft Pro 5.4.4

Plugin version

3.0.7

Multi-site?

No response

Additional context

No response

[engram-design]

Fixed for the next release. To get this early, run composer require verbb/formie:"dev-craft-5 as 3.0.7".

[gijsstegehuis]

Awesome Josh!