Guilherme Rios GuilhermeRios

## JcrQueryLibrary.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                GuilhermeRios
                / JcrQueryLibrary.md
            
            
              Created
              June 3, 2020 19:59
                — forked from floriankraft/JcrQueryLibrary.md
            
              
                Some useful JCR queries (XPATH, SQL2) for AEM/CQ development.
              
          
    SQL2
All nodes with a specific name
SELECT * FROM [nt:unstructured] AS node
WHERE ISDESCENDANTNODE(node, "/search/in/path")
AND NAME() = "nodeName"
All pages below content path

  
## aem-debug
java -jar aem-author-4502.jar -debug 58242

## resize-image-keep-aspect-ratio.php
<?php

public function getImageSizeKeepAspectRatio( $imageUrl, $maxWidth, $maxHeight)
{
	$imageDimensions = getimagesize($imageUrl);

	$imageWidth = $imageDimensions[0];
	$imageHeight = $imageDimensions[1];

	$imageSize['width'] = $imageWidth;
	<?php

	public function getImageSizeKeepAspectRatio( $imageUrl, $maxWidth, $maxHeight)
	{
	$imageDimensions = getimagesize($imageUrl);

	$imageWidth = $imageDimensions[0];
	$imageHeight = $imageDimensions[1];

	$imageSize['width'] = $imageWidth;