Forums OroCRM OroCRM – How do I? Questions Report with custom field

This topic contains 1 reply, has 2 voices, and was last updated by  Artem Liubeznyi 2 years ago.

  • Creator
  • #25903



    I created a custom field for the Lead entity: next_contact_date. Now, I need a report to give me all leads with next_contact_date < now. The problem here is that not all leads have this new field set (probably null in the database), and the report won’t show me those leads.

    Is there a way to ask if the custom field is (or not) null or not set, or to give a custom field a default value??

    Thanks a lot.

Viewing 1 replies (of 1 total)
  • Author
  • #25904

    Artem Liubeznyi

    Hi Matias,

    Unfortunately we don’t have the “Is empty” clause for Datetime fields, nor it is possible to set up the default value for a custom field of this type. A great idea for the future improvement though, I will add it to our backlog.

    Thank you!

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.