Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

How can I reduce the number of projects shown for Clarity in Hub?

  1. Last updated
  2. Save as PDF

Last Updated: 30   |  Applicable Hub Versions: All

Answer

If you have hundreds or thousands of projects in Broadcom Clarity, it could be difficult to choose the project that you would like to integrate due to the long list and you may run into Java Heap Space problems or an OutOfMemoryError when trying to retrieve the projects as the set is so large. The number of projects returned can easily be reduced by modifying the TTSyncQuery_GetProjects NSQL on the Broadcom Clarity Server. As an example, you could have a whitelist of internal project IDs that you would like to expose to Hub (say project id 12345, 32154 and 54235). In this case, you could add an additional clause to the WHERE statement of the NSQL to just return these projects:

 SELECT   @SELECT:DIM:USER_DEF:IMPLIED:PRJ:P.PRID:tt_ProjectInternalID@,       

@SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PREXTERNALID:tt_ProjectExternalID@,       

@SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRNAME:tt_ProjectName@,       

@SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRUID:tt_ProjectUID@,        

@SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRGUIDELINES:tt_ProjectGUIDELINES@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRDEPARTMENT:tt_ProjectDEPARTMENT@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRVERSION:tt_ProjectVERSION@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRUSERTEXT6:tt_ProjectUSERTEXT6@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRUSERTEXT7:tt_ProjectUSERTEXT7@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRBUDGET:tt_ProjectBUDGET@,       

@SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRSTART:tt_ProjectSTART@,       

@SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRASOF:tt_ProjectASOF@,       

@SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRFINISH:tt_ProjectFINISH@,        

@SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRCPMTYPE:tt_ProjectCPMTYPE@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRTRACKMODE:tt_ProjectTRACKMODE@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRISOPEN:tt_ProjectISOPEN@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRCHARGECODEID:tt_ProjectCHARGECODEID@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRSPONSOREDBY:tt_ProjectSPONSOREDBY@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRREQUESTEDBY:tt_ProjectREQUESTEDBY@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRREQUESTEDTIME:tt_ProjectREQUESTEDTIME@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRAPPROVEDTIME:tt_ProjectAPPROVEDTIME@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRUSERTEXT1:tt_ProjectUSERTEXT1@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRUSERTEXT2:tt_ProjectUSERTEXT2@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRUSERTEXT3:tt_ProjectUSERTEXT3@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRUSERTEXT4:tt_ProjectUSERTEXT4@,        

@SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRFORMAT:tt_ProjectFORMAT@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRFISCALSTART:tt_ProjectFISCALSTART@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRUSERTEXT5:tt_ProjectUSERTEXT5@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRPCTCOMPLETE:tt_ProjectPCTCOMPLETE@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRPRIORITY:tt_ProjectPRIORITY@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRCLOSEDTIME:tt_ProjectCLOSEDTIME@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRUSERNAME:tt_ProjectUSERNAME@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRSIZEADJUST:tt_ProjectSIZEADJUST@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRSIZEADJUSTON:tt_ProjectSIZEADJUSTON@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRSTARTIMPOSED:tt_ProjectSTARTIMPOSED@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRFINISHIMPOSED:tt_ProjectFINISHIMPOSED@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRBASESTART:tt_ProjectBASESTART@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRBASEFINISH:tt_ProjectBASEFINISH@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRBASETIME:tt_ProjectBASETIME@,       

@SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRMODBY:tt_ProjectMODBY@,        

@SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRMODTIME:tt_ProjectMODTIME@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.PRDESCRIPTION:tt_ProjectDESCRIPTION@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:P.IS_ACTIVE:tt_ProjectIS_ACTIVE@,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:PRJ:I.ASSGN_POOL:tt_ProjectASSGN_POOL@ FROM     PRPROJECT P,        INV_INVESTMENTS

IWHERE    P.PRID = I.IDAND      P.PRID IN (12345, 32154, 54235)AND      @FILTER@ 

Alternatively, you could consider a custom field on the project level that says that the project should be available to Hub and this could be used as a part of the NSQL query to scope the number of projects returned.