Hi,
I want to use this module but on the action URL_GetSEOURL I get an oracle error.Is the module oracle compatible?Error executing query. Error in advanced query GetSEOData in URL_GetSEOURL in SEOUtils_Lib (SELECT TOP 1 CASE WHEN {SiteRule}.[Id] IS NOT NULL THEN {SiteRule}.[Incoming] ELSE {Parameter}.[Val] END [Domain], CASE WHEN {SiteRule}.[Id] IS NOT NULL THEN 1 ELSE 0 END [IsSiteRule], {PathRule}.[Incoming] [PathRule], CASE WHEN {PageMetaRule}.[Id] IS NOT NULL THEN 1 ELSE 0 END [IsPageMeta], {PageMetaRule}.[Incoming], CASE WHEN {Application}.[ApplicationKind] = @RuntimeKindId_WebResponsiv THEN 1 ELSE 0 END FROM {PathRule} CROSS JOIN {Espace} INNER JOIN {Module} ON {Espace}.[Id] = {Module}.[Espace_Id] INNER JOIN {App_Definition_Module} ON {App_Definition_Module}.[Module_Id] = {Module}.[Id] INNER JOIN {Application} ON {App_Definition_Module}.[Application_Id] = {Application}.[Id] AND {Application}.[Is_Active] = 1 LEFT JOIN {SiteRule} ON {PathRule}.[ExclusiveToSiteRule] = {SiteRule}.[Id] AND {SiteRule}.[Is_Active] = 1 LEFT JOIN {PageMetaRule} ON {P ...): ORA-00923: FROM keyword not found where expected
Kind regards,
Johan
Hi Johan,
Thanks for bringing this to our attention.
Indeed, this action was leveraging on an advanced SQL node written with SQL Server-specific syntax, and thus not working on Oracle.
I uploaded a new version of the component which leverages now in an Aggregate instead, thus working regardless of the database provider.
Kind Regards,João