Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

[API] Problem with ...
 
Notifications
Clear all

[API] Problem with URL encoding

4 Posts
3 Users
0 Reactions
1,229 Views
Rafal
(@rafall92)
Posts: 10
Active Member
Topic starter
 
[#8977]

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)


 
Posted : 24 Jul 2023 15H45
(@cecile)
Posts: 161
Active Member Admin
 

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 ?
'

 + 

'
 


 
Posted : 24 Jul 2023 15H59
Rafal
(@rafall92)
Posts: 10
Active Member
Topic starter
 

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


 
Posted : 24 Jul 2023 16H13
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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)


 
Posted : 24 Jul 2023 16H43
Share:

Scroll to Top