I am Facing one issue. My article date property i.e jcr:datetime were stored in below format. Where property type is date
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]
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.