• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
TSB Alfresco Cobrand White tagline

Technology Services Group

  • Home
  • Products
    • Alfresco Enterprise Viewer
    • OpenContent Search
    • OpenContent Case
    • OpenContent Forms
    • OpenMigrate
    • OpenContent Web Services
    • OpenCapture
    • OpenOverlay
  • Solutions
    • Alfresco Content Accelerator for Claims Management
      • Claims Demo Series
    • Alfresco Content Accelerator for Policy & Procedure Management
      • Compliance Demo Series
    • OpenContent Accounts Payable
    • OpenContent Contract Management
    • OpenContent Batch Records
    • OpenContent Government
    • OpenContent Corporate Forms
    • OpenContent Construction Management
    • OpenContent Digital Archive
    • OpenContent Human Resources
    • OpenContent Patient Records
  • Platforms
    • Alfresco Consulting
      • Alfresco Case Study – Canadian Museum of Human Rights
      • Alfresco Case Study – New York Philharmonic
      • Alfresco Case Study – New York Property Insurance Underwriting Association
      • Alfresco Case Study – American Society for Clinical Pathology
      • Alfresco Case Study – American Association of Insurance Services
      • Alfresco Case Study – United Cerebral Palsy
    • HBase
    • DynamoDB
    • OpenText & Documentum Consulting
      • Upgrades – A Well Documented Approach
      • Life Science Solutions
        • Life Sciences Project Sampling
    • Veeva Consulting
    • Ephesoft
    • Workshare
  • Case Studies
    • White Papers
    • 11 Billion Document Migration
    • Learning Zone
    • Digital Asset Collection – Canadian Museum of Human Rights
    • Digital Archive and Retrieval – ASCP
    • Digital Archives – New York Philharmonic
    • Insurance Claim Processing – New York Property Insurance
    • Policy Forms Management with Machine Learning – AAIS
    • Liferay and Alfresco Portal – United Cerebral Palsy of Greater Chicago
  • About
    • Contact Us
  • Blog

Alfresco Data List-Driven Value Assistance

You are here: Home / Alfresco / Alfresco Data List-Driven Value Assistance

July 10, 2013

Although content modeling in Alfresco is very flexible and configurable, one of the issues that we run into when setting up repositories for clients is the lack of the ability for business users to manage value assistance lists.  Value assistance is a term that we use to describe the lists of options that show up in dropdown and multi-select controls in the user interface on the edit properties and search screens.

This post will describe a module that we’ve developed to utilize the data list functionality available in the Alfresco Share interface to allow business users to manage value assistance lists without any coding, XML configuration, or server restarts.

Traditionally, value assistance (also known in Alfresco as list constraints) require lists of possible values to be hard coded into either the content model XML file, or the Alfresco Share configuration file.  This poses a problem for many of our clients because updating the values in the lists requires updating XML files and restarting the Alfresco server.  Our solution for user-manageable value assistance consists of the following components:

  • Data list content model extension to include a “Value Assistance” list type
  • Custom Alfresco Share dropdown and multi-select form controls to retrieve data list values using AJAX calls
  • Custom Alfresco webscript to retrieve the values in a value assistance data list and return the values as JSON

For those not familiar with data lists in Alfresco Share, here is a brief overview.  The data list module is an optional feature that can be enabled for a site in Alfresco Share by a Site Manager.  Once enabled, data lists can be created within the site.  Alfresco Share comes with various templates for data lists out-of-the-box, including contact lists, to-do lists, task lists, issues lists, etc.  These lists can be created, viewed, and deleted based on role-based security, similar to the document library.

To implement data list-driven value assistance, we’ve extended the data list content model to include a custom data list template for Value Assistance lists.  Once the model extension has been installed, business users can create and manage value assistance lists from the Share interface.

ImageImage

Note that our implementation includes a sort order field so that business users can control which order the values will appear in the dropdown list.  We see this used frequently when lists contain an “Other” or “Not Applicable” option that should appear at the bottom of the list, even though it’s out of alphabetical order.

The second part of our solution is a custom set of form controls that are added into Alfresco Share to allow dropdowns and multi-select controls to be added to the edit properties and search screens.  These controls look identical to the out-of-the-box dropdown and multi-select controls, except they are populated dynamically with data list values using AJAX calls.  Because the lists are populated asynchronously, we’ve seen good performance with lists that contain over a thousand values.

Image

The final component of our data list-driven value assistance module is a simple webscript that retrieves all values from the data list and feeds the values as JSON into the custom form controls described above.  The form control sends the webscript the name of the value assistance data list as a parameter and then the webscript finds the data list in the repository and returns all items in the list ordered accordingly.  Because of the generic inputs and outputs of this webscript, it can be used to populate controls in user interfaces other than Alfresco Share as well.

Image

Using data lists to allow business users to manage dropdown list values in Alfresco has resolved a major pain point for many of our clients.  Feel free to add any comments below.

Filed Under: Alfresco, R&D, Share, Tech Tip, TSG Labs

Reader Interactions

Comments

  1. Vignesh says

    July 14, 2013 at 12:02 pm

    Excellent add-on. How can we test it. Do you provide any trials for it ?

    Reply
  2. Michael Ford says

    January 27, 2014 at 1:35 pm

    Interested in this, I may have usage for it.
    where can I find the amp modules and what versions will it run under ?

    Reply
  3. kevin nason says

    February 25, 2014 at 3:50 pm

    looks good where can we get it?

    Reply
  4. tomas says

    April 1, 2014 at 4:21 pm

    Very interesting feature. I was already thinking about the same add-on and your approach looks quite good. Where do you storing the values/data for these lists? In your own specific DB table or as cm:object’s somewhere in repository?

    Reply
  5. Isaac Rojas Garcia says

    May 13, 2014 at 1:55 am

    Very interesting. Where can i get the amp’s modules?.

    Reply
    • Douglas C. R. Paes says

      May 16, 2014 at 2:51 pm

      Hey Isaac.
      This project is hosted on github.
      You can get it here https://github.com/douglascrp/alfresco-value-assistance

      Reply
      • basketballshowtime says

        May 17, 2014 at 7:26 am

        Thanks you very much Douglas, I’ll check it out.

        Reply
  6. George says

    May 16, 2014 at 3:32 pm

    Also, our original version is here: https://github.com/parzgnat/alfresco-value-assistance

    Reply
    • douglascrp says

      May 16, 2014 at 5:49 pm

      I’ve not seen I posted my copy of the repo… the idea was to post the original version, which you George did.

      Reply

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Search

Related Posts

  • Harnessing the Power of Alfresco Data Lists for Cascading Value Assistance
  • Auto-Numbering Content in Alfresco
  • Extending Alfresco Security Beyond ACLs
  • Auto-Filing Content in Alfresco
  • Documentum Transformation Services (DTS) – Alternative Approaches with Adobe LiveCycle and OpenOffice
  • Documentum Annotations – TSG View of the different solutions
  • Documentum Open Source Software
  • Alfresco – Viewing Annotations on Versions
  • Documentum or Alfresco Interface – Ready for an Upgrade?
  • Alfresco Deployment – No Code vs Low Code

Recent Posts

  • Alfresco Content Accelerator and Alfresco Enterprise Viewer – Improving User Collaboration Efficiency
  • Alfresco Content Accelerator – Document Notification Distribution Lists
  • Alfresco Webinar – Productivity Anywhere: How modern claim and policy document processing can help the new work-from-home normal succeed
  • Alfresco – Viewing Annotations on Versions
  • Alfresco Content Accelerator – Collaboration Enhancements
stacks-of-paper

11 BILLION DOCUMENT
BENCHMARK
OVERVIEW

Learn how TSG was able to leverage DynamoDB, S3, ElasticSearch & AWS to successfully migrate 11 Billion documents.

Download White Paper

Footer

Search

Contact

22 West Washington St
5th Floor
Chicago, IL 60602

inquiry@tsgrp.com

312.372.7777

Copyright © 2023 · Technology Services Group, Inc. · Log in

This website uses cookies to improve your experience. Please accept this site's cookies, but you can opt-out if you wish. Privacy Policy ACCEPT | Cookie settings
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT