Update rows in Database view
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-28-2017 11:25 AM
Hi All,
I have created a database view to generate report for all Open Request where RITMs are closed. Could anyone of you please let me know whether there is a simple and safe way to do update on these Request rows Or do I need to create separate background script to update these Request row.
Quick reply must be appreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-28-2017 11:54 AM
This depends on what you want to update and how many records.
If it's a lot of rows, then yes, probably a background script.
You might also want to use the two below lines:
gr.setWorkflow(false); //don't trigger BR or any notifications
gr.autoSysFields(false); //do not update system fields
harel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-28-2017 11:00 PM
Is it one time update or do you want to run a schedule job to check the REQ and then update it ?
for one time,you can run a background script with the recommendation above.
For scheduled script run, You can run same script with some modification in schedule script job.
