View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [API] Problem with URL encoding - ProjeQtOr
 

[API] Problem with URL encoding

More
24 Jul 2023 13:45 #1 by rafall92
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)

Please Log in or Create an account to join the conversation.

More
24 Jul 2023 13:59 #2 by Plucks
Hello,

In case your document name has a '+' in its name, your may try to replace it by its HTML entity while searching your document ?
'
+
'
 

Please Log in or Create an account to join the conversation.

More
24 Jul 2023 14:13 #3 by rafall92
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

Please Log in or Create an account to join the conversation.

More
24 Jul 2023 14:43 #4 by babynus
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)

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.038 seconds

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.