DQL Query contains ampersand (&) Symbol

I am using below query to fetch metadata using D2FS. However folder name contains ampersand (&) Symbol and due to this it's not giving me result. Kindly let me know how can i resolve this issue?

select * from gom_engineering where folder ('/CNAEP/GOMBU/Engineering & Operations/MC - Mississippi Canyon(Blind Faith)/650 A - Block 650 Facility A/Engineering',descend)

Comments

  • This forum is for Core Signature, the electronic signature add-on for OpenText Core Share, our cloud content management service. I have taken the liberty of posting to the Documentum forum. Thanks for your post and good luck!

    Jay Weir
    Sr. Communications Specialist
    OpenText

  • The easiest way to solve this is to change the name of the folders (ie replace & with and). I avoid using special characters in folder names for this exact reason.

  • What about submitting the folder's object-id as query criteria?

  • niravmodi
    edited March 19, 2020 #5

    Dear All
    Thanks for your response however we are not able to change & with "and" but when I replacing & with %26 it's working.

  • Just remember - you will have to do that all time you run ANY query with D2FS. select, update, delete, link, etc...