The community of Analytics developers are invited to follow and participate in the developer network.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.

DQL Query to count a specific folder shows zero files

Hi,

I'm trying to use the DQL Query below to count files in a specific folder but i get no results (It has files).  I'm actually trying to count all files from "Folder A" to "Folder Z", but i can't use "Descend" in the query because it will count the folders after "Z" also.  Can you tell me what I'm doing wrong, or provide a query that will let me count the files from Folder A through Z and then stop?

select count(*) from dm_document where FOLDER('/Cabinets/Folder/Folder/Folder/Folder A ')


Thank you,

Dj

Comments

Sign In or Register to comment.