Hello,
I'm trying to work out if I can link uploaded documents to metadata stored in a different DB?
For example I'm uploading Works Orders into the DMS. Each WO has a unique ID which can be linked in this case to an ERP system on SQL where we have a lot of data about that works order.
If I could look upto the SQL DB (Table or View) and pick the WO number, it would populate date, product, qty etc from the SQL DB rather than having to key it in again.
Cheers
Steve
The contents you find here are totally obsolete so do not use this website to obtain a solution for your issues: the indications you get from here will not be accurate and may lead to data loss or other mayor problems
Document Metadata from DB?
Moderator: car031
Post
Re: Document Metadata from DB?
Hi Steve,
you can define a new Template (a new type of document) and in this template you can add an attribute which holds the unique ID.
Then it is up to you, LogicalDOC doesn't know anything about the logic you want to implement. But you can search LogicalDOC contents via web-services or you can run queries on the DB.
Attribute values are stored in table ld_document_ext
you can define a new Template (a new type of document) and in this template you can add an attribute which holds the unique ID.
Then it is up to you, LogicalDOC doesn't know anything about the logic you want to implement. But you can search LogicalDOC contents via web-services or you can run queries on the DB.
Attribute values are stored in table ld_document_ext
Who is online
Users browsing this forum: No registered users and 1 guest