Project

General

Profile

Anomalie #13455

[bannette] La clause SQL de la bannette des courriers en copie est refusée par sécurité

Added by Laurent GIOVANNONI about 2 years ago. Updated 11 months ago.

Status:
Clôturée
Priority:
0-Bloquant
Assignee:
Target version:
Backlogs Produits - Inscription Backlog
Start date:
03/05/2020
Due date:
Tags Courrier:

Description

La clause SQL de la bannette des courriers en copie est refusée à cause du mot clé "copy" par sécurité.
~~~ sql
(res_id in
(select res_id from listinstance WHERE item_type = 'user_id' and item_id = @user and item_mode = 'copy')
or res_id in (
select res_id from listinstance WHERE item_type = 'entity_id' and item_mode = 'copy' and item_id in (@my_entities)
)
) and status not in ( 'DEL', 'END', 'SSUITE')
and res_id not in (select res_id from res_mark_as_read WHERE user_id = @user);


  

History

#1 Updated by Laurent GIOVANNONI about 2 years ago

  • Status changed from A traiter to Résolue

Finalement c'est 'cc' qu'il faut mettre dans la clause SQL

#2 Updated by Emmanuel DILLARD about 2 years ago

  • Status changed from Résolue to Clôturée
  • Target version changed from 20.03 (Support restreint) to Inscription Backlog Courrier

#3 Updated by Emmanuel DILLARD 11 months ago

  • Project changed from Backlog to Backlog Courrier
  • Target version changed from Inscription Backlog Courrier to Inscription Backlog

Also available in: Atom PDF