Folder Field Definitions with Spaces

[ODCoder]

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

Code: [Select]

where Name = 'Test User'
 with no problems.  However, if there is a space, it causes issues, and I cant seem to figure it out.

Code: [Select]

where Customer Number = 1234
I have tried with quotes, brackets, square brackets, single quotes, removing the space etc.  Any idea's please?


Thank you.

[Alessandro Perucchi]

with which technology? Java API?

Have you tried with the ag field name instead of the folder field name?

[Justin Derrick]

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.

[ODCoder]

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

[Justin Derrick]

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.

[ODCoder]

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.