Test null date server side

[Fabio Lenzarini]

Hi all,

I've a server procedure where I need to filter data where a date field is ull.. just create the record.

I've try some test like:

    message_schedule.filters.next_start.value = isnull

but I' got error..

some suggestion?

thanks

Fabio

[Danijel Kaurin]

Hi Fabio.

To filter data on the server on item open. user on_before_open server event and filter data on this way:

params['__filters'].append([' next_start ', item.task.consts.FILTER_ISNULL, True])

Can you describe what you want to do exactly?

Regards

Danijel

--
You received this message because you are subscribed to the Google Groups "Jam.py Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jam-py+un...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/jam-py/4aa14f0e-8e35-40ae-8daf-e0f97d4d2093n%40googlegroups.com.

[Fabio Lenzarini]

Hi Danijel, thanks Drazen

This seems to be working properly:

   ## imposto la prima volta

    message_schedule = task.message_schedule.copy(handlers = False)

   

    message_schedule.set_where(next_start__isnull = True)

    #message_schedule.set_where(next_start = isnull)

    message_schedule.open()

   

    for message_schedule_loop in message_schedule:

       

        message_schedule_loop.edit()

        # imposto l'orario del nuovo messaggio

[Dean D. Babic]

Thanks,

I updated the Docs.