Anyone aware of the best practice for searching ac...
# orm-helpj
Jonas Rothmann
02/24/2022, 4:46 PMAnyone aware of the best practice for searching across say 10 fields? Feels weird to write a really long where query
a
Austin Zentz
02/24/2022, 5:41 PMI'd start with the long where query
Austin Zentz
02/24/2022, 5:42 PMAfter that, you may have success if you create and index a "search" field, that updates your keywords when a record is created/modified. then you have just that one field to search against.
Austin Zentz
02/24/2022, 5:43 PMThen you may want to look into tools like Elastic Search, which are specific to this sort of searching problem but really their own fully-featured tools