Maintaining user field storage

The User Field Storage Maintenance form enables you to make changes to user field storage. These changes may be necessary or useful because of modifications and improvements to the Landmark system. The changes you can make include:

  • Changing the sort order to be numeric instead of alphanumeric for numeric values in key fields. For new data areas and new installations, the default behavior is to store numeric values in a Numeric field. Previously, for user fields such values were stored in an Alpha field. Changing this sort order to be numeric will cause records with numeric key values to be sorted more appropriately.
  • Adding user field overflow indicators to inline user fields. An inline user field is one stored in a buffer in order to improve performance. The overflow indicators help the system know if it needs to query the database or if it only needs to access the buffer.
  • Processing orphan data for user fields. In some cases, user field values were not being deleted when their associated business objects were deleted. This option allows you to report on and delete these orphan records.
  • Managing user-defined fields with empty values. In the past, user-defined field records were sometimes created with empty values. This option allows you to report on and delete the records with empty values.
  1. Select Administration Console > Other > User Field Storage Maintenance.
  2. If you want to export the output report to a sub-directory of the FTP site directory, specify that directory in the Subdirectory field.
  3. If you want to name the report differently than the default name of UserFieldStorageMaintOut.txt, specify that name in the Command Output File Name field
  4. If you want to restrict the user field storage maintenance action to a single business class, select the business class (does not apply to the numeric sorting option).
  5. To change the sorting order for user fields with numeric value, select Enable or Disable for the Numeric Sorting for All User Fields field. If you have enabled numeric sorting, you would probably only want to switch it back to disabled if you were to import some user fields that were not using the numeric sort. You could then enable numeric sorting once again to fix those fields.
  6. To change the use of the overflow indicator for inline user fields, select either Set or Remove for the Overflow Indicators for Inline User Fields field.
  7. To report on the existence of orphan user field values, select Report for the Orphan Data for User Fields field. To delete orphan user field values, select Delete for the Orphan Data for User Fields field.
  8. To report on the user-defined fields with empty values, select Report for the Empty Data for User Fields field. To delete user-defined fields with empty values, select Delete for the Empty Data for User Fields field.
  9. Click Submit.