Table sbmSUBMISSIONS has a lot of information related to the actions performed by websubmit (new record creation, modifications, etc). It stores the user id that performed the websubmit action, the action’s type (SBI, MBI, APP), the reference or report number (i.e. BOOK–2010-005), the date, time and status of the action.
This is a great piece of information. But, surprisingly (at least it is to me) the recid (also referred as sysno) is NOT stored in that table. I guess there is a (good?) reason for this, but I am not aware of it.
Well, which is the quickest way to get recid (sysno) from a report number? This is it:
>>> from invenio.websubmit_functions.Get_Recid import get_existing_records_for_reportnumber >>> recid = get_existing_records_for_reportnumber('TAZ-2010-078') >>> print recid