Guriddo » Topic: SetAutoComplete only 10 rows

SetAutoComplete only 10 rows

Guriddo
SetAutoComplete only 10 rows

This topic has 6 replies, 2 voices, and was last updated 10 years, 1 month ago by guriddo.support.

Creator

Topic

February 2, 2016 at 9:53 am #124767

ariadrianto

Participant

Hi,

I just realized that setAutoComplete has a limitation for only 10 rows…


$grid-&gt;setAutocomplete(&quot;TRUCKING&quot;,&quot;#TRUCKINGID&quot;,&quot;select
cc.nama || &#039; | &#039; || ss.dari || &#039; | &#039; || ss.tujuan || &#039; | &#039; || ss.tipe || &#039; | &#039; || cast (ss.tarif as integer) ,
cc.nama || &#039; | &#039; || ss.dari || &#039; | &#039; || ss.tujuan || &#039; | &#039; || ss.tipe || &#039; | &#039; || cast (ss.tarif as integer) ,
ss.tarifsupid
from customer cc
inner join tarif_supplier ss on cc.customerid = ss.customerid
where cc.tipe = &#039;TRUCKING&#039; and ss.status = &#039;Aktif&#039;
and ( cc.nama LIKE upper( ? ) or ss.tujuan LIKE upper( ? ))
ORDER BY cc.nama &quot;,null, true, true);

$grid->setAutocomplete("TRUCKING","#TRUCKINGID","select

cc.nama || ' | ' || ss.dari || ' | ' || ss.tujuan || ' | ' || ss.tipe || ' | ' || cast (ss.tarif as integer) ,

ss.tarifsupid

from customer cc

inner join tarif_supplier ss on cc.customerid = ss.customerid

where cc.tipe = 'TRUCKING' and ss.status = 'Aktif'

and ( cc.nama LIKE upper( ? ) or ss.tujuan LIKE upper( ? ))

ORDER BY cc.nama ",null, true, true);

How can we add more rows ?

Rgds,

Creator

Topic

Viewing 6 replies - 1 through 6 (of 6 total)

Author

Replies

February 2, 2016 at 11:34 am #124771

guriddo.support

Participant

Hello,

The options is named itemLength . Try this


$grid-&gt;setAutocomplete(&quot;TRUCKING&quot;,&quot;#TRUCKINGID&quot;,&quot;select
cc.nama || &#039; | &#039; || ss.dari || &#039; | &#039; || ss.tujuan || &#039; | &#039; || ss.tipe || &#039; | &#039; || cast (ss.tarif as integer) ,
cc.nama || &#039; | &#039; || ss.dari || &#039; | &#039; || ss.tujuan || &#039; | &#039; || ss.tipe || &#039; | &#039; || cast (ss.tarif as integer) ,
ss.tarifsupid
from customer cc
inner join tarif_supplier ss on cc.customerid = ss.customerid
where cc.tipe = &#039;TRUCKING&#039; and ss.status = &#039;Aktif&#039;
and ( cc.nama LIKE upper( ? ) or ss.tujuan LIKE upper( ? ))
ORDER BY cc.nama &quot;, array(&quot;itemLength&quot;=&gt;20), true, true);

$grid->setAutocomplete("TRUCKING","#TRUCKINGID","select

cc.nama || ' | ' || ss.dari || ' | ' || ss.tujuan || ' | ' || ss.tipe || ' | ' || cast (ss.tarif as integer) ,

ss.tarifsupid

from customer cc

inner join tarif_supplier ss on cc.customerid = ss.customerid

where cc.tipe = 'TRUCKING' and ss.status = 'Aktif'

and ( cc.nama LIKE upper( ? ) or ss.tujuan LIKE upper( ? ))

ORDER BY cc.nama ", array("itemLength"=>20), true, true);

or what you value want.

Kind Regards,
Will

Guriddo Support Team

February 3, 2016 at 6:24 am #124774

ariadrianto

Participant

it’s not working… still 10 rows

I’ve tried to change value… but no luck..


$grid-&gt;setAutocomplete(&quot;TRUCKING&quot;,&quot;#TRUCKINGID&quot;,&quot;select
cc.nama || &#039; | &#039; || ss.dari || &#039; | &#039; || ss.tujuan || &#039; | &#039; || ss.tipe || &#039; | &#039; || cast (ss.tarif as integer) ,
cc.nama || &#039; | &#039; || ss.dari || &#039; | &#039; || ss.tujuan || &#039; | &#039; || ss.tipe || &#039; | &#039; || cast (ss.tarif as integer) ,
ss.tarifsupid
from customer cc
inner join tarif_supplier ss on cc.customerid = ss.customerid
where cc.tipe = &#039;TRUCKING&#039; and ss.status = &#039;Aktif&#039;
and ( cc.nama LIKE upper( ? ) or ss.tujuan LIKE upper( ? ))
ORDER BY cc.nama &quot;,array(&quot;itemLength&quot;=&gt;50), true, true);

$grid->setAutocomplete("TRUCKING","#TRUCKINGID","select

cc.nama || ' | ' || ss.dari || ' | ' || ss.tujuan || ' | ' || ss.tipe || ' | ' || cast (ss.tarif as integer) ,

ss.tarifsupid

from customer cc

inner join tarif_supplier ss on cc.customerid = ss.customerid

where cc.tipe = 'TRUCKING' and ss.status = 'Aktif'

and ( cc.nama LIKE upper( ? ) or ss.tujuan LIKE upper( ? ))

ORDER BY cc.nama ",array("itemLength"=>50), true, true);

February 3, 2016 at 10:43 am #124776

guriddo.support

Participant

Hello,

Try to set itemsLength = 2 or 5 in order to see if this is working.

By the way which database driver is used?

Kind Regards,

Will

Guriddo Support Team

February 3, 2016 at 11:06 am #124778

guriddo.support

Participant

Hello,

We have found the problem and have fixed it. Sorry for the first post.

If the bug is showstopper we will send you the fixed code.

We will try to publish a new PHP version next week.

Thank you.

Kind Regards,

Will

Guriddo Support Team

February 26, 2016 at 4:34 am #124896

ariadrianto

Participant

have you fixed this problem ?

Thanks

Ari Adrianto

February 26, 2016 at 10:36 am #124900

guriddo.support

Participant

Hello,

As we write the problem is fixed and it will be avilable next week when we publish ne release.

SetAutoComplete only 10 rows

Search Forum

Recent Replies

Forum Statistics

UserOnline