Hello, I need some advice. I have many records in the #__js_res_record table and I need to find all the records which have some particular field value. Now I am using
SELECT 'id, title' FROM #__js_res_record WHERE 'type_id' = $type_id AND 'fields' LIKE '%{"'.$id.'":"'.$name.'"}%'
but I am not sure if this is proper and fastest way. I believe you have some classes for similar tasks, because pre-filtered links works in that way, but I didn't find the proper method yet..
Hello, I need some advice. I have many records in the #__js_res_record table and I need to find all the records which have some particular field value. Now I am using
SELECT 'id, title' FROM #__js_res_record WHERE 'type_id' = $type_id AND 'fields' LIKE '%{"'.$id.'":"'.$name.'"}%'
but I am not sure if this is proper and fastest way. I believe you have some classes for similar tasks, because pre-filtered links works in that way, but I didn't find the proper method yet..