Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

krish747
Community profile krish747 Level 2
Job title here
Location here
9 BADGES
Level 2

Level 2

Learn more
Joined the community 01-02-2019 3:49:20 AM
Offline
Top badges earned by krish747
Customize the badges you want to showcase on your profile
Re: Not able to check "jcr:lastModified" for Multiple Paths | SQL 2 Query
Avatar
Give Back 3
Level 2
krish747
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

1 solution
Top badges earned
Give Back 3
Ignite 3
Give Back
Ignite 1
Validate 1
View profile
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

446

Likes

0

Replies

0
Not able to check "jcr:lastModified" for Multiple Paths | SQL 2 Query
Avatar
Give Back 3
Level 2
krish747
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

1 solution
Top badges earned
Give Back 3
Ignite 3
Give Back
Ignite 1
Validate 1
View profile
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

514

Like

1

Replies

2
Re: Query Builder Search | Multiple Paths | Single Property & Multiple Values
Avatar
Give Back 3
Level 2
krish747
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

1 solution
Top badges earned
Give Back 3
Ignite 3
Give Back
Ignite 1
Validate 1
View profile
krish747
- Adobe Experience Manager
Thanks for your help!

Views

711

Likes

0

Replies

0
Query Builder Search | Multiple Paths | Single Property & Multiple Values
Avatar
Give Back 3
Level 2
krish747
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

1 solution
Top badges earned
Give Back 3
Ignite 3
Give Back
Ignite 1
Validate 1
View profile
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

889

Like

1

Replies

3
Re: how to get list of filters of a package through code?
Avatar
Give Back 3
Level 2
krish747
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

1 solution
Top badges earned
Give Back 3
Ignite 3
Give Back
Ignite 1
Validate 1
View profile
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

616

Likes

0

Replies

0
how to get list of filters of a package through code?
Avatar
Give Back 3
Level 2
krish747
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

1 solution
Top badges earned
Give Back 3
Ignite 3
Give Back
Ignite 1
Validate 1
View profile
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

1.1K

Like

1

Replies

4
Re: How to get the nodes from JCR after specified date ?
Avatar
Give Back 3
Level 2
krish747
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

1 solution
Top badges earned
Give Back 3
Ignite 3
Give Back
Ignite 1
Validate 1
View profile
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

2.1K

Likes

0

Replies

0
Likes from