I’m trying to add the Postal Code for the customer (General tab) to the Global Search. I thought that I could start with using MergeMethod.Replace but use the original definition from Customer.cs and change the heading (“zig zag”).
namespace PX.Objects.AR
{
public class CustomerExt : PXCacheExtension<PX.Objects.AR.Customer>
{
#region NoteID
[PXMergeAttributes(Method = MergeMethod.Replace)]
[PXSearchable(SM.SearchCategory.AP | SM.SearchCategory.PO | SM.SearchCategory.AR | SM.SearchCategory.SO | SM.SearchCategory.CR, "Zig zag", new Type[] { typeof(Customer.acctName) },
new Type[] { typeof(Customer.acctName), typeof(Customer.acctCD), typeof(Customer.acctName), typeof(Customer.acctCD), typeof(Customer.defContactID), typeof(Contact.displayName), typeof(Contact.eMail),
typeof(Contact.phone1), typeof(Contact.phone2), typeof(Contact.phone3), typeof(Contact.webSite)},
NumberFields = new Type[] { typeof(Customer.acctCD) },
Line1Format = "{0}{2}{3}{4}", Line1Fields = new Type[] { typeof(Customer.acctCD), typeof(Customer.defContactID), typeof(Contact.displayName), typeof(Contact.phone1), typeof(Contact.eMail) },
Line2Format = "{1}{2}{3}", Line2Fields = new Type[] { typeof(Customer.defAddressID), typeof(Address.displayName), typeof(Address.city), typeof(Address.state)},
SelectForFastIndexing = typeof(Select2<Customer, InnerJoin<Contact, On<Contact.contactID, Equal<Customer.defContactID>>>>)
)]
public Guid? NoteID { get; set; }
#endregion
}
}When running the text-rebuild option I get a SQL error. The profiler showed that, indeed, some bad SQL was created.
Does anyone have any tips on how to make changes to the Customer global search settings?
