Reference List Display Problem

plallema · ‎12-30-2013

I was on vacation last week and upon my return i find that all fields referencing the User table (sys_user) when clicking on the lookup icon, gives me a pop up list with no records. I've been searching all over the place as to what can be the problem and to no avail. The problem doesn't exist on my development instance. Now the help desk is stuck not being able to assign other user to a ticket in incident and problem and change is affected as 'assign to' field references the User table.

CapaJC · ‎01-02-2014

You might try the following script that might fix the dictionary record, bypassing the Business Rule that's preventing you from changing it.



doit();
function doit() {
  var gr = new GlideRecord('sys_dictionary');
  gr.addQuery("name", "sys_user");
  gr.addQuery("element", "first_name");
  gr.query();
  if (gr.next()) {
    gr.setWorkflow(false);
    gr.autoSysFields(false);
    gr.internal_type = "string"; 
    gr.reference = "";
    gr.update();
  }
}

View solution in original post

plallema · ‎01-02-2014

Thanks for the script it worked great!!!!