HI All
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-10-2025 12:54 AM
HI All,
i have two tables table A and table B.
The value on table B(Like updated date field) should be on table A.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-10-2025 12:55 AM
Hi @basha shaik
Please provide some more details please. are these table are extended from any or like a parent child?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-10-2025 01:01 AM
Hi @basha shaik ,
You can use the After Business Rule on table A for insert/update which will update value in table B Like
(function executeRule(current, previous /*null when async*/) {
var grTab = new GlideRecord('problem'); //consider it for table B
grTab.addEncodedQuery('field='+current.sys_id); // query for particular record
grTab.query();
if(grTab.next())
{
grTab.sys_updated_on = current.sys_updated_on; //update value
grTab.autoSysFields(false); // false for sys_auto_fields.
}
// Add your code here
})(current, previous);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-10-2025 01:06 AM
please share what's your business requirement here'
why have you used 2 tables and what's the purpose for those and relationship between them?