# Ticket Lister Widget issue

**URL:** <https://forum.sambapos.com/t/ticket-lister-widget-issue/1047>\
**Category:** V4 Issue\
**Created:** [April 15, 2014, 9:32pm UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047 "2014-04-15T21:32:48Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![pizzaeilat4](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pizzaeilat4/32/461_2.png) [@pizzaeilat4](https://forum.sambapos.com/u/pizzaeilat4)\
**Post date:** [April 15, 2014, 9:32pm UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/1 "2014-04-15T21:32:48Z")

</div>

@emre  
I try to view tickets on Ticket Lister Widget  
Well I tried everything but it does not work.  
When I use a default database it works great.  
But with my database it does not work.  
What could be the reason?

---

<div class="post-metadata">

**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\
**Post date:** [April 16, 2014, 6:35am UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/2 "2014-04-16T06:35:43Z")

</div>

Did you selected correct `Ticket Type` on `Entity Screen` ? The reason might be … anything. It will be better if you can add screenshots of widget settings and entity screen settings.

---

<div class="post-metadata">

**Author:** ![pizzaeilat4](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pizzaeilat4/32/461_2.png) [@pizzaeilat4](https://forum.sambapos.com/u/pizzaeilat4)\
**Post date:** [April 16, 2014, 6:52am UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/3 "2014-04-16T06:52:46Z")

</div>

![](https://forum.sambapos.com/uploads/default/original/3X/4/f/4f8928a5bf65c5c10000b02b1d37e786846f26b4.png) 

 ![](https://forum.sambapos.com/uploads/default/original/3X/4/3/434f79f52f469a8fb50ee0b344e6a67f054fb90c.png) 

 ![](https://forum.sambapos.com/uploads/default/original/3X/0/3/038eb11c899cedb1746c84552f5075d870e4d9d2.png)

---

<div class="post-metadata">

**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\
**Post date:** [April 16, 2014, 7:01am UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/4 "2014-04-16T07:01:10Z")

</div>

Your settings seems fine. Can you PM me a backup zip file?

---

<div class="post-metadata">

**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\
**Post date:** [April 16, 2014, 7:38am UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/5 "2014-04-16T07:38:01Z")

</div>

Thank you for the backup. Since you’ve included `Paid` state it tries to fetch all tickets created from day 1 🙂

Add this expression to limit that to display tickets only created today.

 ![](https://forum.sambapos.com/uploads/default/original/3X/f/2/f22152b64b2277ed116469717c77e9b876335466.jpeg)

---

<div class="post-metadata">

**Author:** ![pizzaeilat4](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pizzaeilat4/32/461_2.png) [@pizzaeilat4](https://forum.sambapos.com/u/pizzaeilat4)\
**Post date:** [April 16, 2014, 8:03am UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/6 "2014-04-16T08:03:25Z")

</div>

![](https://forum.sambapos.com/uploads/default/original/3X/3/7/377a76ffd34a463646b063c88692529d3b2d38fb.png) 

@emre. Still not working

---

<div class="post-metadata">

**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\
**Post date:** [April 16, 2014, 8:12am UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/7 "2014-04-16T08:12:14Z")

</div>

You’ve mistyped expression…

```
Date > DateTime.Today
```

---

<div class="post-metadata">

**Author:** ![pizzaeilat4](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pizzaeilat4/32/461_2.png) [@pizzaeilat4](https://forum.sambapos.com/u/pizzaeilat4)\
**Post date:** [April 16, 2014, 8:14am UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/8 "2014-04-16T08:14:40Z")

</div>

> [@emre](#):
>
> Date \> DateTime.Today

Thank you @emre works great

---

<div class="post-metadata">

**Author:** ![Isaac](https://forum.sambapos.com/user_avatar/forum.sambapos.com/isaac/32/65380_2.png) [@Isaac](https://forum.sambapos.com/u/Isaac)\
**Post date:** [April 16, 2014, 1:59pm UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/9 "2014-04-16T13:59:47Z")

</div>

@emre

Can we also use `Bill Requested` State in the Ticket Lister Widget?

---

<div class="post-metadata">

**Author:** ![pizzaeilat4](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pizzaeilat4/32/461_2.png) [@pizzaeilat4](https://forum.sambapos.com/u/pizzaeilat4)\
**Post date:** [April 16, 2014, 3:27pm UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/10 "2014-04-16T15:27:09Z")

</div>

Yes i did that and it works.

---

<div class="post-metadata">

**Author:** ![pizzaeilat4](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pizzaeilat4/32/461_2.png) [@pizzaeilat4](https://forum.sambapos.com/u/pizzaeilat4)\
**Post date:** [April 21, 2014, 9:41pm UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/11 "2014-04-21T21:41:18Z")

</div>

@emre  
You showed me how to display closed tickets only created today.  
is it Possible to Add expression to limit display tickets to Current work period?

---

<div class="post-metadata">

**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\
**Post date:** [April 25, 2014, 11:31pm UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/12 "2014-04-25T23:31:44Z")

</div>

It is not possible since there is no ready to use printer tag to obtain work period start date. I can implement it on next update.

---

<div class="post-metadata">

**Author:** ![pizzaeilat4](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pizzaeilat4/32/461_2.png) [@pizzaeilat4](https://forum.sambapos.com/u/pizzaeilat4)\
**Post date:** [April 27, 2014, 2:39pm UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/13 "2014-04-27T14:39:16Z")

</div>

@emre,  
How do I view a certain date tickets??

---

<div class="post-metadata">

**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\
**Post date:** [April 28, 2014, 10:18am UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/14 "2014-04-28T10:18:54Z")

</div>

@pizzaeilat4 maybe you should consider using `Ticket Explorer Widget` instead.

---

<div class="post-metadata">

**Author:** ![pizzaeilat4](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pizzaeilat4/32/461_2.png) [@pizzaeilat4](https://forum.sambapos.com/u/pizzaeilat4)\
**Post date:** [May 3, 2014, 12:49pm UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/15 "2014-05-03T12:49:24Z")

</div>

Well @emre,  
that’s true but I use Ticket Lister Widget to look for existing customers on Facebook or Twitter  
And I can not do it in Ticket Explorer Widget.  
How can I limit the display of tickets for example for a week, a month, two days??

 ![](https://forum.sambapos.com/uploads/default/original/3X/5/6/561ddc68aea7f4e5df5e0ac45a0e52df21b68ab3.png)

---

<div class="post-metadata">

**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\
**Post date:** [May 3, 2014, 4:33pm UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/16 "2014-05-03T16:33:37Z")

</div>

You can try `Date > DateTime.Today - 1` for past two days or `Date > Date.Time.Today - 6` for a week and so…

---

<div class="post-metadata">

**Author:** ![pizzaeilat4](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pizzaeilat4/32/461_2.png) [@pizzaeilat4](https://forum.sambapos.com/u/pizzaeilat4)\
**Post date:** [May 3, 2014, 4:55pm UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/17 "2014-05-03T16:55:43Z")

</div>

> [@emre](#):
>
> Date \> Date.Time.Today - 6

@emre.  
I tried it but unfortunately it does not work

---

<div class="post-metadata">

**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\
**Post date:** [May 3, 2014, 4:59pm UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/18 "2014-05-03T16:59:11Z")

</div>

Sorry for the trial error procedure. I don’t have access sambapos atm. Can you also try `Date > Date.Time.Today -6`? If it won’t work I’ll be able to test it after Monday.

---

<div class="post-metadata">

**Author:** ![pizzaeilat4](https://forum.sambapos.com/user_avatar/forum.sambapos.com/pizzaeilat4/32/461_2.png) [@pizzaeilat4](https://forum.sambapos.com/u/pizzaeilat4)\
**Post date:** [May 3, 2014, 5:06pm UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/19 "2014-05-03T17:06:13Z")

</div>

> [@emre](#):
>
> Date \> Date.Time.Today -6

I’d love to get an answer after check.  
thanks

---

<div class="post-metadata">

**Author:** ![QMcKay](https://forum.sambapos.com/user_avatar/forum.sambapos.com/qmckay/32/27925_2.png) [@QMcKay](https://forum.sambapos.com/u/QMcKay)\
**Post date:** [May 3, 2014, 5:24pm UTC](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047/20 "2014-05-03T17:24:57Z")

</div>

Is this an error (typo) in syntax???  
`Date.Time.Today - 6`

Should it be instead:  
`DateTime.Today - 6`

[Next page](https://forum.sambapos.com/t/ticket-lister-widget-issue/1047.md?page=2)
