Finding items without a category

Lita Gribben
Lita Gribben Member, Data Exchange, Jama Connect Interchange™ (JCI) Posts: 90
edited March 13 in Peer-to-Peer Support Forum

We are trying to find items in a project that don't have a category assigned to them. The advanced filters allow us to find items where category "is equal to" or "is not equal to" a specific category, but it doesn't let us find items that don't have any categories assigned, unless we enter multiple conditions of "is not equal to" and then add one per category that we have in the project, and this list can be long. There is no option to choose "is empty". 

Does anyone have a workaround for this? or should we just submit this as an idea?

------------------------------
Lita Gribben
Blue Origin
------------------------------

Comments

  • Alessandro Valli
    Alessandro Valli Member, Data Exchange, Jama Connect Interchange™ (JCI) Posts: 789
    edited March 1

    My workaround for tags is keywords contains !tags:*
    It seems not to work for categories ... or I do not know to write the "keyword" -> there is a feature request for this : need the way to specify a category (path) in an advanced filter via keyword rule

    ------------------------------
    Alessandro
    Systems Engineer
    SICK AG
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 03-01-2024 07:35
    From: Lita Gribben
    Subject: Finding items without a category

    We are trying to find items in a project that don't have a category assigned to them. The advanced filters allow us to find items where category "is equal to" or "is not equal to" a specific category, but it doesn't let us find items that don't have any categories assigned, unless we enter multiple conditions of "is not equal to" and then add one per category that we have in the project, and this list can be long. There is no option to choose "is empty". 

    Does anyone have a workaround for this? or should we just submit this as an idea?

    ------------------------------
    Lita Gribben
    Blue Origin
    ------------------------------
    Alessandro
    Systems Engineer
    SICK AG
  • Iwan Kutter
    Iwan Kutter Member Posts: 26
    edited March 4

    Hello

    our workaround is to use a context sensitive velocity report with a link back to Jama Connect as search term (as attachment also the complete report with better formatting): 

    #set( $docus = $documentSource)
    #set( $jamaProjectURL = $baseUrl + "/perspective.req#/items/")
    #set( $searchURL = $baseUrl + "/perspective.req#/search?term=" )
    #set( $api_ids = [] )
    #set( $quote = '"' )
    <html>
    <body>
    <table>
    	<thead><tr>
    		<th>Requirement</th>
    		<th>Name</th>
    	</tr></thead>
    <tbody>	
    #foreach( $vDoc in $documentList )
    	#set( $doc = $vDoc.document )
    	#set( $categories = [])
    	#set( $categories = $docus.getAllCategoryPathsByDocumentId( $doc.id ))
    	#if( $categories.size() == 0 )
    		<tr><td><a href='$jamaProjectURL$doc.id.toString()?projectid=$project.id.toString()' target='_blank'>$doc.id.toString(): $doc.documentKey</td>
                    <td>$doc.name</td>
    		</tr>
    		#if( $api_ids.add( $doc.id.toString()) ) #end
    	#end
    #end
    </tbody></table>
    #foreach( $api_id in $api_ids )
    	#set( $searchURL = $searchURL + "id:${quote}$api_id${quote}" )
    	#if( $foreach.hasNext )
    		#set( $searchURL = $searchURL + " " ) 
    	#else
    		#set( $searchURL = $searchURL + "&scope=PROJECT&projectId=" + $project.id.toString() )
    	#end
    #end
    <p><a href='$searchURL$' target='_blank'>Open Requirements in Jama Connect</a></p>
    </body>
    </html>
    ------------------------------
    Iwan Kutter
    Requirement Engineer
    Bernina International
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 03-01-2024 07:35
    From: Lita Gribben
    Subject: Finding items without a category

    We are trying to find items in a project that don't have a category assigned to them. The advanced filters allow us to find items where category "is equal to" or "is not equal to" a specific category, but it doesn't let us find items that don't have any categories assigned, unless we enter multiple conditions of "is not equal to" and then add one per category that we have in the project, and this list can be long. There is no option to choose "is empty". 

    Does anyone have a workaround for this? or should we just submit this as an idea?

    ------------------------------
    Lita Gribben
    Blue Origin
    ------------------------------
    Iwan Kutter
    Requirement Engineer
    Bernina International