Hello
I try to automate our process to manage documents. I find a problem with searching documents. When I use seach metod like I cant find any document if I place '%' character before name, when there is no other characters before. E.g. Lets say my document have name SEE ELECTRICAL BUILDING. When i send request to "search/name+like+'SEE+Electrical+BUILDING'" i can find that document, when i use search/name+like+'SEE+Electrical+BUILDING%' i also can find it, but if i use search/name+like+'%SEE+Electrical+BUILDING', there is no document
Also as you can see, we need to use '+' character to mark it as space. We have some document with '+' character in their name. How can we find it use method above(searching document by its name)
Hello
Unfortunately, entities don't work. I can use ASCII references, and if I use %47 instead of G ('SEE+Electrical+BUILDIN%47') , project can be find. But if i replace + character with its reference %2B it does not work. I can replace + character with %2B when i use it like space, and in that situation everything works, but i can't find any solution to escape '+' character. I tried to use \ but it also don't work
Only alternative is to serach for name replace + with _ as in SQL _ will replace one and one only character (opposite to % that will replace 0 to many characters)
En poursuivant votre navigation, vous acceptez le dépôt de cookies tiers destinés au bon fonctionnement et à la sécurisation du site (gestion de session, reCaptcha) et à une analyse statistique anonymisée des accès sur notre site (Google Analytics). Si vous vous inscrivez, les informations que vous fournirez ne seront jamais divulguées à un tiers sous quelque forme que ce soit. En savoir plus
Cookies settings
×
Functional Cookies
Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.
Session
Please login to see yours activities!
Other cookies
Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.