• State Verified Answer
  • Locked Locked
  • Replies 3 replies
  • Subscribers 95 subscribers
  • Views 1802 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Department FullPath field is too small.

timo.parkka
over 6 years ago

Customer has so deep organisation that department FullPath's 255 characters are not enough. And as FullPath is cut to 255 characters there will duplicates...
What is the best solution for this? Cannot alter table as Department is not table as it's view.

Parents
  • 0 over 6 years ago

    Which version of OneIM are you using?

  • +1 over 6 years ago in reply to timo.parkka

    Option 1:

    Update to version 8.0.1 as we have increased the length of the fullpath columns to 400 characters. You may also contact support and ask if it feasible to change the length to 400 characters in your current 8.0 and keep that change when you are going to migrate to a newer service pack in the future.

    Option 2:

    The fullpath is meant as a unique identifier of a department in the complete hierarchy. You may have a shorter identifier for your departments than the departmentname that is currently used to form the fullpath. If so, you could customize the value template on Department.Fullpath to use that shorter identifier for the construction of the fullpath. If you do so, you need to re-calculate the templates for this column for all existing departments.

Reply
  • +1 over 6 years ago in reply to timo.parkka

    Option 1:

    Update to version 8.0.1 as we have increased the length of the fullpath columns to 400 characters. You may also contact support and ask if it feasible to change the length to 400 characters in your current 8.0 and keep that change when you are going to migrate to a newer service pack in the future.

    Option 2:

    The fullpath is meant as a unique identifier of a department in the complete hierarchy. You may have a shorter identifier for your departments than the departmentname that is currently used to form the fullpath. If so, you could customize the value template on Department.Fullpath to use that shorter identifier for the construction of the fullpath. If you do so, you need to re-calculate the templates for this column for all existing departments.

Children
No Data