Hi everyone,

I’m facing an issue with an Advanced SQL query in OutSystems. When I run the query in Test Values inside Service Studio, I get 86 rows. However, when I run the exact same query in Runtime, with the exact same input parameters (EntityNameId = 51 and EspaceId = 57), I only get 1 row back.

• The query text is identical in both cases.

• The input parameters have been triple-checked and are the same.

• I have the same problem in a normal Aggregate

Has anyone encountered this behavior before? Why would Test Values and Runtime produce different results with the same query and parameters?

Any pointers would be greatly appreciated!

The query I am using:

SELECT ENENTITY_2.[Name], 0 ,ENENTITY_ATTR.[Name],ENENTITYNAMES_2.[id],ENENTITY_ATTR_2.[name],1

FROM ((((({Entity}    

INNER JOIN {Entitynames} as ENENTITYNAMES ON (ENENTITYNAMES.[Label] = {Entity}.[Name]))     INNER JOIN {Entity_Attr} as ENENTITY_ATTR ON ({Entity}.[SS_Key] = (substring(ENENTITY_ATTR.[Type], (((charindex(N'*', ENENTITY_ATTR.[TYPE]) -1)) + 1) + 1, 100))))     

INNER JOIN {Entity} as ENENTITY_2 ON (ENENTITY_ATTR.[Entity_Id] = ENENTITY_2.[ID]))     

INNER JOIN {Entitynames} as ENENTITYNAMES_2 ON (ENENTITY_2.[NAME] = ENENTITYNAMES_2.[LABEL]))     

INNER JOIN {Entity_Attr} as ENENTITY_ATTR_2 ON ((ENENTITY_2.[ID] = ENENTITY_ATTR_2.[ENTITY_ID])    AND (ENENTITY_2.[PRIMARYKEY_SS_KEY] = ENENTITY_ATTR_2.[SS_KEY]))) 

WHERE ([ENENTITYNAMES].[IS_ACTIVE] = 1)  AND ((ENENTITYNAMES.[ID] = @EntityNameId) AND ([ENENTITYNAMES].[ID] IS NOT NULL))    AND (({Entity}.[Espace_Id] = @EspaceId) AND ({Entity}.[Espace_Id] IS NOT NULL))

We have a static entity called {Entitynames} in this static we added a the entities we use in the application