CiviCRM Community Forums (archive)

How to add custom fields to Sql query. I am creating extension dont want to change core code.

I have created a extension that adds a textfield  to Activity search form. I want to do Full text search on this textfield with matching records from activity database tables
I am not sure how to pass this field as sql query. I have edited existing activity search form and i want its result to be combined along with full text  search result of  this  new textfield.

Yes, that's quite easy:

select first_name,
       last_name,
       'test' as default_value, --<< a "virtual" column containing a character value
       42 as the_answer         --<< another column containing a numeric value
from table1
  join table2 on table1.id = table2.customer_id;
You should also stop using those outdated implicit joins in the WHERE clause. Use an explicit JOIN operator instead. It makes the queries more robust against accidentally forgotten join conditions.

Java training in chennai | Android training in chennai | Oracle dba Training in Chennai | Python Training in chennai