I have created a valuelist to show all the values from a database table.
But it shows only around a 100 values in the valuelist. It used to show all the values previously.
Please help!
Servoy Developer
Version 3.1.3-build 407
Java version 1.5.0_11-b03 (Windows XP)
Since Servoy 3.1.4 there is a limit of 500 (http://forum.servoy.com/viewtopic.php?t=8069)? Are you sure it’s 100?
I am using the following code:
application.setValueListItems(valueListName, application.getValueListItems(quickSearchFldObj.localValueListName));
I am trying to set the values of one value list to another.
If I try to see the value of the following code in the debugger it returns 100.
application.getValueListItems(quickSearchFldObj.localValueListName).getMaxRowIndex()
Here is my developer version
Servoy Developer
Version 3.1.3-build 407
Java version 1.5.0_11-b03 (Windows XP)
In addition to the above issues, application.getValueListItems() returns 0 records if the valuelist uses a relation.
Please help us fix this as quickly as always you do. We urgently need to fix this for our client.
Thanks a lot!
Hi,
Please try the latest released version (3.1.4), the limit should be 500.
In addition to the above issues, application.getValueListItems() returns 0 records if the valuelist uses a relation.
Did you use the value list on a form that is based on the left table of the relation?
Rob
Hi there,
For a valuelist from table the limit of list is still 500 only?
Our client is asking me why it is not showing the ones after 500. Please let me know is there any workaround.
Thanks a lot!
Hameed
Servoy Developer
Version 3.5.6-build 519
Java version 11.0-b15 (Windows Vista)
Hi Faheem,
Having a valuelist with hundreds of values is just bad UI. If you want to use more than 500 then use a listview to pick/search one.
At the last VUG I showed an OpenSource listpicker module made (not yet released, need to document it and all) that provides an easy way for this.
Just let me know if you want to use it and I will send it.
Hi Roclasi,
Thanks for your quick feedback.
I agree it is a bad idea but I just can’t spend more time on this client since 1> the project was closed already 2> I am so busy to do it 3> if I did it then I am giving to the client for free.
So please send me the list picker plugin. It would be great it can be simple as putting a combobox in the form.
Thanks a lot for your help.
Hameed
hameed@pilot.com.hk
Hi Hameed,
I just send it. Keep in mind it’s for Servoy 5.x
faheemhameed:
So please send me the list picker plugin. It would be great it can be simple as putting a combobox in the form
It’s a module, not a plugin.
And yes it is simple. It’s just like 5-10 lines of code (setting properties).
Oh… god.
Did you know I am using the following version
Servoy Developer
Version 3.5.6-build 519
Java version 11.0-b15 (Windows Vista)
Anyway thanks for sending. Anyother workaround for combobox length settings?
Thanks,
Hameed
faheemhameed:
Anyway thanks for sending. Anyother workaround for combobox length settings?
Other than doing what I did in a non-dynamic fashion ? Nope.
change your field to a typeahead?
Hello,
That’s a good suggestion to use type ahead field and I have suggested the same to the client and they are ok with it.
One problem though with Chinese characters not showing in the type-ahead menu while it was showing properly in the combobox.
Please see the attachments.
Thanks a lot,
Hameed
faheemhameed:
One problem though with Chinese characters not showing in the type-ahead menu while it was showing properly in the combobox.
Hameed,
Can you try this with the latest Servoy 5.1?
If this is the same there please file a case in our support system with a sample attached.
Rob
Hi Rob,
I have not upgraded to version 5.1. Will it be fixed in Version 3.5.6 if I file a bug report?
I am sure the client would not want to upgrade to version 5.1 afraiding that will cause more issues for them.
Thanks,
Hameed
We strongly suggest to upgrade, later version like Servoy 5.x, have more character issues resolved, and Servoy 3.5 is almost end of life.
Ok. Is there a license cost that our client needs to pay for the upgrade to 5.x?
Thanks,
Hameed
Hi Hameed,
When your client has a subscription license (that they paid every year) then they can use any new release.