2

We have two date fields (start and end) in component Metadata. We are displaying all the components with a start date less than the current server time and an end date is greater than the current server time.

Criteria.Add(new

CustomMetaDateRangeCriteria("Startfieldname",Datetime.MinValue,servertime,true)
Criteria.Add(new CustomMetaDateRangeCriteria("endfieldname",servertime,Datetime.MaxValue,false)

The above query works fine in the 8.5 environment but in 9.5, query results are not accurate. I guess it is not considering the "HH:mm:ss" while returning the results. I Checked custom_meta table and date value stored as it is in the Metadata field and it is not converted to UTC format.

Improve this question
2
  • are you using micro services , if so are you getting error on the content service logs , does the output for both 8.5 and 9.5 same are its different
    – Anand N S ♦
    Commented Oct 29, 2021 at 9:11
  • We are facing the same issue and R&D is working on providing the hotfix for the issue.
    – Paras
    Commented Nov 12, 2021 at 16:37

1 Answer 1

Reset to default
1

Please refer to this link and run the profiler to get the query and see if you have the same problem if not you can reach out to support

Improve this answer
1
  • Links get broken over time, so please put the relevant solution as the text for your answer.
    – Peter Kjaer
    Commented Feb 28, 2022 at 14:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.