How to populate work notes based on String value(due to event) through ui page on ui action button?

[Gopi12]

Hi @Ankur Bawiskar ,

Could please help me in the below script.

Ui action script:

   function showEvents() {

       var gm = new GlideModal('event_messages');

       gm.setTitle('Show title');

       gm.setPreference('sysparm_sysid', g_form.getUniqueValue());

       gm.render();

   }

Ui Page script:

<?xml version="1.0" encoding="utf-8" ?>

<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">

<h3>Event table</h3>

 <g:evaluate var="jvar_sysId" expression="RP.getWindowProperties().sysparm_sysid"/>

<g:evaluate jelly="true" object="true">

   var gr = new GlideRecord("em_alert");

 gr.addQuery("u_case",jelly.sysparm_sysid);

 gr.addQuery("work_notesLIKEdue to event");

 gr.query();

   gr;

</g:evaluate>

<table border="1">

  <tr><td colspan="2">Event Messages</td></tr>

  <tr>

   <th>Number</th>

   <th>Work Notes</th>

  </tr>

 <j2:while test="$[gr.next()]">

  <tr>

  <td>$[gr.number]</td>

  <td>$[gr.work_notes.getJournalEntry(-1)]</td>

  </tr>

 </j2:while>

 </table>

 <style>

  td, th{

   padding: 10px;

  }

 </style>

</j:jelly>

Thanks & Regards,

Gopi.

[Ankur Bawiskar · Accepted solution]

@Gopi12 

got it

try this

<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">
	<h3>Event table</h3>
	<g:evaluate var="jvar_sysId" expression="RP.getWindowProperties().sysparm_sysid"/>
	<g:evaluate jelly="true" object="true">

		var rec = new GlideRecord('em_alert');
		rec.addQuery('u_case', jelly.sysparm_sysid);
		rec.query();
		if(rec.next()){
		var gr = new GlideRecord("sys_journal_field");
		gr.addQuery("element_id",rec.sys_id);
		gr.addEncodedQuery("valueLIKEdue to event");
		gr.addQuery("element","work_notes");
		gr.query();
		gr;
		}
	</g:evaluate>
	<table border="1">
		<tr><td colspan="2">Event Messages</td></tr>
		<tr>
			<th>Number</th>
			<th>Work Notes</th>
		</tr>
		<j:while test="${gr.next()}">
			<tr>
				<td>${gr.number}</td>
				<td>${gr.value}</td>
			</tr>
		</j:while>
	</table>
	<style>
		td, th{
		padding: 10px;
		}
	</style>
</j:jelly>

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Gopi12]

Hi @Ankur Bawiskar ,

For above script we are getting case work notes but we need to get case related alert work notes.

Thanks,

Gopi

[Ankur Bawiskar]

@Gopi12 

sysId is for case or which table?

[Gopi12]

Hi @Ankur Bawiskar ,

Sysid is case only,  on case form I have created one ui action, when I click on that we need to populate case related alerts work notes(with specific value) and alert number.

Thanks,
Gopi.

[Ankur Bawiskar · Accepted solution]

@Gopi12 

got it

try this

<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">
	<h3>Event table</h3>
	<g:evaluate var="jvar_sysId" expression="RP.getWindowProperties().sysparm_sysid"/>
	<g:evaluate jelly="true" object="true">

		var rec = new GlideRecord('em_alert');
		rec.addQuery('u_case', jelly.sysparm_sysid);
		rec.query();
		if(rec.next()){
		var gr = new GlideRecord("sys_journal_field");
		gr.addQuery("element_id",rec.sys_id);
		gr.addEncodedQuery("valueLIKEdue to event");
		gr.addQuery("element","work_notes");
		gr.query();
		gr;
		}
	</g:evaluate>
	<table border="1">
		<tr><td colspan="2">Event Messages</td></tr>
		<tr>
			<th>Number</th>
			<th>Work Notes</th>
		</tr>
		<j:while test="${gr.next()}">
			<tr>
				<td>${gr.number}</td>
				<td>${gr.value}</td>
			</tr>
		</j:while>
	</table>
	<style>
		td, th{
		padding: 10px;
		}
	</style>
</j:jelly>

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Gopi12]

Hi @Ankur Bawiskar ,

It is working fine but we are getting only one alert record, case will have multiple alert, Can we get multiple alert records.

Thanks,

Gopi.