CA Service Management

 View Only
  • 1.  Quick Profile - Not equal to in HTMPL panels

    Posted May 10, 2016 04:16 AM

    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" );

    to

    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.



  • 2.  Re: Quick Profile - Not equal to in HTMPL panels
    Best Answer

    Posted May 10, 2016 04:30 AM

    Hi,

    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.

     

    Regards,

    cdtj



  • 3.  Re: Quick Profile - Not equal to in HTMPL panels

    Posted May 10, 2016 05:22 AM

    Thanks cdtj,

    This is a very clever workaround which solves my problem.

     

    Thank you for the super quick response