Clarity

Hello all,

is there a way to delete the association in any way?  As it is Enter Once I cannot delete it AND as this lookup is used basically everywhere in the system it cannot be replaced and/or deteted   The only probable solution I can imagine would be a SQL  DELETE statement?!

any suggestions anyone?

thanks!

Change the attribute definition so it is not 'enter-once', change your value, change the attribute definition back again to enter-once?

unfortunately I cannot since this is a lookup definition. Therefore this is not an attribute we can modify

ok I was suggested the following UPDATE statement and it seems to work...

update cmn_list_of_values

set object_code = ''

where lookup_source_code = 'LOOKUP_SOURCE_DYNAMIC'

AND lookup_type_code = 'BROWSE_PROJMGR'

obviously that would be unsupported I assume    any other alternative?  I am working on a Test environment therefore I hope it won't be too harmful...

Ok so I misunderstood what you were doing ; you were trying to change a system lookup - hmmm.,

For what its worth, in my systems that 'Object' field is empty against that system-lookup - any idea why yours had a value in it? What about XOG-ing the lookup into the system (with the association removed); might that have fixed it?

I have tried to XOG out, remove the objectCode (and even add the complete="true" just to try) and XOG it back in but no chance with that no updates to be seen...

I realized by reading your reply that my question was probably not clear enough   to answer your question I myself updated this value in an attempt to solve my problem from the other thread (Action item assignees: how to select manager as an assignee in an idea process?)    which is still not solved by the way updating this field made the Manager appear in the Action item assignees under Resource Fields and I thought it could be a workaround... but it did not work I am really desperate... as this functionality does not exist I will probably have to create a GEL script to update custom fields that appear in the Resource Fields to contain the Manager value and send action item to them...

many thanks Dave in any case much appreciated!