since ‎01-02-2019
‎10-12-2019
krish747
Level 2
Re: Not able to check "jcr:lastModified" for Multiple Paths | SQL 2 Query
Avatar

krish747

krish747
- Adobe Experience Manager
Hi Gaurav,Thanks for your timely help! Your query is working as expected post removing 2 extra brackets (which was throws parse exception).SELECT * FROM [cq:PageContent] AS s WHERE (ISDESCENDANTNODE([/content/we-retail/us/en/experience]) and [jcr:lastModified] >= '2016-01-01T00:00' and [jcr:lastModified] <= '2019-10-10T00:00') OR (ISDESCENDANTNODE([/content/we-retail/us/en/men]) and [jcr:lastModified] >= '2016-01-01T00:00' and [jcr:lastModified] <= '2019-10-10T00:00')

Views

354

Likes

0

Replies

0
Not able to check "jcr:lastModified" for Multiple Paths | SQL 2 Query
Avatar

krish747

krish747
- Adobe Experience Manager
Hi,I am trying to get pages under the Multiple paths between last modified date range (fromDate and toDate) . The results are coming but its wrong when checked with "jcr:lastModified". Also it is returning results for the pages where jcr:lastModified property is not exists.SELECT * FROM [cq:PageContent] AS s WHERE ISDESCENDANTNODE([/content/we-retail/us/en/experience]) OR ISDESCENDANTNODE([/content/we-retail/us/en/men]) and [jcr:lastModified] >= '2016-01-01T00:00' and [jcr:lastModified] <= '2019...

Views

418

Like

1

Replies

2
Re: Query Builder Search | Multiple Paths | Single Property & Multiple Values
Avatar

krish747

krish747
- Adobe Experience Manager
Thanks for your help!

Views

466

Likes

0

Replies

0
Query Builder Search | Multiple Paths | Single Property & Multiple Values
Avatar

krish747

krish747
- Adobe Experience Manager
Could anyone please tell me how can I search for the following using Query Builder?1. Multiple Paths (With OR Condition)2. Single Property3. Multiple Values (for the above mentioned Property) (With OR Condition)For instance,Path = /content/abc/a, /content/abc/xyz/xproperty = sling:resourceTypevalue.1=/training/content/titlevalue.2=//training/content/header

Views

643

Like

1

Replies

3
Re: how to get list of filters of a package through code?
Avatar

krish747

krish747
- Adobe Experience Manager
Hi @antoniom54959291,Actually I need this info as I have to perform some actions using Servlet on the paths (pages) which are included in the filter for the given package name/id. It will be helpful if you can post me the Curl command to get the list of filter values. If no options left on the API side, i will try to use Curl. The only thing bothers bothers in Curl is that we have to update the credentials and domains for URL for every environment.

Views

391

Likes

0

Replies

0
how to get list of filters of a package through code?
Avatar

krish747

krish747
- Adobe Experience Manager
Hi,I am trying to find a particular package using its name and want to get the list of filters which the package is containing.Could anyone please suggest me how to get the package using name/id and get its filter list using the api? Thanks in Advance!

Views

900

Like

1

Replies

4
Re: How to get the nodes from JCR after specified date ?
Avatar

krish747

krish747
- Adobe Experience Manager
Could you please tell me how can can I get the nodes modified with from and to Date range? For example, nodes modified between 2014-08-08T23:59:59 to 2018-01-08T23:59:59

Views

972

Likes

0

Replies

0
Likes from