[Dbix-class] Constructing "WHERE" clause in DBIx

[Peter Rabbitson]

Eric Wee wrote:
> Hi there,
> 
>  
> 
> I’m trying to construct the following “where” clause in DBIx but not
> sure how to do so.
> 
>  
> 
> WHERE
> 
>             is_retail = '1'
> 
>             AND enabled_date is not null
> 
>             AND enabled_date < now()
> 
>             AND (disabled_date is null
> 
>                         OR disabled_date < enabled_date
> 
>                         OR disabled_date > now())
> 
>  
> 

Show us what you've tried so far.