search

verbb / formie

The most user-friendly forms plugin for Craft CMS.
Other
96 stars 73 forks source link

Orderby Rand() not working on Postgres #2071

Closed gijsstegehuis closed 1 month ago

gijsstegehuis commented 1 month ago

Describe the bug

->orderBy('RAND()'); is hardcoded here, but in Postgres RAND() it's called RANDOM() https://github.com/verbb/formie/blob/af9c9f6b0b7820df2b809895c2fb780e0d3597e9/src/base/ElementField.php#L716

Steps to reproduce

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

Form settings

Craft CMS version

Craft Pro 5.4.4

Plugin version

3.0.7

Multi-site?

No response

Additional context

No response

engram-design commented 1 month ago

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

gijsstegehuis commented 1 month ago

Awesome Josh!

engram-design commented 1 month ago

Fixed in 3.0.8