Author Topic: Folder Field Definitions with Spaces  (Read 2625 times)

ODCoder

  • Guest
Folder Field Definitions with Spaces
« on: March 08, 2019, 02:10:19 AM »
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

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1002
    • View Profile
Re: Folder Field Definitions with Spaces
« Reply #1 on: March 08, 2019, 03:53:11 AM »
with which technology? Java API?

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

#Install #Migrations #Conversion #Educate #Repair #Upgrade #Migrate #Enhance #Optimize #AIX #Linux #Multiplatforms #DB2 #Windows #Oracle #TSM #Tivoli #Performance #Audits #Customizing #Availability #HA #DR #JavaApi #ContentNavigator #ICN #WEBi #ODWEK #Services #PDF #AFP #XML

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2219
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Folder Field Definitions with Spaces
« Reply #2 on: March 08, 2019, 06:01:17 AM »
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.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

ODCoder

  • Guest
Re: Folder Field Definitions with Spaces
« Reply #3 on: March 12, 2019, 02:15:55 AM »
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

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2219
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Folder Field Definitions with Spaces
« Reply #4 on: March 12, 2019, 07:35:51 AM »
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.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

ODCoder

  • Guest
Re: Folder Field Definitions with Spaces - Answered
« Reply #5 on: March 12, 2019, 09:50:20 AM »
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.