...
Search declarations in IL_DB.declaration_requests to prevent requests duplication:
For ONLINEOTP verification
- if tax_id is not null
| Code Block | ||
|---|---|---|
| ||
WHERE IL_DB.declaration_requests.data.declaration_request.person.tax_id = :($.declaration_request.person.tax_id)
AND IL_DB.declaration_requests.data.declaration_request.person.authentication_methods.phone_number = :($.declaration_request.person.authentication_methods.phone_number)
AND IL_DB.declaration_requests.status IN ('NEW', 'APPROVED') |
...
| Code Block |
|---|
WHERE IL_DB.declaration_requests.data.declaration_request.person.documents.number = :($.declaration_request.person.documents.number)
AND IL_DB.declaration_requests.data.declaration_request.person.authentication_methods.phone_number = :($.declaration_request.person.authentication_methods.phone_number)
AND IL_DB.declaration_requests.status IN ('NEW', 'APPROVED') |
For OFFLINEOFFLINE verification
- if tax_id is not null
| Code Block | ||
|---|---|---|
| ||
WHERE IL_DB.declaration_requests.data.declaration_request.person.tax_id = :($.declaration_request.person.tax_id)
AND IL_DB.declaration_requests.data.declaration_request.person.documents.number = :($.declaration_request.person.documents.number)
AND IL_DB.declaration_requests.status IN ('NEW', 'APPROVED') |
...