...
| Code Block |
|---|
SELECT
pp.username ,
pp.pagename ,
pp.id,
COUNT(pc.portalpage) AS dataplane_gadgets
FROM
portletconfiguration pc
LEFT JOIN
portalpage pp ON pc.portalpage = pp.id
WHERE
pc.gadget_xml LIKE '%dataplane%'
GROUP BY
pp.username, pp.pagename, pp.id
ORDER BY
pp.username, dataplane_gadgets DESC; |
2. Query not executing in a database or taking longer time to execute
In case if the SQL query is not executing
2.1.
...