Autocomplete: what about more UI types?

[joebordes]

Let's tackle these:

('116', '357', '51',  '57', '66', '73', '75', '76', '77', '78', '80', '81')

Code:

SELECT *
from vtiger_field
where uitype in ('116', '357', '51',  '57', '66', '73', '75', '76', '77', '78', '80', '81')
order by uitype

if we order them by use:

Code:

SELECT uitype, count(*)
from vtiger_field
where uitype in ('116', '357', '51',  '57', '66', '73', '75', '76', '77', '78', '80', '81')
group by uitype
order by 2

it seems that 57 would have the most impact

77 and 116 are interesting....

take your pick and start asking :-)