Hi good CA community people.
In ServiceDesk while viewing quick profile, I want to be able to see tickets that are not resolved.
The form I modified is profile_menu.htmpl
I have changed the line from
pb_link("Incident_History", "profile_histcnt_in", "in", "QBE.EQ.customer=$dobref.id" );
pb_link("Incident_History", "profile_histcnt_in", "in", "QBE.EQ.customer=$dobref.id+QBE.EQ.active=1+QBE.EQ.status=RE" );
This successfully shows me tickets that are active and resolved.
However, I need to see tickets that are active and NOT resolved.
I am struggling to figure out how to get the "not equal to" character?
I'd also like to know the syntax for OR
IE: how to get tickets that are active AND ticket is ( not equal to Resolved OR not equal to *** OR not equal to yyy OR not equal to zzz, etc)
Any ideas would be greatly appreciated.
I don't know QBE code for IS NULL value, but you can use additional whereclause:
"QBE.EQ.customer=$dobref.id+KEEP.where_clause=resolve_date is NULL"
fyi: QBE codes could be found here: Control Properties - CA Service Management - 14.1 - CA Technologies Documentation
But there is not complete list, for example QBE.NN which means IS NOT NULL is not presented there.
This is a very clever workaround which solves my problem.
Thank you for the super quick response