- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-14-2024 06:13 AM - edited 02-14-2024 06:43 AM
I have record producer for change table. When I submit the form the request details should update on change request - description field.
@shyam10
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-14-2024 06:58 AM
Hello @sunil kumar11 ,
You can write your record producer script as below,
var desc = '
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-14-2024 07:07 AM
Yeah you could do something like.
current.description = 'Source MSSQL DB: ' + producer.mssql_variable + '\n';
current.description += 'Hostname: ' + producer.hostname_variable+ '\n';
current.description += 'Source Environment: ' + producer.source_env_variable+ '\n';
And so on.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-14-2024 06:19 AM
Hello @sunil kumar11 ,
You can use the record producer script, producer object will have access to all the variable of that record producer.
You can access varaible like this producer.variable_name and you can set the description of current record using the current object like current.description.
Please mark this Accepted and Helpful if this worked for you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-14-2024 06:21 AM
current.description = producer.request_details
assuming your field is called request details. This would map whatever value is in that field to the description of the change.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-14-2024 06:45 AM - edited 02-14-2024 06:49 AM
Thanks for the response.
I don't want all the field in the description only these 6 filed value should be in the description
Source Database Instance CI :
Source MSSQL DB ORACLE Schema :
Hostname of server on which database is hosted :
Type of Database Decommission :
INDIRECT and DIRECT Application list :
Source DB Restricted :
Source Environment :
Can you please help me where i can use this ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-14-2024 06:49 AM
You can write the script here, on the record producer form.