Deleted attribute shows in Ad-Hoc query

When a user creates an attribute that is later deleted the attribute still shows in query.  If the attribute is recreated later with the same name the attribute shows twice in query.

This is caused by a feature that was added to allow attributes to be used for lists, and the resulting change in the way query view extensions are created and deleted for these types of attributes. There exists in the system a default business process that handles cleaning up deleted and changed attributes with the "Make available in lists" option enabled. However, this business process is not run by default for any product other than Research Point. The best way for you to resolve this problem and prevent it in the future is to add this business process as a step to a queue that runs as often as they expect to delete attributes.
  1. Go to Administration
  2. Click Queue under the Administration section
  3. Click Add
  4. Name the Queue Process
  5. Click Add Step
  6. Search for and select the Name "Default Query View Add Attribute Extension Business Process"
  7. Click Save
  8. Open the newly created Queue
  9. You can now start the process and run this manually the first time for initial Cleanup.
  10. You may also want to click the Job Schedule tab and create a schedule for this process to run at regular intervals



Was this article helpful?