We’ve developed some resources to help you work effectively from home during COVID-19 Click to learn more

Lookup extra fields


I have an extra table "InstalledBase" which has a company relation called "company", and an extra table relation "model". Then there is an extra table relation "InstalledBase" on the ticket.
If I edit an existing ticket or create a new ticket and want to lookup existing InstalledBase records by filtering "company" or "model", then I never get any result:

Filter companies

Both "model" and "company" of InstalledBase have search criteria = begins with:

Search criteria of company

So, I should be able to find InstalledBase by company, but I do not, even if I enter %% to fetch InstalledBase of all companies. The only filter that works is "name", a text field.
Am I missing something? Is this a bug?
CRM Online, login: service@chdemo.ch / superoffice-2018


RE: Lookup extra fields

I agree, there is something fishy here. I set it up in my own SOD database, and it behaves the same there.

You'll find rows in your extratable if you type in the entire companyname, 'SuperOffice Ag'. So it still uses the "Equals" operator, not the "BeginsWith" that you have set on the Company-relation extrafield.

Av: Frode Lillerud 17. apr 2018

RE: Lookup extra fields


You are correct. This is a bug. I see that "contains" works, but not "beginsWith". So, I suggest changing to "contains" as a workaround now. I will fix the bug for the next release.


Av: Sverre Hjelm 18. apr 2018

RE: Lookup extra fields

For the record, issue number 58345, scheduled to be released in 8.3R01.


Av: Sverre Hjelm 23. apr 2018