For mix:referenceable you can refer this community page  https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-mix-referenceable-in-aem/td-p/542234  

No its not necessary. jcr:uuid property is getting added due to the jcr:mixinTypes = mix:referenceable added on the asset. Assets that are not published also would have jcr:uuid property if mix:referenceable mixinType is present. Please refer this link for more details related to jcr:uuid : https://...

Slow queries could be due to following reasons : Index not availableResult is hugeQuery using different indexes to collect data You can examine your query in Query performance tool in AEM. It will guide you if your query is using any index or not with other details. Path for same is /libs/granite/op...

In case you are using ACS Commons, you can achieve it by using Query Packager. SQL2 Query for same would be  SELECT * FROM [cq:Page] AS page WHERE ISDESCENDANTNODE(page, "/content/we-retail/us/en/products") AND name() like "%shorts%" Link : https://adobe-consulting-services.github.io/acs-aem-commons...

Can you please check if the left-container is getting created inside the initial of the template(templates/template-name/initial/jcr:content/root/container/left-container). If that is the case, you can remove it from initial page of the template. This will lock left-container and wont allow editing ...

@akhilraj that would require debugging the existing flow. I can share the path of components being used in side rail : /libs/wcm/core/components/coral/references

References are getting loaded after executing a query on all Pages. Sample query of getting reference of /content/we-retail/us //element(*, cq:Page)[(jcr:contains(., '"/content/we-retail/us"'))] You can either update all links of page at the time of movement or override the reference section to upda...

As you have mentioned style and experience fragments as well, you have to create package of following filters : /apps/project -> Components/conf/project -> Templates,Styles /content/dam/project -> Assets/content/project -> Website/pages/content/experience-fragments/project -> Experience Fragments Yo...

You can use Assets API if you want to update metadata using server scripts. Sample Command to update title. Request: PUT /api/assets/myfolder/myAsset.png -H"Content-Type: application/json" -d '{"class":"asset", "properties":{"jcr:title":"My Asset"}}' Link : https://experienceleague.adobe.com/docs/ex...

No content is not created by authors on Publisher. Generally user generated content(Data of form submitted by end user) is created on Publishers which sometimes require to be published to author. In that case publishing happens automatically using launchers or sling distribution. So publishing is ba...