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

Allow flexibility in assignment of properties to table columns in VCS

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.8
    • Component/s: Core VCS
    • Backlog priority:
      400
    • Impact type:
      Configuration Change
    • Upgrade notes:
      Hide

      In the default-repository-config.xml it's now possible to specify where each field goes, using <field> elements inside the <schema> element.

      <field table="tablename" column="columname">prefixed:fieldname</field>

      The table or column can be omitted if they don't need to be changed. If specified, they must be in the same case as in the schema defining the existing table (usually lowercase). The field must be prefixed if and only if the schema is defined with a prefix.

      For instance Nuxeo has an implicit configuration equivalent to the following (which you must not repeat):

      <schema>
      <field table="hierarchy" column="majorversion">major_version</field>
      <field table="hierarchy" column="minorversion">minor_version</field>
      </schema>

      If you want to move the dublincore title to the "hierarchy" table, you can do:

      <schema>
      <field table="hierarchy">dc:title</field>
      </schema>

      Show
      In the default-repository-config.xml it's now possible to specify where each field goes, using <field> elements inside the <schema> element. <field table="tablename" column="columname">prefixed:fieldname</field> The table or column can be omitted if they don't need to be changed. If specified, they must be in the same case as in the schema defining the existing table (usually lowercase). The field must be prefixed if and only if the schema is defined with a prefix. For instance Nuxeo has an implicit configuration equivalent to the following (which you must not repeat): <schema> <field table="hierarchy" column="majorversion">major_version</field> <field table="hierarchy" column="minorversion">minor_version</field> </schema> If you want to move the dublincore title to the "hierarchy" table, you can do: <schema> <field table="hierarchy">dc:title</field> </schema>

      Description

      It would be interesting to be able to assign some properties to another table/column than the one automatically assigned by VCS.

      This would be useful to denormalize the schemas, in order for instance to group together several prefetched properties, or to put those most used in the main hierarchy table. In particular, this would be useful for at least the lifecycle state.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 1 day
                1d
                Remaining:
                Remaining Estimate - 1 day
                1d
                Logged:
                Time Spent - Not Specified
                Not Specified