Hello everyone,
I'm trying to search a folder, using SQL Search. One of the folder properties is called "Customer Number", not the space in the middle.
In my search, I can use
where Name = 'Test User'
with no problems. However, if there is a space, it causes issues, and I cant seem to figure it out.
where Customer Number = 1234
I have tried with quotes, brackets, square brackets, single quotes, removing the space etc. Any idea's please?
Thank you.
with which technology? Java API?
Have you tried with the ag field name instead of the folder field name?
Just confirming what Alessandro said - you'll need to use the AG Field names if you're going to send raw SQL. Otherwise you use the API calls to do your searches.
Apologies for my late response!
Huge thank you, that worked a treat. I should have realised it was the AG fields, that the folder was just a view and display names. Almost done, 1 last issue which I will post now. Great forum and community, been reading loads!
Regards
DB
Hi DB. :)
I'm glad to hear you're getting so much from the forums. Don't forget to give back, and update your questions with the ultimate solutions, etc.
-JD.
That's Justin.
Answer to the initial question:-
Use the application group's field definitions, instead of the folder field definitions. In my example, Customer_Name not Customer Name.