Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
Can anyone help me to get rid of hard codes.
I have to fetch the count of ticket hops greater than or equal to group_transfers_limit. group_transfers_limit is a field which has the value 3.
=count({$<ResolvedTicket.InAMSScope={'-1'},[Common Ticket Type]={'INCIDENT'},[ResolvedTicket.Group Transfers]={">2"}>}ResolvedTicket.TicketID)
Above expression gives the count of ticket hops greater than 2. I need an expression without hard code and we have to modify the expression using >=group_transfers_limit field in place of hard code.
Could you please modify one more expression to remove hard code,
Thanks in advance.
Smitha
Hi,
Try this.
=count({$<ResolvedTicket.InAMSScope={'-1'},[Common Ticket Type]={'INCIDENT'},[ResolvedTicket.Group Transfers]={"$(=max(group_transfers_limit))"}>}ResolvedTicket.TicketID)
Regards,
Kaushik Solanki
Hi Smitha,
Try this.
=count({$<ResolvedTicket.InAMSScope={'-1'},[Common Ticket Type]={'INCIDENT'},[ResolvedTicket.Group Transfers]={'>=group_transfers_limit'}>}ResolvedTicket.TicketID)
or if its possible to have it in a variable then it will be like below.
=count({$<ResolvedTicket.InAMSScope={'-1'},[Common Ticket Type]={'INCIDENT'},[ResolvedTicket.Group Transfers]={'>=$(vgroup_transfers_limit)'}>}ResolvedTicket.TicketID)
thanks,
Rajesh Vaswani