Don't miss out Virtual Happy Hour this Friday (April 26).
Try our conversational search powered by Generative AI!
AI OnAI Off
Don't miss out Virtual Happy Hour this Friday (April 26).
You should join tables tblContentProperty, tblPropertyDefinition and tblPropertyDefinitionType to tblContentType.
Here is an example of a block on content area in tblContentProperty. You will need to the block content guid to search,
<div data-classid="36f4349b-8093-492b-b616-05d8964e4c89" data-contentgroup="group_1581718412369" data-contentguid="43212acb-0e1b-4328-9d66-ef138db05380" data-contentname="">{}</div><div data-classid="36f4349b-8093-492b-b616-05d8964e4c89" data-contentgroup="group_1581718412369" data-contentguid="18502083-aaa6-416f-bc9f-84c0d2987396" data-contentname="" data-groups="f9013340-398c-41ee-bba3-de3c2feb4532">{}</div><div data-classid="36f4349b-8093-492b-b616-05d8964e4c89" data-contentgroup="" data-contentguid="4faa829a-7cdb-4b88-9b25-c947d8fa66db" data-contentname="" data-epi-content-display-option="displaymode-half">{}</div><div data-classid="36f4349b-8093-492b-b616-05d8964e4c89" data-contentgroup="" data-contentguid="2a610715-aef8-4890-bd5d-64369f264cf8" data-contentname="" data-epi-content-display-option="displaymode-half">{}</div><div data-classid="36f4349b-8093-492b-b616-05d8964e4c89" data-contentgroup="" data-contentguid="e7ad15e5-ddc1-4040-85e4-3821ae4bbe03" data-contentname="">{}</div>
I have this SQL query:
It works, but a lot of these aren't be used on a page. I get the "This item is not used anywhere message. Is there any way to determine if it's being used?
Thanks!