Custom OVS filtering by date issue

[edvardsp]

Hi everyone,

I'm having some problems comparing custom bo value with ticket created date.

I have a custom OVS which is based on custom bo (bo contains promotion codes). OVS is placed on ticket screen.

The OVS works fine, but I need to show only valid items (ovs item FromDate <= inported value CreatedOn <= ovs item ToDate). Basically, createdOn value (which is ticket creation date) should be between FromDate and ToDate. I successfully inported the createdOn value, but when I set it as query parameter, I get zero results.

Not shown in screenshot - ToDate also has a filter parameter like this, but with greaterOrEquals

When I manually put the date value in query parameter, everything works as it should.

I also tried manually creating a data field on OVS and setting the same date value using dataOperation and then use it as query parameter - no success.

Any ideas on why it is not working? Is it a limitation or a bug? Is there any other way to filter out these items?

Thanks,

Edvards

[kanwar_vishal2]

Do you have any solution for such an issue I am stuck in the same situation