[Forge Components Installed Versions] Fails in Oracle
forge-components-installed-versions
Web icon
Forge component by David Farinha
Application Type
Traditional Web

Hi,
I'm using the component on Oracle and it fails

It believe the GetForceComponents (should it be GetForgeComponents) advanced query in Oracle should be:

SELECT Application.Name Name, 
ApplicationId, 
HasLocalChanges, 
(CAST(ROUND(ForgeBaseVersion, 0)/1000000 as int)) Major,
(REMAINDER(ROUND(ForgeBaseVersion, 0),1000000)/1000) Minor,
(REMAINDER(ROUND(ForgeBaseVersion, 0),1000)) Revision,
ForgeBaseVersion,
LastSync 
FROM OS@SYS_APP_FORGE AppForge
JOIN OS@SYS_APPLICATION Application ON Application.ID = AppForge.ApplicationId AND Application.Is_Active=1
WHERE AppForge.LastSync = (SELECT Max(OS@SYS_APP_FORGE.LastSync)
                            FROM OS@SYS_APP_FORGE
                            JOIN OS@SYS_APPLICATION ON OS@SYS_APPLICATION.ID = OS@SYS_APP_FORGE.ApplicationId
                                                    AND OS@SYS_APPLICATION.Is_Active=1
                            WHERE OS@SYS_APP_FORGE.ApplicationId = AppForge.ApplicationId)
AND Application.Name LIKE '%' || @SearchKeyword || '%'
ORDER BY Application.Name ASC

Can you check?

mvp_badge
MVP

There's another Oracle issue.

The advanced query GetLastestPublished doesn't work either

SELECT TOP(10) OS@SYS_APPLICATION.Name, ApplicationId, HasLocalChanges, '','','',ForgeBaseVersion, LastSync 
  FROM OS@SYS_APP_FORGE
JOIN OS@SYS_APPLICATION ON OS@SYS_APPLICATION.ID = OS@SYS_APP_FORGE.ApplicationId AND OS@SYS_APPLICATION.Is_Active=1
ORDER BY LastSync DESC

TOP(10) is not supported in Oracle. So it seem this component was written for SQLServer only.


Please make it generic.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.