I'm using this TWIG query:
{% if xpath('md_file','//Archive/DOSSIER_MDPH[contains("#FILENAME#", Identifiant)]') %}{{ xpath('md_file','//Archive/DOSSIER_MDPH[contains("#FILENAME#", Identifiant)]/Personne/LIBLDOMA') }} {% endif %}
Sometimes the value of #FILENAME# includes the ' character (simple quote). When this is the case, I get an error indicating that the request is badly formed. For exemple :
1. {% if xpath('md_file','//Archive/DOSSIER[contains("08 - Fiche d'option.pdf", Identifiant)]') %}{{ xpath('md_file','//Archive/DOSSIER[contains("08 - Fiche d'option.pdf", Identifiant)]/Personne/LIBLDOMA') }} {% endif %}^^^ Unexpected "}"
How do you escape the simple quote? I've tried adding an \ before the #FILENAME# but it doesn't work. I've also tried replacing the " with '.
I finally found the solution: