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; } } }

dos_extension in documentum

Mayur_shivs

Hello

i am writing a dql for retrieving dos_extension supported by documentum

" select dos_extension, name from dm_format where name in (select distinct full_format from dmr_content);"

in this list i am not getting "jpeg " but when i am firing a query of type

" select distinct dos_extension,name from dm_format;"

i am getting "jpeg" file format but in this query i get lot of duplicate dos_extension , that i dont want so what can i change in my first dql query to get

jpeg file format

Regards

Mayur Mitkari

Find more posts tagged with

Comments

Mayur_shivs

if i am writing DQL Query

" select distinct dos_extension from dm_format " i am getting 238 option now i want to retrieve name of the

format , how my query will change

Regards

matt-medicis

This query may help, but keep in mind that the dos_extensions are not unique. One dos_extension can have many different descriptions. Only name is unique as this is the name of the dm_format that the documents are associated.

select description, name, dos_extension from dm_format where dos_extension <> ' '

-Matt

Mayur_shivs

Hello ,

what will be my possible query for fetching all possible non repeated dos_extension with there names supported by documentum

Regards