Related list to show cases with same first word in short description

[j0unss]

Hi,

Is it possible to create related list which shows all the cases which has exactly the same first word in short description than case which is currently open? And am I able to show this list only when short description starts with predifined words?

What I am looking for is, that user should be able to see easily other related order tickets (same order number in short description) when he/she is handling service order case ie. short description starts with service order prefix.

[Ankur Bawiskar]

@j0unss 

Please share some screenshot for better understanding

[livval]

Hi.

It's difficult to say without examples, but try something like this in the Relationship:

(function refineQuery(current, parent) {
	// Add your code here, such as current.addQuery(field, value);
	var firstWord = parent.short_description.split(" ")[0];
	current.addQuery("short_description", "STARTSWITH", firstWord);
})(current, parent);

firstWord - splits the short_description of currently opened form into an array or words and takes the first word.

current.addQuery - adds a query for short description, which starts with the first word

[livval · Accepted solution]

Try this code in the Relationship:

(function refineQuery(current, parent) {
	// Add your code here, such as current.addQuery(field, value);
	var firstWord = parent.short_description.split(" ")[0];
	current.addQuery("short_description", "STARTSWITH", firstWord);
})(current, parent);

[j0unss]

Thank you very much @livval! That worked.