One of the things that is always difficult is writing queries for AEM. You may spend several minutes to hours constructing some complex ones. In fact, the documentation for query commands available are out there but are often hidden within a Stack Overflow article or on a GitHub repo with not many stars.
It is important though before writing commands to understand how the JCR infrastructure works, which should lead you into understanding what the commands do and how they function. My major takeaway from three years working on AEM so far is that it is a large database where everything can be searched (pages, tags, files) and you can search node within node for some neat yet complex queries.
I leave you with my faves I use all the time in XPATH:
JCR:like -> find exact match for property and text you provide it
JCR:contains -> works to find anything within an array of strings or nodes, maybe with multiple tags
XS:DateTime -> extremely useful when comparing times
And the last one is more of a technique, but nesting. After you make a command inside of square brackets, you can add another //* after it to look within that particular node. this means you can go several levels deep!
There is still a ton to discover and a lot to learn and many unknowns. Enjoy the journey! 🎉
AEM Certified Developer
3w1. To achieve this, Create a class that extends WorkflowProcess. Access the published content path from the workflow payload. Use Message gateway service to send the email that includes the published content link 2. configure the Day CQ Mail Service in the OSGi console with the SMTP server details like the server address, port