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

chandrareddy
Community profile chandrareddy Level 2
Job title here
Location here
6 BADGES
Level 2

Level 2

Learn more
Joined the community 06-11-2020 3:48:47 AM
Online
Top badges earned by chandrareddy
Customize the badges you want to showcase on your profile
Re: Requirement on Query builder
Avatar
Give Back 5
Level 2
chandrareddy
Level 2

Likes

2 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Boost 1
Ignite 3
Give Back 3
Give Back
View profile
chandrareddy
- Adobe Experience Manager
Exactly, this is my requirement.Let me check and confirm back. thanks a lot.

Views

104

Like

1

Replies

0
Re: Requirement on Query builder
Avatar
Give Back 5
Level 2
chandrareddy
Level 2

Likes

2 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Boost 1
Ignite 3
Give Back 3
Give Back
View profile
chandrareddy
- Adobe Experience Manager
I think my question is not correct. Now I have updated.Actually the given solution only works for point 1. 1. xyz:pubic --> property value can be 'yes' or xyz:pubic --> property value is not defined means null. 2. xyz:pubic --> property not available/exist for DAM assets above 2 conditions should match.if xyz:public property not available for assets need to fetch those assets and,if property available then value should be 'yes/null'.

Views

136

Like

1

Replies

1
Requirement on Query builder
Avatar
Give Back 5
Level 2
chandrareddy
Level 2

Likes

2 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Boost 1
Ignite 3
Give Back 3
Give Back
View profile
chandrareddy
- Adobe Experience Manager
Hi Team, I am fetching some DAM assets based on the below property (xyz:public).1) Below is the condition it should use to fetch the result. 1. xyz:pubic --> property value can be 'yes' or xyz:pubic --> property value is not defined means null. 2. xyz:pubic --> property not available/exist for DAM assets above 2 conditions should match. In simple terms, if xyz:public property not available for assets need to fetch and if property available then value should be 'yes/null' and value should not be ...

Views

154

Likes

0

Replies

6
How to Delete DAM asset which is having specific property in AEM using servelt or groovy script?
Avatar
Give Back 5
Level 2
chandrareddy
Level 2

Likes

2 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Boost 1
Ignite 3
Give Back 3
Give Back
View profile
chandrareddy
- Adobe Experience Manager
Hi Team, Can someone suggest how to delete DAM documents which is having particular property either servlet or groovy script or any other methods?

Views

353

Likes

0

Replies

1
Re: Query to find list of pages with a particular property
Avatar
Give Back 5
Level 2
chandrareddy
Level 2

Likes

2 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Boost 1
Ignite 3
Give Back 3
Give Back
View profile
chandrareddy
- Adobe Experience Manager
https://gist.github.com/floriankraft/8b3720464318cd5cd9e2 helped me to find the required list. SELECT * FROM [nt:unstructured] AS node WHERE ISDESCENDANTNODE(node, "/search/in/path") AND PROPERTY(node.[propertyName], "DATE") LIKE "%" Thanks a lot.

Views

235

Likes

0

Replies

0
Re: Query to find list of pages with a particular property
Avatar
Give Back 5
Level 2
chandrareddy
Level 2

Likes

2 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Boost 1
Ignite 3
Give Back 3
Give Back
View profile
chandrareddy
- Adobe Experience Manager
thanks for reply kiran. property.Type is String for all docs around 5k. only few may be 10 to 20 mistakenly created with property.Type=Long, need to identify those using qury

Views

323

Likes

0

Replies

0
Re: Query to find list of pages with a particular property
Avatar
Give Back 5
Level 2
chandrareddy
Level 2

Likes

2 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Boost 1
Ignite 3
Give Back 3
Give Back
View profile
chandrareddy
- Adobe Experience Manager
Thanks for the reply sanket. This is fetching all records.property.Type=Long is not working it seems.

Views

330

Likes

0

Replies

0
Query to find list of pages with a particular property
Avatar
Give Back 5
Level 2
chandrareddy
Level 2

Likes

2 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Boost 1
Ignite 3
Give Back 3
Give Back
View profile
chandrareddy
- Adobe Experience Manager
Hi Team,I am trying to get list of documents with below property (ingredion:productId). I able to fetch the properties but I need only the properties with type Long.How to query that, can someone suggest. Below is the query i am using to fetch the records.But I want only the records whose property is property type is long.I tried property.Type=Long but still all records are coming. path=/content/dam/xyztype=dam:Asset1_property=jcr:content/metadata/ingredion:productIds Thanks,Chandra

Views

420

Likes

0

Replies

7
Likes given to
Likes from