ransack icon indicating copy to clipboard operation
ransack copied to clipboard

Date fields don't seem to work

Open MtnBiker opened this issue 2 years ago • 3 comments

Rails 6 Postgres date field :given_name_or_last_name_or_place_of_birth_or_**date_of_birth**_cont fails.

PG::UndefinedFunction: ERROR: operator does not exist: date ~~* unknown LINE 1: ...rth" ILIKE '%milna%') OR "people"."date_of_death" ILIKE NULL... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.

Works without date_of_birth.

Integration of search and sort is great.

MtnBiker avatar Oct 01 '21 20:10 MtnBiker

@MtnBiker can you please add a PR with a failing test?

scarroll32 avatar Mar 28 '22 07:03 scarroll32

@MtnBiker can you please add a PR with a failing test?

Any update on this @MtnBiker ?

scarroll32 avatar Jun 11 '22 08:06 scarroll32

Is date_of_birth a date column? If yes - how do you expect _cont to work with date column?

stereobooster avatar Nov 12 '22 10:11 stereobooster