Return Return     Main page Main page      Update Update     Online help Online help     Monitoring with a Rich Desktop Application Desktop     Choice of period :  Day Day  Week Week  Month Month  Year Year  All All  Customized Customized


           (m/d/yy)     



Usages of SELECT key, type, cast(data->'header'->>'version' as text) as version, cast(data->'header'->>'endsDate' as date) as periodo, cast(data->'header'->>'endsDate' as date) as periodoFinal, cast(data->'header'->>'startsDate' as date) as periodoInicial, CASE WHEN data->'header'->>'indNatPj' <> '' THEN cast(data->'header'->>'indNatPj' as numeric) END as indicadorNaturezaPessoaJuridica, cast(data->'header'->>'ecdType' as text) as ecdType, cast(data->'header'->>'finalType' as text) as purpose, name_file as nameFile, cnpj, cast(data->'header'->>'deliveryDate' as timestamp) as deliveryDate FROM document WHERE cnpj = ? AND (data->'header'->>'endsDate') BETWEEN ? AND ? AND type = ?

RequestFind usages
spring  graphDocumentService.consultarSpedsPorCnpjPeriodoTipo Find usages