You are viewing limited content. For full access, please sign in.

Question

Question

Truncated Data field in Web Access

asked on February 24, 2016

Hi

We have configured a dynamic field (querying a sql server table) and the users are getting an error of truncated data like this:

 

the table has 12000 rows. Also if they type a number on the field, they have to do it very quick, otherwise another row is selected. For example trying to select "892000246" if they type "89 and two seconds after the number 2, the order changes and the rows starting with 2 are returned.

0 0

Replies

replied on February 24, 2016

One solution i could think of is making it a text field instead of drop down, so that not all values are displayed and when user type something, it starts to automatically populate. This may solve both of your problems.  

0 0
replied on March 30, 2016

Hi, all the configured fields are text type. They change automatically to drop down when i set them to dynamic. Can this be avoided?

0 0
replied on February 25, 2016

This is working as designed. Web Access is designed to display no more than the first 10000 entries in a dynamic field dropdown, to avoid potential performance concerns of loading large amounts of data (which had occurred in the past when there were tens of thousands of entries at play). So the message is not an error, just a message to the user that there are other possible values aside from those listed. You should be able to set those values, however.

With respect to the description of the selected row changing when pausing for too long in typing in a value, that is expected behavior for an HTML drop-down field. What Junaid described would certainly work except that if this is a dynamic field, even text fields are converted to HTML drop-down fields. Whether there is a way to enforce an HTML text field or if not, whether it would be supported, I personally cannot comment on, but someone else might.

Hope this is helpful.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.