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?
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.