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.

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
    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
    Nov 12, 2021 at 16:37

1 Answer 1

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

1
  • Links get broken over time, so please put the relevant solution as the text for your answer. Feb 28 at 14:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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