Not getting result from .txt from dam | Community
Skip to main content
codingStar
codingStar
New Participant
October 9, 2019
Solved

Not getting result from .txt from dam

  • October 9, 2019
  • 5 replies
  • 3077 views

Hi,

I m getting result if I am upload a .txt file in dam manually. below is the query

SELECT * FROM [dam:Asset] AS s WHERE CONTAINS(s.*, '" + mykeyword+ "') AND [jcr:path] like '/content/dam/myprojectfolder%'

but in second case if I created .txt file in dam using stream(which i am getting from some external system) then above query is not returning any result.

anyone share why i am not getting result in second case.

Thanks

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by codingStar

Hi @arpitv27529355 @ka786  I have figured it out.

jcr:mimeType was incorrect on below path for generated file stream.

/content/dam/myprojectfolder/mytextfile.txt/jcr:content/renditions/original/jcr:content

To fix this updated the code provided mimeType as "text/plain", below is the code

AssetManager assetManager=resourceResolver.adaptTo(AssetManager.class);

assetManager.createAsset(fileName, stream, "text/plain", true);

5 replies

codingStar
codingStarAuthorAccepted solution
New Participant
October 10, 2019

Hi @arpitv27529355 @ka786  I have figured it out.

jcr:mimeType was incorrect on below path for generated file stream.

/content/dam/myprojectfolder/mytextfile.txt/jcr:content/renditions/original/jcr:content

To fix this updated the code provided mimeType as "text/plain", below is the code

AssetManager assetManager=resourceResolver.adaptTo(AssetManager.class);

assetManager.createAsset(fileName, stream, "text/plain", true);

ArpitVarshney
ArpitVarshney
New Participant
October 9, 2019

Hi codingStar ,

Please verify when you are creating a txt file from Stream the jcr:primaryType of the assest should be [dam:Asset] not the nt:file  or try using nt:base [which is considered to be parent node of all nodes] in query which will return all the nodes if any of the child nodes contain particular keyword.

SELECT * FROM nt:base AS s WHERE CONTAINS(s.*, '" + mykeyword+ "') AND [jcr:path] like '/content/dam/myprojectfolder%'

Regards,

Arpit Varshney

Ankur_Khare
Ankur_Khare
New Participant
October 9, 2019

Could you please upload both the files here

codingStar
codingStarAuthor
New Participant
October 9, 2019

I have verified all the nodes and properties/values are same.

Ankur_Khare
Ankur_Khare
New Participant
October 9, 2019

Could you please check the node properties when you are getting from external system and when you are directly uploafing to dam.

Terms & ConditionsAccessibility statement

Loading footer...