Craft CMS Stack Exchange is a question and answer site for administrators, end users, developers and designers for Craft CMS. It only takes a minute to sign up.
Sign up to join this community
Am I correct in saying you cannot search for specific text in a table field. e.g.
Table Fields Might hold the following data:
I then want to search for items that only return SKU3 not SKU33.
body::salty search will not work because i believe the field is stored as JSON.
If you're looking to see if the search term matches any row/column value in the field, then it should work: myTableFieldHandle::SKU3
If you are looking to find the exact row/column that matched, you'd have to do some custom development.
Even though a table field's data is stored as a JSON blob in the Craft content table, search index keywords are extracted from every row/column and saved as a single row in the search index table.
Yeah because the data is stored as a JSON blob, I'm not sure this is going to be possible without retrieving all the data, parsing the JSON, then doing the exact match search via PHP, and then returning the results subset.
