Unable to sort column after applying customization

I need to have a filter in the webtop classic view. Only objects that have 'CURRENT' and 'ACTIVE' in the version attribute need to be displayed.

I tried to change the buildObjectListQuery.java. The query is somethings like '... (all) where ANY r_version_label IN ('ACTIVE','CURRENT')... It works well in version 5.3.

This customization is not working in 6.5. There is an error when I tried to sort column. Any ideas?

Find more posts tagged with

Comments

Francois Dauberlieu

Is it 6.5, 6.5 SP1, 6.5 SP2 ?????

You get an error ??? nice but unfortunately, Documentum doesn't include (yet) a mind reader . If you get an error, maybe you cud let us now what error it is ??

Did you use the buildObjectListQuery.java from 5.3 to put in 6.5 or the 6.5 version of the file (in the first case, that could very well be the source of the problem because there might've been some changes between 5.3 and 6.5)

peckling

This error happens on 6.5 SP1 and 6.5 SP2. I did not test in 6.5.

I am building the class file from DocbaseQueryService.java version 6.5. I did not use the 5.3 java code.

The error will only occur if the display contains two documents from the same version tree. Null pointer error reported. The error details are empty.

Francois Dauberlieu

Can you give use the whole SELECT statement you use ?

peckling

In DocbaseQueryService.java

public static String buildObjectListQuery(String strFolderId, String[] attributes,
boolean bSelectFolders, boolean bSelectObjects, String strObjectType, String strFolderType, boolean bShowAllVersions)

........

.......

           // where folderid...
            if (bShowHiddenObject)
            {
               query.append(QUERY_WHERE_FOLDER_SHOW_HIDDEN_OBJECTS);
            }
            else
            {
              // Added to view 'ACTIVE','CURRENT' & 'ACTIVE-CONTROLLED' documents
          if(bShowAllVersions)
            query.append(QUERY_WHERE_FOLDER);
          else
            query.append("(all) where ANY r_version_label IN ('ACTIVE','CURRENT','ACTIVE-CONTROLLED') and a_is_hidden=false and FOLDER(ID('");

            }

........

.......

Francois Dauberlieu

Usualy, in DQL, when doing a select that includes a repeating attribute, it returns 1 row per value in the repeating attribute, UNLESS, you add the r_object_id in your select statement and in the ORDER BY clause.

for example, let's say you have 1 mydoc object with only 1 version, actually, the values in the version label are 1.0 and CURRENT.

if you do select object_name, r_version label from mydoc

it will return 2 lines

myname 1.0

myname CURRENT

if you do

select r_object_id,object_name,r_version_label from mydoc order by r_object_id

it will return

myname 1.0 CURRENT

There's more information about that in the DQL documentation.