Hey guys any idea why I cannot see DMXzone Database Custom Query in the properties pain. I have DMXzone Database Connector 2 and DMXzone Database Updater 2 installed.

Anyone else have this issue?

Requirements
Product: Dreamweaver CC 2015+
Required Extensions: DMXzone Database Updater 2, DMXzone Database Connector 2

Any ideas guys?

Hello,
What exactly the issue is? Do you see the custom query step in Server Connect?

Hi Teodor

When i add the custom query.
1) I select mysql
2) paste query

SELECT
  SUBSTRING_INDEX (SUBSTRING_INDEX (SUBSTRING_INDEX (SUBSTRING_INDEX (analytics_wr_domain_ranked_kw.url, '/', 3), '://', -1), '/', 1), '?', 1) AS domain_name,
  COUNT(SUBSTRING_INDEX (SUBSTRING_INDEX (SUBSTRING_INDEX (SUBSTRING_INDEX (analytics_wr_domain_ranked_kw.url, '/', 3), '://', -1), '/', 1), '?', 1)) AS KW_Footprint
FROM analytics_wr_domain_ranked_kw
  LEFT OUTER JOIN project
    ON analytics_wr_domain_ranked_kw.project_id = project.project_id
WHERE project.company_id = :P1
GROUP BY 1,
         project.company_id
ORDER BY KW_Footprint DESC

3) add parameter
4) set parameter in where

execute or save and I get the error, "The parameters are not identical."

Not sure why it wont work with this custom query.

Any ideas?

Can you please try replacing

:P1

in the code with

?