NXT Lists - who are they leaving out? And WHY?

Veronica Williams

I created a new list in NXT - based on a Query in the database (which I trust.) That query has 23,566 constituents. I do not filter the NXT list at all - and not intentionally - and it comes up with only 16,325 constituents. Why doesn't the NXT list acknowledge and include the other 7,241 constituents I know exist???

Katherine Mannion

Can you tell us what kind of query it is? And what criteria you have in it? Maybe some more details will help us help you figure out why the discrepancy!

Veronica Williams

The query is a Constituent Query and the only criteria is Key Indicator is I or O. So it's literally everybody in the database. I don't understand why an NXT list never reflects every single constituent. That's my ultimate goal . . . an NXT list of EVERY constituent.

JoAnn Strommen

Are you outputting any fields in the db query? Is there possibly a difference in the query options?


Per Knowledge base article 96957 Results are incorrect when using an Action, Constituent, Gift, or Opportunity list in NXT web view

With Raiser's Edge NXT you can easily and quickly create lists for actions, constituents, gifts, or opportunities. Users have the ability to filter down the records in the list to show only records that have similar criteria. There may be times when a user notices the results are not what they expected.

Answer:

If you notice that your list is not appearing correctly, please review what each list includes or excludes.

Constituent Lists

• 
  
  Includes Individuals and Organizations
  
  
• 
  
  Excludes inactive, deceased constituents by default (To include inactive and deceased records, mark the include box under filters)
  
  

Includes soft credit gifts in Giving Summary.

**NXT Lists are still a work in progress and will continue to add new enhancements over time**

Not sure when it will be an accurate option. ?

Kendall Uckele

Hi Veronica,


I recently came upon this issue also and discussed it with BB.


They told me that NXT automatically excludes Constituents marked as Inactive for lists in NXT and there is no way to change that.


This could very well be your issue also.

Brian Davies

You can compare results if you export to excel. It is a little tricky since you can't export Import ID as an output in a list. You can however export the System Record ID in both query and lists. In query it is under Constituent Information. In lists it is typically column B when you export. The system record ID sometimes matches the Constituent ID, but not always. From there you can put the results into their own worksheet in excel and use a VLOOKUP to find which records are in the query output but not in the List output. From there you can spot check to see who is missing and what they have in common. My money is on inactive records.

Veronica Williams

Kendall - this is very helpful. If NXT can't give me an accurate list of who my constituents are, I see that as one more reason to not even use it. I trust what I can control - and that is the database. Sadly, it's not NXT, and NXT offers very little in accurate info for anyone who needs to trust data. Thanks for your answer.


It probably also explains the discrepancy between what RE Admin says we have for the number of constituent records, and what NXT says we have. Now, if BB would only bill us for the lesser # in NXT! ?

Veronica Williams

I don't have the time to compare - I just need the most accurate list - and that's not NXT it seems, Thanks for taking the time to write an answer, Brian.

Veronica Williams

JoAnn - interesting . . . and kind of sad when BB pushes NXT so hard at customers. I can easily - and have for more than 20 years - create accurate lists within the database.