5 Replies Latest reply on Feb 21, 2014 12:20 PM by Ramesh Reddy

    Adding autoincrement/hash column to view

    luca gioppo Novice

      Is it possible to add an autoincrement column to a view table?

      Or a column made from a hash of an existing column to have a numerial index instead of a string.

       

      The problem is having sometime CSV files that do not have ID thus PK but could have unique value columns that could be used as PK.

       

      Using that column as PK can be sometimes unconvinient for example when using odata and using a string as PK/ID

       

      Having either an autoincrement (that could have the problem of not being the same over time) or a hash of a column (better since it will be always the same)  could expose a better data to outside.

       

      Thanks

       

      Luca