Log in to AnswerLog in to Follow
2022-04-15 17-42-43
João Sousa
mvp_badge
MVP
267Views
4Comments
Solved
[OutGource] Error in advanced query GetGourceApps in Preparation in Management in Management in O
Question
Forge
outgource
Web icon
OutGource
Forge component by Caio Santana Magalhães

Hi, 

When i click on the Administration link i got this error:

Error in advanced query GetGourceApps in Preparation in Management in Management in OutGource (select  count({LogVersion}.[Id]) as LogVersionCount,          count({LogError}.[Id]) as LogErrorCount,          {GourceApp}.[Name],          {GourceApp}.[Id]    from    {GourceApp}  inner join  {GourceEspace}  on {GourceApp}.[Id] = {GourceEspace}.[GourceAppId]  inner join  {LogVersion}    on {GourceEspace}.[Id] = {LogVersion}.[GourceEspaceId]  left join   {LogError}      on {LogVersion}.[Id] = {LogError}.[LogVersionId]    where   ({GourceApp}.[IsActive] = 1              or {GourceEspace}.[IsActive] = 1)          and (@Search = ''              or {GourceApp}.[Name] like concat(concat('%', @Search), '%')              or {GourceEspace}.[Name] like concat(concat('%', @Search), '%'))    group by    {GourceApp}.[Name],              {GourceApp}.[Id]    order by    LogVersionCount desc): 'concat' is not a recognized built-in function name.

0
0
13 Nov 2017
UserImage.jpg
rfeitor
Solution

Hi João,

I assume the screen was tested on SQL Server 2012, so the situation reported was not detected, but I'll change it so the application can run on other versions.

Thanks for the feedback.

See solution in context
0
0
13 Nov 2017

rfeitor wrote:

Hi João,

I assume the screen was tested on SQL Server 2012, so the situation reported was not detected, but I'll change it so the application can run on other versions.

Thanks for the feedback.


Hi rfeito,


When you have some free time, could you pretty please check whether the upgrade query in the Gource eSpace in the Action nammed "Upgrade_V2_0_8" runs fine under oracle?


Just released the O11 version of OutGource.


Thanks!

0
0
19 Jun 2019

Hi João, 

I don't know this specific component but from the error it looks like you are using an SQL Server version that doesn't support concat function. Have you tried to replace 

concat(concat('%', @Search), '%') 

with '%'+@search+'%'

Regards  

0
0
13 Nov 2017
2022-04-15 17-42-43
João Sousa
mvp_badge
MVP

Hi André,

I can definitely do that, but because on the description of the component its says Database:All, i was just wanted to report it.

João

0
0
13 Nov 2017
UserImage.jpg
rfeitor
Solution

Hi João,

I assume the screen was tested on SQL Server 2012, so the situation reported was not detected, but I'll change it so the application can run on other versions.

Thanks for the feedback.

0
0
13 Nov 2017

rfeitor wrote:

Hi João,

I assume the screen was tested on SQL Server 2012, so the situation reported was not detected, but I'll change it so the application can run on other versions.

Thanks for the feedback.


Hi rfeito,


When you have some free time, could you pretty please check whether the upgrade query in the Gource eSpace in the Action nammed "Upgrade_V2_0_8" runs fine under oracle?


Just released the O11 version of OutGource.


Thanks!

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