Forums

Hi,

I had a question on the usage of CCv5.

Here is my use case:
1- I have a mySQL table "my_table_1" in which one of the column is a text. I call this column "my_text_1" column. With CCv5, I load this table using "Model_ID_1".
2- I had another table in which one of the column is also a text --> Let's say "my_table_2", "my_text_2" and "Model_ID_2".

For each record of "my_table_2", I retrieve the list of records from "my_table_1" where "my_text_2" is found in "my_test_1" by using Fulltext search command like this, in php custom code:

SELECT * FROM my_table_1 WHERE MATCH (my_text_1) AGAINST (my_text_2);
--> I will get a list of records. I would like to use CCv5 to list those records in the front list.


My question: Where can I put the php code in CCv5?

[list]1-In Front List tab > Actions > View > Code?[/list]
[list]2-In Models tab of "Model_ID_1" > Conditions [The where conditions in array format: return array("field_name" => "XYZ"); to retrieve the list of ID which match "my_text_2"][/list]
[list]3-Or there is another way more efficient with CCv5 instead of using "SELECT * FROM my_table_1 WHERE MATCH (my_text_1) AGAINST (my_text_2);". I suppose that this process will read twice the databse.[/list]


Thanks for your help.
Bertrand