Good morning everyone, I need help related to the SQL Database Connector!

[Domingos_Dias]

I’m using the sql database connector to query a table with around 600 rows of information
my query is as follows:
SELECT TOP (900) [$PPRPROF],[$PPRDESC] FROM [ODS].[RAW_DATA].[PROMOF0005_$PPROF]
But I have just over 100 lines of information in the return
Can anyone tell me why?

[jroques]

Hey @Domingos_Dias ,

Thanks for using Camunda and the SQL Connector

Could you try using profissaoList[850] for instance and a script task, I think this variable contains all the results but it’s not displayed properly in Operate.

Let me know if that worked

[Domingos_Dias]

@jroques

profissaoList[850]

Good morning @jroques
You’re right, in fact it was a question of the operator’s own impression, Thks!