You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SELECT clients.*FROM clients
INNER JOIN roles ONroles.roleable_type='Client'ANDroles.roleable_id=clients.idINNER JOIN participants ONparticipants.expired_on IS NULLANDparticipants.id=roles.participant_idWHEREparticipants.expired_on IS NULLANDroles.expired_on IS NULLAND NOT ((participants.name_searchLIKE'%tway%'ORparticipants.name_searchLIKE'%legal%')) order by short_name;
I would appreciate it if you could take a look and let me know what I may have done incorrectly or if it's Scuttle
The text was updated successfully, but these errors were encountered:
roscom
changed the title
SQL negating a LIKE don't appear to be generating correct arel code
SQL negating a LIKE doesn't appear to be generating correct arel code
Oct 5, 2023
produces the following arel code:
The match method is omitted from
It should be
I would appreciate it if you could take a look and let me know what I may have done incorrectly or if it's Scuttle
The text was updated successfully, but these errors were encountered: