I implore Blackbaud to postpone turning off the database view Tables features until summer 2024.

@Noel Freitas - Welcome to BB Community! I recommend you reach out to your Account Rep and Customer Success Manager, and share your concerns.

In the meantime, I encourage you to check out the Tables area of Web View and test it out for your processes; there is a tool in WV's area that is equivalent to the table clean-up plug-in tool available in DBV.

@Austen Brown is/was there a webinar about this and how to use the Tables area of Web View?

@JoAnn Strommen

There's a note about it sort-of on the front of RE in the Updates section.

I feel like I was looking for Address System ID for something recently, but I don't think I managed to find it either in the end.

@JoAnn Strommen I have been using Tables in WebView and it is mostly OK. I did submit a ticket because the System Record ID in “View Uses” was not matching the Constituent. Here is the response that I got from Support:

The ID number you are seeing in "View Uses" within the tables in RENXT is the "System Record ID" of the actual table entry and not the one from the constituent. Unfortunately, at this time it is not possible to change the mapping for this to display the "System Record ID" of the constituents where the table entry is assigned. Instead, this can be used more as a reference to indicate the number of records that contain this table entry.

If needing to know which constituent have the specific table entry assigned or on their record, then we would recommend to either create a query in RE database view or a List within RE NXT webview.

@Rachel Cavalier really? I did a chat support last week on this and the person said he didn't know if we could be able to still export tables/fields when we do our annual audit of tables. I pointed out the KB article still says to export all, you need to do it in db view.

@Austen Brown OK, you said “clean up” and I do see that. But I'm concerned there is no ability to print all tables and fields which many of us do annually for cleanup review. How can we export in webview? I contacted chat and the person didn't know.

@Rose Dixon - According to a comment shared by someone else on this thread, it will be possible to pull the table report in DBV > Scroll to the bottom to view the response to the blog.

@Rose Dixon this functionality will still be available in database view. When you go to Config > Tables, you will see a message in the right pane directing you to web view BUT you will still be able to go to File > Print/Preview > Code Tables Report in the database view toolbar to create printable report. We will look at adding this to web view bur for now, it will stay available in database view.

@Karen Diener Thought webview with use would be great to help with clean up. Very, very limited as several tables I've tried to query on in db view do not have the system record ID. So still unable to find the hidden uses.

@Faith Murray Oh my gosh, I love your description of Anemic, that gave me a much needed laugh this morning!

@Deb Dressely, Job Assigments do not exist as a table, per se, and so they are not pulled into the webview “Tables” list. (At least in my system, webview tables seem to be corresponding to database view tables in terms of which ones are listed.)

Oddly, job assignments in the db-view Volunteer tab actually link to specific job creations under an event record. So to manage your job assignments, you must create a corresponding event. Which is odd, because volunteers don't just help out at events…..? Anyhow see below.

Note the event name to the right of the job. Now, if I look under that event record:

Basically, I think Volunteer jobs are an unrelated part of RE from the upcoming table migration, and BB probably isn't ready to debut their webview Volunteer section fully yet.

@Deb Dressely, I've never edited the fields from the F7 search menu - interesting. I dug into the Knowledgebase for more info and this is what I found (KB 38738).

To locate the Job Position and Job Assignment Position tables:

1. Go go Config > Tables
2. Make sure Show: is set to <All.
3. The tables appear as Job Position and Job Assignment Position

NOTE: These fields are not listed when Show: is set to Volunteer as they are not true Volunteer tables. While they take on table characteristics when Lookup is marked in Config > Fields, they are not considered Volunteer tables in the backend of the database. They are user-defined tables.

Despite what the KB article says, I have no table showing on my Config, even when set to Show: All. I may check in with Support, because my curiosity has gotten the better of me.