{"id":3076,"date":"2024-11-14T11:05:39","date_gmt":"2024-11-14T11:05:39","guid":{"rendered":"https:\/\/sankhamtech.com\/index.php\/content\/india\/english\/home\/free-courses\/aem-backend-concepts\/understanding-sql2-queries-in-aem\/"},"modified":"2024-11-15T18:06:31","modified_gmt":"2024-11-15T18:06:31","slug":"understanding-sql2-queries-in-aem","status":"publish","type":"page","link":"https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/understanding-sql2-queries-in-aem\/","title":{"rendered":"Understanding SQL2 Queries in AEM"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"3076\" class=\"elementor elementor-3076\">\n\t\t\t\t<div class=\"elementor-element elementor-element-be9eb9f e-flex e-con-boxed e-con e-parent\" data-id=\"be9eb9f\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-89860dc e-con-full e-flex e-con e-child\" data-id=\"89860dc\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cdd033f elementor-hidden-mobile elementor-widget elementor-widget-text-editor\" data-id=\"cdd033f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h6 style=\"text-align: center;\"><span style=\"text-decoration: underline;\">Lessons<\/span><\/h6>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-684df7c elementor-hidden-desktop elementor-hidden-tablet elementor-widget elementor-widget-text-editor\" data-id=\"684df7c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h6 style=\"text-align: center;\"><a href=\"https:\/\/sankhamtech.com\/index.php\/content\/india\/english\/home\/free-courses\/aem-backend-concepts\/\"><span style=\"text-decoration: underline;\">Lessons<\/span><\/a><\/h6>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0ba5cc9 elementor-hidden-mobile elementor-widget elementor-widget-darsanam_header_menu_widget\" data-id=\"0ba5cc9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"darsanam_header_menu_widget.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"darsanam-menu-wrapper \"><div class='hamburger-icon'> &nbsp; Menu<\/div><div class=\"menu-container\"><nav class='elementor-menu'><ul class='darsanam-menu-vertical'><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/github-link-for-the-entire-course\/'>Github Link for the Entire Course<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-how-the-internet-works\/'>[VIDEO LESSON] How the Internet Works<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-web-development-architecture-decoded\/'>[VIDEO LESSON] Web Development Architecture Decoded<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/introduction-to-content-management-systems\/'>Introduction to Content Management Systems<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/content-management-vs-experience-management\/'>Content Management vs Experience Management<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-what-is-adobe-experience-manager\/'>[VIDEO LESSON] What is Adobe Experience Manager?<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-how-to-obtain-adobe-experience-manager-aem-jar-from-adobe\/'>[VIDEO LESSON] How to Obtain Adobe Experience Manager (AEM) JAR from Adobe<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-installing-aem-jar\/'>[VIDEO LESSON] Installing AEM Jar<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/troubleshooting-common-issues-in-installing-aem-jar\/'>Troubleshooting Common Issues in Installing AEM JAR<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/understanding-author-and-publish-instances\/'>Understanding Author and Publish Instances<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/creating-and-editing-a-page-in-aem\/'>Creating and Editing a Page in AEM<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/find-where-page-is-saved-in-backend\/'>Find Where Page is Saved in Backend<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/aems-sling-framework-understanding-component-resolution-and-rendering\/'>AEM\u2019s Sling Framework: Understanding Component Resolution and Rendering<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-creating-a-hello-world-component-in-aem-using-crx-de\/'>[VIDEO LESSON] Creating a \u201cHello World\u201d Component in AEM Using CRX\/DE<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/understanding-jcr-in-the-context-of-aem\/'>Understanding JCR in the Context of AEM<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/nodes-and-properties-in-jcr\/'>Nodes and Properties in JCR<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/jcr-sessions-and-workspaces\/'>JCR Sessions and Workspaces<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/understanding-sql2-queries-in-aem\/' style='color: #FF7700 !important'>Understanding SQL2 Queries in AEM<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/understanding-and-using-aems-querybuilder-tool\/'>Understanding and Using AEM\u2019s QueryBuilder Tool<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/import-and-export-jcr-data-using-package-manager\/'>Import and Export JCR Data Using Package Manager<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/installing-aem-project-archetype\/'>Installing AEM Project Archetype<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/troubleshooting-common-post-deployment-issues-in-aem\/'>Troubleshooting Common Post-Deployment Issues in AEM<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-aem-dialog-box-authoring-development\/'>[VIDEO LESSON] AEM Dialog Box Authoring & Development<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-aem-htl-language-syntax-practice\/'>[VIDEO LESSON] AEM HTL Language Syntax Practice<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-aem-htl-global-objects\/'>[VIDEO LESSON] AEM HTL Global Objects<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-aem-htl-global-objects-contd\/'>[VIDEO LESSON] AEM HTL Global Objects (Contd.)<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-understanding-aem-dialog-box\/'>[VIDEO LESSON] Understanding AEM Dialog Box<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/creating-and-deploying-component-in-aem\/'>Creating and Deploying Component in AEM<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/create-various-dialog-box-fields\/'>Create Various Dialog Box Fields<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-sling-models-and-sightly-introduction\/'>[VIDEO LESSON] Sling Models and Sightly Introduction<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-sling-model-explained-with-real-use-case\/'>[VIDEO LESSON] Sling Model Explained with Real Use Case<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-aem-resource-resolver-query-builder\/'>[VIDEO LESSON] AEM Resource Resolver & Query Builder<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-aem-query-builder-java-beans\/'>[VIDEO LESSON] AEM Query Builder & Java Beans<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-add-css-to-aem-component\/'>[VIDEO LESSON] Add CSS to AEM Component<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-aem-templates-components-authoring\/'>[VIDEO LESSON] AEM Templates & Components Authoring<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-add-css-variations-to-aem-component\/'>[VIDEO LESSON] Add CSS Variations to AEM Component<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/creating-a-multi-field-in-aem\/'>Creating a Multi-Field in AEM<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/creating-a-composite-multifield-in-aem\/'>Creating a Composite Multifield in AEM<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/implementing-conditional-dialog-fields\/'>Implementing Conditional Dialog Fields<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/best-practices-for-creating-sling-models\/'>Best Practices for Creating Sling Models<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-introduction-to-aem-sling-servlet\/'>[VIDEO LESSON] Introduction to AEM Sling Servlet<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-aem-headless-servlet-implementation\/'>[VIDEO LESSON] AEM Headless \u2013 Servlet Implementation<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-osgi-services-introduction\/'>[VIDEO LESSON] OSGI Services Introduction<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-aem-osgi-services-implementation\/'>[VIDEO LESSON] AEM OSGI Services Implementation<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lesson-filters-in-osgi-services\/'>[VIDEO LESSON] Filters in OSGI Services<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/calling-external-api-from-osgi-service\/'>Calling External API from OSGI Service<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/improving-aem-sling-model-with-service-layer-integration\/'>Improving AEM Sling Model with Service Layer Integration<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/best-practices-for-secure-and-efficient-resource-access\/'>Best Practices for Secure and Efficient Resource Access<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/video-lessonstep-by-step-process-to-get-resource-resolver-from-system-user\/'>[VIDEO LESSON]Step By Step Process to Get Resource Resolver from System User<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/the-importance-and-use-cases-of-workflows\/'>The Importance and Use Cases of Workflows<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/introduction-to-workflow-creation\/'>Introduction to Workflow Creation<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/understanding-participant-step-in-aem\/'>Understanding Participant Step in AEM<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/understanding-workflow-steps\/'>Understanding Workflow Steps<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/understanding-workflow-steps-contd\/'>Understanding Workflow Steps [Contd.]<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/step-1-understand-aem-workflow-use-case\/'>Step 1: Understand AEM Workflow Use Case.<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/step-2-create-user-groups-and-assign-users\/'>Step 2: Create User Groups and Assign Users<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/step-3-create-new-page-properties\/'>Step 3: Create New Page Properties<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><li class='darsanam-menu-item'><a href='https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/workflow-example-code-below\/'>Workflow Example Code Below<\/a><i class=\"menu-icon-right fas fa-angle-right\"><\/i><\/li><\/ul><\/nav><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-0325bd8 e-con-full e-flex e-con e-child\" data-id=\"0325bd8\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7a85e6e elementor-widget elementor-widget-text-editor\" data-id=\"7a85e6e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h2>Understanding SQL2 Queries in AEM<\/h2><p><\/p><p>SQL2 is a robust querying language used in Adobe Experience Manager (AEM) for interacting with the Java Content Repository (JCR). It allows for efficient querying of JCR content, offering flexibility and precision. Below are practical examples of SQL2 queries, inspired by common use cases in AEM, demonstrating various functionalities.<\/p><p> <\/p><h4 class=\"wp-block-heading\">Accessing CRX\/DE for Query Execution<\/h4><p> <\/p><p>To execute SQL2 queries in AEM:<\/p><p> <\/p><ol class=\"wp-block-list\"><li><strong>Open CRX\/DE<\/strong>: First, navigate to your AEM instance and append <code>\/crx\/de<\/code> to the URL to open CRX\/DE, which is the development environment for AEM\u200b\u200b.<\/li> <li><strong>Accessing the Query Tool<\/strong>: In CRX\/DE, you will find a &#8220;Query&#8221; tool under the &#8220;Tools&#8221; section. Click on this to open the query execution environment.<\/li> <li><strong>Type Selection:<\/strong> Select Type as SQL2 from the drop down.<\/li><\/ol><p> <\/p><h4 class=\"wp-block-heading\">Understanding the Query Language<\/h4><p> <\/p><h5 class=\"wp-block-heading\">Selecting All Nodes with a Specific Name<\/h5><p> <\/p><pre class=\"wp-block-code\"><code>SELECT * FROM [nt:unstructured] AS node\nWHERE ISDESCENDANTNODE(node, \"\/content\/we-retail\")\n<\/code><\/pre><p> <\/p><ul class=\"wp-block-list\"><li><strong>Use Case<\/strong>: Find all nodes named <code>nodeName<\/code> under the <code>\/content\/we-retail<\/code> path.<\/li> <li><strong>Explanation<\/strong>: This query searches for nodes of type <code>[nt:unstructured]<\/code> and filters them based on their name and location in the JCR.<\/li><\/ul><p> <\/p><h5 class=\"wp-block-heading\">Querying All Pages Below a Content Path<\/h5><p> <\/p><pre class=\"wp-block-code\"><code>SELECT * FROM [cq:Page] AS page\nWHERE ISDESCENDANTNODE(page, \"\/content\/we-retail\/language-masters\/en\")\n<\/code><\/pre><p> <\/p><ul class=\"wp-block-list\"><li><strong>Use Case<\/strong>: Retrieve all pages under the English section of the We.Retail site.<\/li> <li><strong>Explanation<\/strong>: This query focuses on nodes of type <code>[cq:Page]<\/code>, which represent AEM pages, filtering by their path in the JCR.<\/li><\/ul><p> <\/p><h5 class=\"wp-block-heading\">Finding All Components of a Specific Resource Type<\/h5><p> <\/p><pre class=\"wp-block-code\"><code>SELECT * FROM [nt:unstructured] AS comp\nWHERE ISDESCENDANTNODE(comp, \"\/content\/we-retail\/language-masters\/en\")\nAND [sling:resourceType] = \"weretail\/components\/content\/heroimage\"\n<\/code><\/pre><p> <\/p><h4 class=\"wp-block-heading\">Selecting Nodes Where a Property Contains a Specific String<\/h4><p> <\/p><pre class=\"wp-block-code\"><code>SELECT * FROM [nt:unstructured] AS node\nWHERE ISDESCENDANTNODE(node, \"\/content\/we-retail\/language-masters\/en\/men\")\nAND CONTAINS([fileReference], \"\/content\/dam\/we-retail\/en\/activities\/biking\/enduro-trail-jump.jpg\")\n<\/code><\/pre><p> <\/p><h5 class=\"wp-block-heading\">Filtering Nodes Based on Date Properties<\/h5><p> <\/p><pre class=\"wp-block-code\"><code>SELECT page.* FROM [nt:unstructured] AS page\nWHERE ISDESCENDANTNODE(page, \"\/content\/we-retail\/language-masters\/en\/men\")\nAND page.[cq:lastModified] &gt;= CAST(\"2014-03-14T21:41:59.339+01:00\" AS DATE)<\/code><\/pre><p> <\/p><h5 class=\"wp-block-heading\">Using Join to Get Specific Components Under a Page.<\/h5><p> <\/p><pre class=\"wp-block-code\"><code>SELECT comp.* FROM [nt:unstructured] AS page\nINNER JOIN [nt:unstructured] AS comp ON ISCHILDNODE(comp, page)\nWHERE ISDESCENDANTNODE(page, \"\/content\/we-retail\/language-masters\/en\/men\")\nAND comp.[sling:resourceType] = 'weretail\/components\/content\/title'\n<\/code><\/pre><p> <\/p><ol class=\"wp-block-list\"><li><strong>SELECT Clause<\/strong>:<ul class=\"wp-block-list\"><li><code>SELECT comp.*<\/code>: This part of the query specifies what is being selected. <code>comp.*<\/code> means it selects all properties of the nodes aliased as <code>comp<\/code>.<\/li><\/ul><\/li> <li><strong>FROM Clause<\/strong>:<ul class=\"wp-block-list\"><li><code>FROM [nt:unstructured] AS page<\/code>: This clause indicates the query is selecting from nodes of type <code>[nt:unstructured]<\/code> (a common node type in JCR representing unstructured data), and these nodes are being aliased as <code>page<\/code>. These represent the pages in the AEM site.<\/li><\/ul><\/li> <li><strong>INNER JOIN Clause<\/strong>:<ul class=\"wp-block-list\"><li><code>INNER JOIN [nt:unstructured] AS comp ON ISCHILDNODE(comp, page)<\/code>: This joins the <code>page<\/code> nodes with other <code>[nt:unstructured]<\/code> nodes, aliased as <code>comp<\/code>, where <code>comp<\/code> nodes are children of <code>page<\/code> nodes. Essentially, it&#8217;s linking pages to their child components.<\/li><\/ul><\/li> <li><strong>WHERE Clause &#8211; ISDESCENDANTNODE Function<\/strong>:<ul class=\"wp-block-list\"><li><code>WHERE ISDESCENDANTNODE(page, \"\/content\/we-retail\/language-masters\/en\/men\")<\/code>: This function filters the pages to include only those that are descendants of the specified path. In this case, it&#8217;s filtering to pages under the path <code>\/content\/we-retail\/language-masters\/en\/men<\/code> in the JCR. This typically represents a specific section or category within the AEM site.<\/li><\/ul><\/li> <li><strong>WHERE Clause &#8211; Property Filter<\/strong>:<ul class=\"wp-block-list\"><li><code>AND comp.[sling:resourceType] = 'weretail\/components\/content\/title'<\/code>: This additional filter in the WHERE clause further refines the selection to only those components (child nodes) whose <code>sling:resourceType<\/code> property equals <code>'weretail\/components\/content\/title'<\/code>. This property in AEM typically identifies the specific type or template of a component, and in this case, it&#8217;s filtering for title components.<\/li><\/ul><\/li><\/ol><p> <\/p><h4 class=\"wp-block-heading\">Conclusion<\/h4><p> <\/p><p>These SQL2 query examples demonstrate the versatility of SQL2 in AEM for querying content within the JCR. They cover various scenarios, from simple name-based searches to more complex queries involving joins and property filters. Understanding these examples can greatly aid in efficiently managing and retrieving content in AEM projects.<\/p><p><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Lessons Lessons &nbsp; Menu Github Link for the Entire Course [VIDEO LESSON] How the Internet Works [VIDEO LESSON] Web Development Architecture Decoded Introduction to Content Management Systems Content Management vs Experience Management [VIDEO LESSON] What is Adobe Experience Manager? [VIDEO LESSON] How to Obtain Adobe Experience Manager (AEM) JAR from Adobe [VIDEO LESSON] Installing AEM [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":2868,"menu_order":17,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-3076","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Understanding SQL2 Queries in AEM - Sankham Technologies<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/understanding-sql2-queries-in-aem\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Understanding SQL2 Queries in AEM - Sankham Technologies\" \/>\n<meta property=\"og:description\" content=\"Lessons Lessons &nbsp; Menu Github Link for the Entire Course [VIDEO LESSON] How the Internet Works [VIDEO LESSON] Web Development Architecture Decoded Introduction to Content Management Systems Content Management vs Experience Management [VIDEO LESSON] What is Adobe Experience Manager? [VIDEO LESSON] How to Obtain Adobe Experience Manager (AEM) JAR from Adobe [VIDEO LESSON] Installing AEM [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/understanding-sql2-queries-in-aem\/\" \/>\n<meta property=\"og:site_name\" content=\"Sankham Technologies\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-15T18:06:31+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sankhamtech.com\\\/index.php\\\/content\\\/in\\\/en\\\/home\\\/free-courses\\\/aem-backend-concepts\\\/understanding-sql2-queries-in-aem\\\/\",\"url\":\"https:\\\/\\\/sankhamtech.com\\\/index.php\\\/content\\\/in\\\/en\\\/home\\\/free-courses\\\/aem-backend-concepts\\\/understanding-sql2-queries-in-aem\\\/\",\"name\":\"Understanding SQL2 Queries in AEM - Sankham Technologies\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sankhamtech.com\\\/#website\"},\"datePublished\":\"2024-11-14T11:05:39+00:00\",\"dateModified\":\"2024-11-15T18:06:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sankhamtech.com\\\/index.php\\\/content\\\/in\\\/en\\\/home\\\/free-courses\\\/aem-backend-concepts\\\/understanding-sql2-queries-in-aem\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sankhamtech.com\\\/index.php\\\/content\\\/in\\\/en\\\/home\\\/free-courses\\\/aem-backend-concepts\\\/understanding-sql2-queries-in-aem\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sankhamtech.com\\\/index.php\\\/content\\\/in\\\/en\\\/home\\\/free-courses\\\/aem-backend-concepts\\\/understanding-sql2-queries-in-aem\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sankhamtech.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Content\",\"item\":\"https:\\\/\\\/sankhamtech.com\\\/index.php\\\/content\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"India\",\"item\":\"https:\\\/\\\/sankhamtech.com\\\/index.php\\\/content\\\/in\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"English\",\"item\":\"https:\\\/\\\/sankhamtech.com\\\/index.php\\\/content\\\/in\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sankhamtech.com\\\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"Free Courses\",\"item\":\"https:\\\/\\\/sankhamtech.com\\\/index.php\\\/content\\\/in\\\/en\\\/home\\\/free-courses\\\/\"},{\"@type\":\"ListItem\",\"position\":7,\"name\":\"AEM Backend Concepts\",\"item\":\"https:\\\/\\\/sankhamtech.com\\\/indexphp\\\/content\\\/in\\\/en\\\/home\\\/free-courses\\\/aem-backend-concepts\\\/\"},{\"@type\":\"ListItem\",\"position\":8,\"name\":\"Understanding SQL2 Queries in AEM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sankhamtech.com\\\/#website\",\"url\":\"https:\\\/\\\/sankhamtech.com\\\/\",\"name\":\"Sankham Technologies\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/sankhamtech.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sankhamtech.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/sankhamtech.com\\\/#organization\",\"name\":\"Sankham Technologies\",\"url\":\"https:\\\/\\\/sankhamtech.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sankhamtech.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sankhamtech.com\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/Logo-Dark-1.png\",\"contentUrl\":\"https:\\\/\\\/sankhamtech.com\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/Logo-Dark-1.png\",\"width\":306,\"height\":74,\"caption\":\"Sankham Technologies\"},\"image\":{\"@id\":\"https:\\\/\\\/sankhamtech.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Understanding SQL2 Queries in AEM - Sankham Technologies","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/understanding-sql2-queries-in-aem\/","og_locale":"en_US","og_type":"article","og_title":"Understanding SQL2 Queries in AEM - Sankham Technologies","og_description":"Lessons Lessons &nbsp; Menu Github Link for the Entire Course [VIDEO LESSON] How the Internet Works [VIDEO LESSON] Web Development Architecture Decoded Introduction to Content Management Systems Content Management vs Experience Management [VIDEO LESSON] What is Adobe Experience Manager? [VIDEO LESSON] How to Obtain Adobe Experience Manager (AEM) JAR from Adobe [VIDEO LESSON] Installing AEM [&hellip;]","og_url":"https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/understanding-sql2-queries-in-aem\/","og_site_name":"Sankham Technologies","article_modified_time":"2024-11-15T18:06:31+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/understanding-sql2-queries-in-aem\/","url":"https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/understanding-sql2-queries-in-aem\/","name":"Understanding SQL2 Queries in AEM - Sankham Technologies","isPartOf":{"@id":"https:\/\/sankhamtech.com\/#website"},"datePublished":"2024-11-14T11:05:39+00:00","dateModified":"2024-11-15T18:06:31+00:00","breadcrumb":{"@id":"https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/understanding-sql2-queries-in-aem\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/understanding-sql2-queries-in-aem\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/understanding-sql2-queries-in-aem\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sankhamtech.com\/"},{"@type":"ListItem","position":2,"name":"Content","item":"https:\/\/sankhamtech.com\/index.php\/content\/"},{"@type":"ListItem","position":3,"name":"India","item":"https:\/\/sankhamtech.com\/index.php\/content\/in\/"},{"@type":"ListItem","position":4,"name":"English","item":"https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/"},{"@type":"ListItem","position":5,"name":"Home","item":"https:\/\/sankhamtech.com\/"},{"@type":"ListItem","position":6,"name":"Free Courses","item":"https:\/\/sankhamtech.com\/index.php\/content\/in\/en\/home\/free-courses\/"},{"@type":"ListItem","position":7,"name":"AEM Backend Concepts","item":"https:\/\/sankhamtech.com\/indexphp\/content\/in\/en\/home\/free-courses\/aem-backend-concepts\/"},{"@type":"ListItem","position":8,"name":"Understanding SQL2 Queries in AEM"}]},{"@type":"WebSite","@id":"https:\/\/sankhamtech.com\/#website","url":"https:\/\/sankhamtech.com\/","name":"Sankham Technologies","description":"","publisher":{"@id":"https:\/\/sankhamtech.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sankhamtech.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/sankhamtech.com\/#organization","name":"Sankham Technologies","url":"https:\/\/sankhamtech.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sankhamtech.com\/#\/schema\/logo\/image\/","url":"https:\/\/sankhamtech.com\/wp-content\/uploads\/2023\/12\/Logo-Dark-1.png","contentUrl":"https:\/\/sankhamtech.com\/wp-content\/uploads\/2023\/12\/Logo-Dark-1.png","width":306,"height":74,"caption":"Sankham Technologies"},"image":{"@id":"https:\/\/sankhamtech.com\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/sankhamtech.com\/index.php\/wp-json\/wp\/v2\/pages\/3076","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sankhamtech.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sankhamtech.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sankhamtech.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sankhamtech.com\/index.php\/wp-json\/wp\/v2\/comments?post=3076"}],"version-history":[{"count":7,"href":"https:\/\/sankhamtech.com\/index.php\/wp-json\/wp\/v2\/pages\/3076\/revisions"}],"predecessor-version":[{"id":3586,"href":"https:\/\/sankhamtech.com\/index.php\/wp-json\/wp\/v2\/pages\/3076\/revisions\/3586"}],"up":[{"embeddable":true,"href":"https:\/\/sankhamtech.com\/index.php\/wp-json\/wp\/v2\/pages\/2868"}],"wp:attachment":[{"href":"https:\/\/sankhamtech.com\/index.php\/wp-json\/wp\/v2\/media?parent=3076"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}