Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Autocomplete: what about more UI types?
#10
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 :-)
Joe
TSolucio
Reply


Messages In This Thread
RE: Autocomplete: what about more UI types? - joebordes - 07-27-2018, 01:24 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)