How to get the first related record in the business rule

[Santoshi5]

Hi All,

I am stuck in middle, please help me to sort my issue,

for 1 problem if there are 5 incident records are related i want to get the first incident which is related to that problem and want to update some data in to that incident.

Let me know how to add the logic in the filter in business rule so i can get the first record only.

[Musab Rasheed]

Hi Santoshi,

Use setLimit(1) before gr.query(); function and that should work.

Regards

[Santoshi5]

just adding setlimit will not get the exact incident number which is tagged first to that problem, it will give the 1 record not sure if that record is first tagged one or not.

[Musab Rasheed]

Try like this.?

	var rt = new GlideRecord('incident');
rt.addQuery('problem', current.sys_id);
	rt.orderBy('created_on');
rt.setLimit(1);
rt.query();
while(rt.next())
{
rt.short_description = 'wrtie something';
rt.update();
}

[Ankur Bawiskar · Accepted solution]

Hi,

at which place you are writing this script?

BR? if yes then on which table?

Actually there is no field which can help you determine which incident was first linked with the problem

regards
Ankur