QueryEmployeeIn service not returned all employees !!

[former_member540842]

Hi Experts ,
i try to get all employees by the web service QueryEmployeeIn but it only 100 employee !!
any advice or recommend solution !?

[former_member442609]

Hi Thomas,

I´m facing the same issue - but unfortunately any values in the tags "QueryHitsUnlimitedIndicator" or "QueryHitsMaximumNumberValue" are not showing up all results as well.

Is there any other option I could try?

Thank you!

Best regards
Lena

[thomaskenner]

Hi Basem,

the standard service restricts the results to 100, if you want to have more data sets, you can set the QueryHitsUnlimitedIndicator = 1 (or true) or the QueryHitsMaximumNumberValue to a higher number. Both fields can be found in the ProcessingConditions-node of the query webservice.

Best regards

Thomas

[amauryvanespen]

Good morning Basem Kamal,

which Tool do you use ?

Is there a limitation set in your Integrated Development Environment ?

Is it an SQL statement or a Data Preview ?

Limitation are available in Preference (HANA Studio Desktop) or in a field in Web IDE to set a limited number of rows to return as result.
Regard

Amaury

[former_member540842]

use SOAP UI and this is my request
<glob:EmployeeDataByIdentificationQuery_sync> <!--Optional:--> <EmployeeDataSelectionByIdentification> <!--Zero or more repetitions:--> <SelectionByEmployeeID> <!--Optional:--> <InclusionExclusionCode>I</InclusionExclusionCode> <!--Optional:--> <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode> <!--Optional:--> <LowerBoundaryEmployeeID>*</LowerBoundaryEmployeeID> </SelectionByEmployeeID> <!--Zero or more repetitions:--> </EmployeeDataSelectionByIdentification> <!--Optional:--> <PROCESSING_CONDITIONS> <!--Optional:--> <QueryHitsUnlimitedIndicator>true</QueryHitsUnlimitedIndicator> </PROCESSING_CONDITIONS> </glob:EmployeeDataByIdentificationQuery_sync>