Altru Ideas

Is there a way to pull a query that shows all of the list items in each code table item? I've been playing around with the Code Table source query but am not finding anything that shows the actual items. Since so many things came over in the conversion from Raiser's Edge we want to do a data cleanup to remove duplicate and unnecessary information currently showing up in the list items. If we can view everything as once instead of going into each individual item to "Show lookup" it will help the process a lot.