The mysterious CRM Lookup (II)

4. Now, how can we set/filter the lookup content? Because CRM3 and CRM4 are so different in lookup, so the solution is different. Let?s see a common example: In the Account record, only show the account owned contacts in the Primary Contact (primarycontactid) lookup.

a. CRM 3.0

/* CRM 3.0: only show account owned contacts in the primarycontactid lookup : Form.onLoad() */
if (crmForm.FormType == 2 && crmForm.ObjectId != null)
{
    crmForm.all.primarycontactid.lookupbrowse = 1;
    crmForm.all.primarycontactid.additionalparams = "fetchXml="
    + "<fetch mapping='logical'><entity name='contact'><all-attributes /><filter>"
    + "<condition attribute='accountid' operator='eq' value='" + crmForm.ObjectId     + "' />"
    + "</filter></entity></fetch>";
}

b. CRM 4.0

As far as I know, there are two unsupported ways to do that. Because we don't need a complicated fetchxml in this case, we so could use the first approach:

1. Customize Contact entity, open Contacts Lookup View, click 'Add Find Column', add the Parent Customer (parentcustomerid), save and publish it.
2. Customize Account entity, put the following code into Form.onLoad() :

/* CRM 4.0: only show account owned contacts in the primarycontactid lookup : Form.onLoad() */
if (crmForm.FormType == 2 && crmForm.ObjectId != null)
{
    var name = crmForm.all.name.DataValue;
    crmForm.all.primarycontactid.additionalparams =  'search=' + name;
}

It's a nice approach which used the 'search' feature of the CRM lookup. When this parameter is specified it defaults the search string in the lookup dialog and applies the search when the dialog is opened.


It's great, now let's change the requirement:
How about: Only show the Parent Account (parentaccountid) owned contacts in the Primary Contact (primarycontactid) lookup.

We still need to repeat step (1), and then in the step (2):

/* CRM 4.0: only show parent account owned contacts in the primarycontactid lookup: Form.onLoad() */
FilterLookup = function(source, target)
{
    if (IsNull(source)  IsNull(target)) { return; }
    var name = IsNull(source.DataValue) ? '' : source.DataValue[0].name;
    target.additionalparams = 'search=' + name;
}

Also, we need to put the following code into parentaccountid.onChange():

/* CRM 4.0: only show parent account owned contacts in the primarycontactid lookup : parentaccountid.onChange() */
FilterLookup(crmForm.all.parentaccountid, crmForm.all.primarycontactid);

It's great too, now how about we add another requirement on the above example:
The Primary Contact (primarycontactid) should be automatically selected when this contact is the primary contact of the selected Parent Account (parentaccountid).

Although we could do it through AJAX, we can also do it through CRM 4.0 lookup field automatic resolutions technique. Thanks for Adi Katz, let's start from begin:

(1) Turn off the Parent Account (parentaccountid) "automatic resolutions in field" feature by double click the field on the Form.
(2) Put the following codes in Account.onLoad():

function OnAfterAccountSelect()
{
    var contactLookup  = crmForm.all.primarycontactid;
    if( contactLookup.DataValue != null ) {return;}
  
    contactLookup.AutoResolve = 1;
    var accountLookup = crmForm.all.parentaccountid;
    primaryContact = accountLookup.items[0].keyValues.primarycontactid;

    contactLookup.SetFocus();
    contactDiv = document.all.primarycontactid_d.getElementsByTagName("DIV")[0];
    contactDiv.innerText = primaryContact.value;
    contactLookup.Lookup( true , true , primaryContact.value , true );
}

function OnCrmPageLoad()
{
    crmForm.all.parentaccountid.attachEvent( "onafterselect" , OnAfterAccountSelect );
}

OnCrmPageLoad();

The second approach which can deal with some complicated conditions will be introduced in the next post. :)

microsoft crm support |centric crm |direct marketing |crm customer support |open source erp crm |