nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

No results when I tried to perform a search query on restapi documentum

mbobbili

http://********************/rest/repositories/********/search?q=keyword&inline=True
I still didnt get any entry even though there is a cabinet with that keyword. Can you help me why this is happening

Find more posts tagged with

Comments

mbobbili

how to perform a search query for a pdf. I know the name of the folder where this pdf is located under a cabinet which i dont know. How to retrieve the pdf using rest api.

Alvaro_de_Andres

youy could try with the dql service:

/?dql=select * from dm_document where folder('');

mbobbili

i tried /?dql=select * from dm_document where folder ("foldername ")
DM_QUERY_E_SYNTAX) [DM_QUERY_E_SYNTAX]error: "A Parser Error (syntax error) has occurred in the vicinity of: select * from dm_document where folder(""

DCTM_Guru

How are you escaping single quote typically used in folder()? Are you using two single quotes or double quote? Have you tried url encoding the single quote?

Alvaro_de_Andres

@mbobbili said:
i tried /?dql=select * from dm_document where folder ("**foldername **")
DM_QUERY_E_SYNTAX) [DM_QUERY_E_SYNTAX]error: "A Parser Error (syntax error) has occurred in the vicinity of: select * from dm_document where folder(""

that should be the full path starting with "/", not a folder name, i.e: folder('/Home Cabinet/folder1')

DCTM_Guru

I think don't think the issue is the path vs folder name, but how does REST service reads single quote.

mbobbili

How to perform a search for a folder in all cabinets using dql . What is the difference between dm_folder and dm_documentum

DCTM_Guru

There is no dm_documentum. There is dm_document. dm_document is document (contains content). dm_folder is just container

mbobbili

so if we want to search for a folder in all the cabinets can i do that using dql? How cabinets are represented in dql

mbobbili

How many tables are present in documentum? is there any pdf contains all these details of tables

bbi

Single quotes, not double:> @mbobbili said:

How to perform a search for a folder in all cabinets using dql . What is the difference between dm_folder and dm_documentum

You would do the same as suggested above, just that you would replace dm_document with dm_folder:

For each cabinet:

select * from dm_folder
where folder ('/cabinetName')

Alvaro_de_Andres

@mbobbili said:
so if we want to search for a folder in all the cabinets can i do that using dql? How cabinets are represented in dql

select * from dm_folder where object_name = 'folder_name'

bbi

My suggestion is much broader and assuming querent does not know exact name of folder.

But if folder name is known Alvaro's suggestion is better.