Records in NXT vs. Database View

Cheri Harwood · April 2023

Please be patient with me - I am relatively new to RE. I have a record that I can find in NXT (top part of the picture), but not in the database view (bottom). Why might that be?

4391a49f150781129abf9406271fc7b6-huge-im

Marie Stark · April 2023

@Cheri Harwood You could try searching with an asterisk in front of the name, or add a back slash to the name in the database view between The and Coca-Cola.

Joni Mraz · April 2023

@Cheri Harwood Did the record originate in the Database or NXT?

Dina Rieman · April 2023

@Cheri Harwood Hi Cheri, welcome to the world of RE. There is feature in RE where a backslash (“\\”) can be added before any part of the name so a search (in database view) will look for what is after the backslash. It could be The Coca-Cola Foundation is entered in RE with the backslash and the other is not. Webview searches worked differently than database view which is why you have different results. If you search in database view using the constituent ID for The Coca-Cola Company, you can see if this is the case.

Here is a screen shot of an example in our database. In this case if you search on “Prudential” this record would be found. Without the backslash, it would not.

cc520514bd1b70ff1147b707e354971d-huge-im

Hope this helps.

Mark Guncheon 2 · April 2023

@Cheri Harwood So I guess your search gave you Coke Zero? ?
Good ideas from all. When I have trouble finding an org especially, I use an * before and after the word or words I think may bring the correct constituent to me. With your search, I sometimes try the unique part of the name like
*ola found*
and see what I get.

Cheri Harwood · April 2023

@Joni Mraz I don't know the answer to that. Can I tell from looking at the record? I did not create it, it pre-existed me.

Cheri Harwood · April 2023

@Dina Rieman THANK YOU - I searched for the Constituent ID and was able to find it.

I did add a backslash, as you mentioned, which has helped.

But I was searching for the common part of the name “Coca-Cola”. In my mind that should have worked.

Cheri Harwood · April 2023

@Mark Guncheon Coke Zero is right!

I will keep the asterick in mind. Thanks.

Cheri Harwood · April 2023

@Marie Stark Thank you - When I found it I added the backslash. Now I can find it.

Mark Guncheon 2 · April 2023

@Cheri Harwood Fantastic. Searching can be challenging at times but it will get easier the more you use both RE and NXT. Plus this community of generous people is great for helping others.

JoAnn Strommen · April 2023

@Cheri Harwood Welcome!

I have also found that I get better search results in db view when the “Use Enhanced Search” box is not checked. Definitely shows more records in the search window. (You can change default search query to show other field if needed like 'class of.')

Veronica Renzo · April 2023

@Cheri Harwood Welcome! I know this isn't an answer you are looking for but – I use the alias box a lot. We have a lot of foundations with long names and this helps in searching and finding them.

Joni Mraz · April 2023

@Dina Rieman
I didn't know about the back slash! TY! Game changer for me LOL

Jaime Fortier · April 2023

@Dina Rieman
I am curious. Will the back slash show up in the organization name when when I print? I like that idea but am wondering if that would cause more troubles when I am doing exports and such.

Dariel Dixon 2 · April 2023

@Jaime Fortier I'm pretty sure it just appears as a space. There's really no downside to using it.

Ashley Brownfield · June 2023

@Cheri Harwood I utilzie the alias feature a LOT! Things like this happen to me all the time.
You could put an alias of “Known Name” as Coca-Cola or Coke and then it should always be able to find it.

Records in NXT vs. Database View

Comments

Categories