Question

Dynamic Fields issue - limitations???

Laserfiche

Updated February 3, 2022

asked on May 31, 2016 • Show version history

I have a template with dynamic fields setup and the SQL list keeps growing. It's over 5000 records and now the new information is not showing up in the drop down list. So far I have tried the following however it didn't work.

Went into the admin console and selected the everyone user and added the following attributes.

You can now use the [Settings]CacheFieldValues and [Settings]MaxDropDownLength trustee attributes to control drop-down list behavior for list fields and dynamic fields. Set [Settings]CacheFieldValues to Yes to turn on caching for list fields and dynamic fields to speed up list re-loading. Enabling this attribute will also configure the Client to only retrieve list fields and dynamic fields once per client instance. Set [Settings]MaxDropDownLength to the maximum number of items to display in a drop-down list field or dynamic field. List fields longer than the limit will no longer automatically display all available items in the list until you enter enough characters for the auto-complete feature to retrieve a subset of list items. (98757)

Thank you for your time.

0 0

Replies

replied on May 31, 2016

Hi Jennifer,

Enabling the cache field values will load the list values for that client upon logon to Laserfiche. If you want to refresh the list you need to log out and back in again.

From my experience 5-6k is around the maximum amount of data you can load without enabling the cache at logon, again this is subject to server specification and SQL performance etc.

I'm a little confused as to what this post is actually asking?

Cheers!

1 0

replied on May 31, 2016

Sorry Chris I wasn't clear. What I am asking is why can't I see the additional rows of data I added in the SQL database when using the dynamic fields in LF that are connected to it? It was working fine until I reached over 5000 rows of data. I did follow your suggestion above and when I logged in I did see the cache mode working however I still don't see the data I added to the sql file. Does that help?

0 0

replied on May 31, 2016

Ah ok. Hmmm. I've never not seen the data not load before. Are you certain the Dynamic field/external table is pointing at the correct sql table as with the caching turned off it's a live lookup when you click the field.

0 0

replied on October 5, 2016

I have a customer that is on LF 10.1 and they are also having a problem with displaying all items in a dynamic field drop down. They have applied the attributes and that did effect how the field is loaded and displayed, but it does not give them all the items in the list.

Can I get feedback from someone at Laserfiche on the limitations of a dynamic field (including length) and what the expected behavior is for a list with about 20,000 items? If a dynamic field can not handle that many items, what is the recommended workaround/solution?

0 0

replied on October 5, 2016

20,000 items should be usable if you set MaxDropDownLength, can you elaborate on it not showing all items?

0 0

replied on October 5, 2016

I will ask the customer to elaborate more here, but can you give the limits?

0 0

replied on October 5, 2016

There is no built in limit, it just gets slower as the size increases. We have customers with it in the tens of thousands of items.

1 0

replied on January 31, 2022

Is there Any Update on this?

Any update that could sync the template data's without making the user to logout and login?

0 0

View 2 previous replies

replied on February 1, 2022

Can you elaborate on the behavior you are seeing? Are you using the desktop client or the web client? In the desktop client, the dynamic field values are not cached by default, the user should see the latest values.

0 0

replied on February 2, 2022

I'm Using the web client. The values updated to the SQL Table are not reflecting on the dynamic fields of template. The user is forced to logout and login back again to see the latest field values. In some cases, the users are forced to restore/reset on the management setting to get the latest field values. Any options available to bypass without asking the user to logout and login?

0 0

replied on February 2, 2022

I tried this on the version 11 web client and I see the updated dynamic field values immediately. I assume you didn't set the [Settings]CacheFieldValues attribute. I am editing values in the metadata pane:

When editing the values, the dev tools network tab shows a request called "GetUpdatedFieldFormVals2" which retrieves the latest values:

Do you see this request being made after the values in SQL have been updated? does it contain the new values?

0 0

replied on February 3, 2022

We are using Laserfiche 10.4. And yes, we have set the Attribute CacheFieldValues to Yes to Everyone Group.

0 0

replied on February 3, 2022

Remove that attribute, it tells the web client to retrieve the values only once in order to speed up lookups.

0 0

You are not allowed to follow up in this post.

Question

Question

Dynamic Fields issue - limitations???

Replies

Sign in to reply to this post.