BSBI Distribution Database > message board

Query to find validations by specific user

Any queries about using the BSBI database

Query to find validations by specific user

by AndyAmphlett » Wed Dec 13, 2017 1:10 pm

Tom,

is there a query that will return records where validation state has been changed by a specific DDb user? This was a query from the VC101 VCRs. Best I could find was this - https://database.bsbi.org/search.php#re ... 153e07357e - which finds records where validation state was changed in 2017. Likely that all, or most, validation edits were by the VCRs, though that could not be assumed for all vcs.

Thanks,

Andy.

Added:

Just noticed that there is a way to do this! For example - https://database.bsbi.org/search.php#re ... b1a76e34fa. Query requires that the DDb User Name is entered.

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

Return to Help and support

cron