I noticed in DBXL that their are 4 column's called DateCreated, DateModified, Createdby, and Modifiedby.
I already have DocID being added. I don't see these 4 as Mapping Tokens in the Database Mapping in DBXL. Is it possible?
Hi, Jeff:
That's a great feature request for future versions -- I'll be sure to log it!
Currently, I suppose you could write a trigger for your target table (that you are shredding to), and on Insert get the data from the DBXL Document table based on the DocId....
Although they aren't all shown in DAT for DBXL v2.3, the following should all work in mapping:
DBXL::Link
DBXL::DocId
DBXL::DocType
DBXL::RefId
DBXL::VerNo
DBXL::CreatedBy
DBXL::DateCreated
DBXL::ModifiedBy
DBXL::DateModified
Another option would be to create a view that joins your database table with the DBXL Document table on the DocId key value and query that. Doing so would be in keeping with the 2nf principle.