CiviCRM Community Forums (archive)

When I create a custom field, at the bottom is one option: View Only? and the description bellow it - Is this field set by PHP code (via a custom hook)...

So the question is - how to control it? I want to customize Advanced Search panel and added select box for Activities, so that I can search contacts, who are acting in activities, where custom field contains something I select.

For that kind of custom field there is no records in table civicrm_option_value. I simply add arrays with names and values for HTML_QuickForm_Select Object, so I see select box filled with values I needed. I checked whole $form->_elements and my injections standed in right place for form.

But I think it is not right way to be friendly with CiviCRM.

Another question - after submitting advanced search form I see the yellow frame with query... No matches found for: ... and there is my custom field too. But, how the system can find right records, if for this custom field there is no records in civicrm_option_value table??

Yes, it is buildForm where I'm moving things.

I don't understand your phrase - You should check the query from your query log. Where it is? Did you mean MySQL log?

Another question - can I insert or modify SQL query (or somehow add criterias and tables for search) after search form submitted and query formed, but before it is executed? I want to add table with LEFT JOIN and add some criteria after WHERE.

I have table with foreign key to activities - when I create new activity, from select box I select one of items. The ID of it and the ID of new activity are stored in my table. So I need to use Advanced Search to find activities with specified item in the same select box.

If I defined custom field as View Only (to set options with PHP as I told earlier). In Activities pane of Advanced Search then appears this custom field with my options. It's okay, but this field is not available in "New Activity" form. Therefore I deleted my custom field and define select box element from buldForm hook ($form->add...) and store values in additional table.

If you can give an example how to add options to selectbox (custom fields) in both places - Advanced Search and New Activity, maybe it will be simplier to search and then I don't want to modify SQL query.

Okay. I tried again with custom fields and customFieldOptions hook and all is working well for Activities. New Activity form is okay, Advanced Search is okay. And when I search contacts, it works good. Thank you! I simply don't saw this hook in documentation

But now I want the same thing in Events. I created new custom field for Events. When I create new Event, this field is there and I can select option. But it doesn't appear in Events pane of Advanced Search.

In CRM\Event\Form\Search\advancedsearchpane.tpl there is no includes to show custom fields. And no includes in CRM\Even\Search\common.tpl.

I tried to add something (advancedsearchpane.tpl):
{if $validCiviEvent}
    <div id="participantForm" class="form-item">
    <table class="form-layout">
        {include file="CRM/Event/Form/Search/Common.tpl"}
        <tr>
           <td>
               {include file="CRM/Custom/Page/CustomDataView.tpl"}
           </td>
        </tr>
    </table>
    </div>
{/if}...but it doesn't work. This include I've get from CRM\Activity\Form\activity.tpl.
It seems that custom data are not generated at this step, when building Event search form. How to do that?

Adding {include file="CRM/Custom/Form/CustomData.tpl"} at the top of template doesn't help.

Very sad! It's time to start support
I will check and try some ideas.

How about Reports? It seems that in reports we cannot add criteria with custom fields. Am I right?