Django admin, filter by timestamp range

Question

I have a model with these attributes:

class MyModel(models.Model):
    name = models.CharField(max_length=250, blank=False, null=False)
    timestamp = models.BigIntegerField(default=0)

    def save(self, *args, **kwargs):
        self.timestamp = get_timestamp_in_milli()
        super(MyModel, self).save(*args, **kwargs)

In my admin.py I have declared AdminModel with this model:

@admin.register(MyModel)
class MyModelAdmin(admin.ModelAdmin):
    pass

Is there any calendar like filter, where I can filter range of my timestamp? If yes how to include it?

I know that there is also filter based on DateField, is it possible to make timestamp filterable as DateFiled?

Why use `BigIntegerField` for timestamp when you have [`TimeField`](https://docs.djangoproject.com/en/1.10/ref/models/fields/#timefield)? — shad0w_wa1k3r, Mar 15 '17 at 07:09
The default widget for `TimeField` is a [`TimeInput`](https://docs.djangoproject.com/en/1.10/ref/forms/widgets/#django.forms.TimeInput), maybe that's what you are looking for? — shad0w_wa1k3r, Mar 15 '17 at 07:13
@AshishNitinPatil lets just say that I can't decide what kind of fields I can use :) — Mr.D, Mar 15 '17 at 07:36
Hmm, I suppose you should still be able to use `TimeInput` as the widget. — shad0w_wa1k3r, Mar 15 '17 at 07:39
@AshishNitinPatil can you provide example? I'm just new to django. — Mr.D, Mar 15 '17 at 07:49
See http://stackoverflow.com/a/22250192/2689986 and https://docs.djangoproject.com/en/1.10/ref/forms/widgets/ — shad0w_wa1k3r, Mar 15 '17 at 09:46

score 0 · Answer 1 · edited May 23 '17 at 11:46

0

I think you should get that range of dates (sidenote: __range=[timestamp__lte, timestamp__gte]) the normal way (i.e., <input type="date" name="timestamp__lte"> <input type="date" name="timestamp__gte">) from the client and then convert it in the server. Here's a good post.

edited May 23 '17 at 11:46

Community

1
1

answered Mar 15 '17 at 07:15

RompePC

815
1
8
17

Where I do need to write this part of code? I'm just new to django. – Mr.D Mar 15 '17 at 09:02
[`__range`](https://docs.djangoproject.com/en/1.10/ref/models/querysets/#range) is part of the QuerySet API. Is just a filter, as if you do `name__icontains="something"`. They are "magical" filters that can be used in the fields (depending of their type). The ``s would need to be submitted via form, and then you would do something like `MyModel.objects.get(timestamp__range=[timestamp__lte, timestamp__gte])`, where the list are vars from POST (or GET). – RompePC Mar 15 '17 at 09:12

Django admin, filter by timestamp range

1 Answers1