SQL-2 Query

Harish Singh asked 2 years ago

I am Facing one issue. My article date property i.e jcr:datetime were stored in below format. Where property type is date
Jcr:datetime 11/11/2017
So when i do order by jcr:datetime iam getting improper results because jcr:datetime type is string not date. Without chaining the type in my whole content. Is there any solution where i can do with sql-2 query.

SELECT * FROM [cq:PageContent] AS s WHERE ISDESCENDANTNODE(s,’/content/rewrite/en_us/topic’) and s.[jcr:datetime] IS NOT NULL order by s.[jcr:datetime]

8 Answers
Sam answered 5 months ago

I\’m also facing this issue. how to delete snapchat

Lucy answered 5 months ago

I also get this error.
how to delete snapchat 2019

Amy Jones answered 3 weeks ago

Hi there! Such a piece of good information. I’m a student and of course, I want to have money and I decided to work as a freelance writer on essay writers service. Our essay writing service Essays-Writers.net has been rated the best in completing diverse writing tasks given to students at their educational institutions, such as colleges, high schools, and universities.

Your Answer