HI All

[basha shaik]

HI All,

i have two tables

1.dms_document 

2.dms_document_revision

i need fetch the field value(update date) dms_document_revision to dms_document .

Please any one suggested

ADV Thanks

[Dr Atul G- LNG]

and where you will store this value in other table, other table also has same field name.

[basha shaik]

no different name

[Dr Atul G- LNG]

Hi @basha shaik 

(function executeRule(current, previous /*undefined*/, action) {

// Define the document_id
var documentId = current.document_id;

// Create a GlideRecord object for the dms_document_revision table
var revisionGR = new GlideRecord('dms_document_revision');

// Query to get the latest update_date for the given document_id
revisionGR.addQuery('document_id', documentId);
revisionGR.orderByDesc('update_date'); // Order by the latest update_date
revisionGR.setLimit(1); // Only get the most recent revision
revisionGR.query();

// Check if a result is found
if (revisionGR.next()) {
var latestUpdateDate = revisionGR.update_date;

// Now, update the dms_document table with the latest update_date
current.update_date = latestUpdateDate;
current.update(); // Save the changes to the dms_document record
}
})(current, previous);