Notifications
Clear all
Topic starter
Does anyone have a report that lists the users (even the inactive users) and the problem custom lists they have as their default. We are getting rid of all of our problem customs lists and making them use the Reference list. But before we remove the custom lists we have to change everyones's default individually. Or try to get them to do it.
Kate
Posted : September 15, 2015 10:11 am
I have a set of ACCESS queries that extracts this data if you are interested. I can send you the table relations and SQL code if this will help. Contact me at [email protected].
Posted : September 15, 2015 1:33 pm
I'd be interested in this query, too!
Posted : September 16, 2015 8:11 am
Pretty easy to update all via SQL if you're comfortable with that. From an Oracle perspective, you're changing the prefvalue in the pref table to match the qpid:
select qp.description,ui.status,ui.loginname,ui.searchname,lo.abbrevname,ui.pvid,pf.groupid,pf.prefname,qp.qpid,pf.prefvalue
from usrinfo ui,locreg lo, pref pf,qpicks qp
where
ui.homelocation=lo.locid
and ui.pvid=pf.groupid
and pf.prefvalue=qp.qpid
and ui.status = 'A'
and pf.prefname like '%ProbCustomList%'
order by description,abbrevname,searchname
Posted : September 16, 2015 8:35 am
