BSBI Distribution Database > message board

Validation - Confirmed cf Confirmed externally

Any queries about using the BSBI database

Validation - Confirmed cf Confirmed externally

by AndyAmphlett » Sat Feb 25, 2017 1:22 pm

Tom,

under 'Validation state', selecting 'Accepted' returns both records which are 'Confirmed' (ie confirmation took place within the DDb) and 'Confirmed externally' (eg. records came from old VPDB / Atlas 2000). I can't see an obvious way to run a query that just returns one or other of these categories, which is odd as they are listed separately when you run a query subdividing by validation state. Might be useful to be able to query one or other category and not just have them lumped together.

Andy.
AndyAmphlett
 
Posts: 307
Joined: Fri Nov 23, 2012 9:32 am
name: Andy Amphlett

Return to Help and support

cron