1 of 1 people found this helpful
You'll need to query on the note object, not the incident.
If I query on the note object, will that not only show me incidents that have a note. I would like all breached incidents with and without notes to be shown.
Is that possible within the servicedesk without crystal reports.
You can create a calculated field on the incident object that counts notes.
static def GetAttributeValue(Incident):
Value = Incident.Notes.Count
You can then query on that.
I have never touched calculated fields before so will take your advice that it may work.
I will do some reading up on it amd see what I have to do with/where I have to put the data you gave me.
It sound like it would work perfect for us but as I mentioned before I have not touched calculations so am a but lost tbh.
No doubt I will be back here at some stage.
Any advice would be great.
I took a look at Designer manual and I've managed to get that working.
I have it in a test system so will shwo the powers that be and we should be fine.
Thanks again for the help.