Caller id - CID POP

image

<b>{ENTITY NAME}</b><linebreak/>{ENTITY DATA:Telefon}<linebreak/>{ENTITY DATA:Adres}
    Son Sipari┼č Bilgileri<br/>
{REPORT SQL DETAILS:SELECT TOP (1)  Tickets.Date "Tarih", Tickets.TotalAmount "Tutar", TicketEntities.Ticket_Id "Id", CASE WHEN IsClosed = 0 THEN '<color red>├ľdenmedi</color>' ELSE '<color green>├ľdendi</color>' END  "Durum" FROM TicketEntities INNER JOIN Tickets ON TicketEntities.Ticket_Id = Tickets.Id WHERE EntityName in ('{ENTITY NAME}') ORDER BY TicketEntities.Ticket_Id DESC:FD([F.Tarih], 'dd.MM.yyyy HH\:mm\:ss'),F.Tutar,F.Id,F.Durum::ID\:  <b>{2}</b>   -   Tutar\:  <b>{1}</b><br/>Tarih\: <b>{0}</b> - {3}}

5 Likes