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 @Aniket Chavan ,

I tried same script but it's not working.

Thanks,

Gopi

[Aniket Chavan · Accepted solution]

Hello @Gopi12 ,

Please try with the modified script below,

<?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();
    
    var alertSysIds = []; // Array to store alert sys_ids

    while (rec.next()) {
      alertSysIds.push(rec.sys_id.toString());
    }

    var gr = new GlideRecord("sys_journal_field");
    gr.addQuery("element_id", "IN", alertSysIds.join(','));
    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>

[Gopi12]

Hi @Aniket Chavan ,

For this I am getting same alert work notes multiple times.

Thanks,

Gopi.

[Aniket Chavan]

Hello @Gopi12 ,

Try with this once,

<?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();
    
    var alertSysIds = []; // Array to store alert sys_ids

    while (rec.next()) {
      alertSysIds.push(rec.sys_id.toString());
    }

    var gr = new GlideRecord("sys_journal_field");
    gr.addQuery("element_id", "IN", alertSysIds.join(','));
    gr.addEncodedQuery("valueLIKEdue to event");
    gr.addQuery("element", "work_notes");
    gr.orderBy("element_id"); // Order by alert number
    gr.query();

    var uniqueAlerts = {}; // Use an object to track unique alerts

  </g:evaluate>
  <table border="1">
    <tr><td colspan="2">Event Messages</td></tr>
    <tr>
      <th>Alert Number</th>
      <th>Work Notes</th>
    </tr>
    <j:while test="${gr.next()}">
      <tr>
        <td>${gr.element_id}</td>
        <td>${gr.value}</td>
      </tr>
    </j:while>
  </table>
  <style>
    td, th{
      padding: 10px;
    }
  </style>
</j:jelly>

[Gopi12]

Hi @Aniket Chavan ,

Thank you Aniket, For this script I am getting sys_id's of alert , Can we get number for those.

Thanks,

Gopi.