PL/SQL

Java

SELECT 
    "ID_MSG_CONTACT", 
    "NAME", 
    "FL_ACTIF", 
    "GROUP", 
    "TEAM", 
    NVL("CODE_USAG_MOD","CODE_USAG_AJT") CODE_USAG_MOD, 
    NVL("DH_MOD","DH_AJT") DH_MOD
FROM 
    "ELE".
    "MSG_CONTACT"
--Ticket 93820
--where groupe in ('1','2','M','P','E','D','A','S','L')
WHERE 
    groupe in ('1','2','M','P','E','D','A','S','L','Z')

@Entity
@Table(name="MSG_CONTACT")
public class MsgContact implements Serializable  {
    @Id
    @GeneratedValue(strategy= GenerationType.IDENTITY)
    @Column(name="ID_MSG_CONTACT", unique=true, able=false, precision=12)
    private BigDecimal idMsgContact;
    @Column(name="NAME", able=false, length=50)
    private String name;
    ...
    @Column(name="DH_MOD")
    private LocalDateTime dhMod;
    @Column(name="FONCTION", length=20)
    private String fonction;

    /** Default constructor*/
    public MsgContact() {
    }

…
@Repository
public interface MsgContactRepository  extends JpaRepository{

	public static final String dbQueryContact = "SELECT c "
		+ "FROM MsgContact c "
		+ "where c.groupe IN ('1','2','M','P','E','D','A','S','L','Z') ";  //JPQL
        //--Ticket 93820 
        //--where groupe in ('1','2','M','P','E','D','A','S','L')

…

Javascript from APEX Link Builder URL field

Javascript converted to regular JS source code

javascript:apex.confirm(
    'Confirmer la suppression de la ligne(s) sélectionnée(s)',
    'MULTI_ROW_DELETE'
);

deleteMsgContacts() {
    this.confirmationService.confirm({
        message: 'Confirmer la suppression de la ligne(s) sélectionnée(s)',
        header: 'Confirmation',
        icon: 'pi pi-exclamation-triangle',
        accept: () => {
            ....
            this.messageService.add({ severity: 'success', summary: 'Réussite', detail: 'Contact(s) supprimé(s).', life: 3000 });
        }
    });
}