Question

Sort order of dynamic fields

Updated March 10, 2014

asked on March 10, 2014

Hi,

We are using dynamic field to populate template fields and have them configured to sort in ascending order. One of the fields contains values such as:

"1 Property Sale"

"11 Lease Agreement"

"2 Valuation"

In the example above then "11 Lease Agreement" will appear before "2 Valuation". We pull from a third party system so adding leading zeros isn't an easy option and would cause inconsistency.

I can understand on a technical level why the order would appear in this way but we would ideally like it to mimic the way Windows orders folders and documents for example. I'm assuming this isn't possible (there is no "unsorted" option, only ascending and descending) but said I'd mention it in case it could be changed or considered as a future option.

Thanks,

Nigel.

0 0

Replies

replied on March 10, 2014

I've found that basing dynamic fields of production data has all kinds of weird consequences like this. We've taken to building warehouse tables that we update periodically. Then we can run scripts to format the data however we want and point Laserfiche to those.

0 0

replied on March 10, 2014

Have you considered using a SQL View that would display the data in any order or format you desire while maintaining the integrity of the source data? Setting up the query or stored procedure for a View might take some work, but it should provide you with great flexibility in sorting or transforming the data in real-time.

0 0

You are not allowed to follow up in this post.

Question

Question

Sort order of dynamic fields

Replies

Sign in to reply to this post.