Marcações ponto não integram da Joinin para Senior
Problema: Marcações ponto não integram da Joinin para Senior
Consultado via banco de dados qual erro consta:
select para trazer 50 marcações
SELECT
users.id,
record.record_hour,
users.uid,
users.identification_number,
users.name,
integration_return_message
FROM
employee_journey_records record
INNER JOIN
users ON users.id = record.user_id
INNER JOIN
accounts ON accounts.id = record.account_id
WHERE
record.employee_journey_id IS NOT NULL
AND users.id IS NOT NULL
AND users.identification_number IS NOT NULL
AND users.active IS TRUE
AND record.integration_situation = 1
AND record.status = 1
AND record.origin = 1
AND record.active IS TRUE
AND record.imported IS FALSE
AND (
record.record_hour > accounts.employee_journey_block_day
OR accounts.employee_journey_block_day IS NULL
)
AND EXISTS (
SELECT 1
FROM web_services ws
WHERE
ws.account_id = record.account_id
AND ws.wsdl IS NOT NULL
AND ws.web_service_type IN (11, 24)
)
ORDER BY
record.id ASC
LIMIT 50;
Erro null: versão webservice travada
Resolve: TI Senior - apartir versão 6.10.4.116