Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-22752

Fix Spreadsheet: multiple users/groups mapping works only for users and prefix them although it should not

    XMLWordPrintable

    Details

    • Release Notes Summary:
      Spreadsheet editor works on users/groups fields.
    • Backlog priority:
      600
    • Upgrade notes:
      Hide

      When using JSF UI, the use of spreadsheet to modify values of type user or group will result in the display of values prefixed with either "user:" or "group:", or warnings in edition if the widget to display the data has the property "use prefixed reference" set to "No".
      In the Studio project, it is now required to use the property "use prefixed reference" set to "Yes" in creation, view, edit screens and also in content views for the data of type "user" or "group" to enable the seamless usage of spreadsheet.
      Regarding preexisting data created with versions of the Studio project not having the widget property set to "Yes" for all data of type "user/group" and used in conjunction with spreadsheet, 4 cases arise:

      • For USER ONLY type of data, ensure the data in database is prefixed with "user:"
      • For GROUP ONLY type of data, ensure the data in database is prefixed with "group:"
      • For a MIX of users and groups, the default value in Studio for the property is "Yes": if having not changed this default in Studio, no action to take in this case
      • For a MIX of users and groups, you changed the default value of the property to "No": edit the values in database to prefix with either "user:" or "group:" depending on the type of value.
      Show
      When using JSF UI, the use of spreadsheet to modify values of type user or group will result in the display of values prefixed with either "user:" or "group:", or warnings in edition if the widget to display the data has the property "use prefixed reference" set to "No". In the Studio project, it is now required to use the property "use prefixed reference" set to "Yes" in creation, view, edit screens and also in content views for the data of type "user" or "group" to enable the seamless usage of spreadsheet. Regarding preexisting data created with versions of the Studio project not having the widget property set to "Yes" for all data of type "user/group" and used in conjunction with spreadsheet, 4 cases arise: For USER ONLY type of data, ensure the data in database is prefixed with "user:" For GROUP ONLY type of data, ensure the data in database is prefixed with "group:" For a MIX of users and groups, the default value in Studio for the property is "Yes": if having not changed this default in Studio, no action to take in this case For a MIX of users and groups, you changed the default value of the property to "No": edit the values in database to prefix with either "user:" or "group:" depending on the type of value.
    • Sprint:
      nxNS Sprint 9.3.4, nxNS Sprint 9.3.5, nxNS Sprint 9.3.6, nxNS Sprint 9.3.10, nxNS Sprint 9.10.1, nxNS Sprint 10.1.2, nxNS Sprint 10.1.3, nxNS Sprint 10.1.4, nxNS Sprint 10.2.1, nxNS Sprint 10.2.2, nxNS Sprint 10.2.3, nxNS Sprint 10.2.4, nxNS Sprint 10.3.1, nxNS Sprint 10.3.3, nxNS Sprint 10.3.4, nxNS Sprint 10.3.5, nxNS Sprint 10.10.1, nxNS Sprint 10.10.2, nxNS Sprint 10.10.3, nxNS Sprint 11.1.1, nxNS Sprint 11.1.3, nxNS Sprint 11.1.4, nxNS Sprint 11.1.5, nxNS Sprint 11.1.6, nxNS Sprint 11.1.7, nxNS Sprint 11.1.8, nxNS Sprint 11.1.11
    • Story Points:
      2

      Description

      When mapping a non-prefixed multi-valued users/groups field via:
      https://github.com/nuxeo/nuxeo-platform-spreadsheet/blob/release-7.10/src/main/js/app/ui/widgets.js#L57

        multipleUsersSuggestion: {
          renderer: UserRenderer,
          editor: 'user',
          multiple: true
      },
      

      When editing the multivalued users/groups field in Spreadsheet , then groups disappear and users are prefixed with "user:" although the field is explicitly not prefixed.

      Non-spreadsheet view is OK before editing and shows errors after edition in Spreadsheet

        Attachments

          Activity

            People

            • Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Time Spent - 1 day, 4 hours Remaining Estimate - 6 hours
                6h
                Logged:
                Time Spent - 1 day, 4 hours Remaining Estimate - 6 hours
                1d 4h