Filter for "AttributeLinkedSet" field

[ray]

Hi All,

I hope all of you are well.

I'm using iTop 2.4.0 and I'm trying to apply a filter to a "AttributeLinkedSet" field.

I have created the below field in Ticket class

<field id="is_active_ticket" xsi:type="AttributeEnum" _delta="define">
                    <values>
                        <value id="yes">yes</value>
                        <value id="no">no</value>
                    </values>
                    <sql>is_active_ticket</sql>
                    <default_value>no</default_value>
                    <is_null_allowed>true</is_null_allowed>
                    <display_style>radio_horizontal</display_style>
</field>

And I'm trying to display list of all tickets (i.e. UserRequest, Incident, Change, and Problem) that are assigned to a contact person AND is_active_ticket is 'yes'. However, the filter does NOT seem to work in the "AttributeLinkedSet" field and just display all tickets that are assigned to the person (I have tested the OQL in "Run Queries" and the query filter works in the "Run Queries"). Please find below the sample code

<field id="active_tickets_list" xsi:type="AttributeLinkedSet" _delta="define">
          <linked_class>Ticket</linked_class>
          <filter>SELECT Ticket AS t WHERE t.agent_id = :this->id AND is_active_ticket = 'yes'</filter>
          <ext_key_to_me>agent_id</ext_key_to_me>
          <count_min>0</count_min>
          <count_max>0</count_max>
</field>

Is there something wrong with my code? Or is there any bug/limitation regarding "AttributeLinkedSet" with <filter> (https://sourceforge.net/p/itop/tickets/1760/ AND https://sourceforge.net/p/itop/discussion/922360/thread/cf6026f8/ ) in iTop 2.4.0? Is there any workaround?</filter>

NOTE on workaround:
1. It seems that for FunctionalCI class there's active tickets field and it will only display tickets that are NOT in "closed" state. But I can't seem to find the code to do this there's only this in datamodels/2.x/itop-config-mgmt Class:FunctionalCI/Tab:OpenedTickets in the datamodel and Class:FunctionalCI/Tab:OpenedTickets' => 'Active Tickets.
$oPage->SetCurrentTab(Dict::S('Class:FunctionalCI/Tab:OpenedTickets').$sCount);

1. Possibly a workaround is to apply filter to datatables in client-side since iTop table uses datatables but I haven't tried this

   Thank you and I look forward to hearing from you.

[Vincent @ Combodo]

That filter was planned to be coded one day and it is still not coded as it's mentioned in recent version of the documentation:
Not used by iTop for now! OQL query to define objects to which the current object can be linked. It's the counterpart of the //filter// on the corresponding ExternalKey.
I have no solution for you with iTop version 2.4. The best response to your need is the AttributeDashboard brought by version 2.6, and if you upgrade, take the 2.7 at least it will be maintained with security fix for at least 2 more years from now.

[ray]

Hi Vincent,

Thank you very much for the recommendation.

Managed to get this to work on iTop 2.4.0 by reverse engineering the code in itop-config-mgmt/datamodel.itop-config-mgmt.xml FunctionalCI class Tab:OpenedTickets.

For those who are interested, please find below the code snippet
datamodel.xml

<?xml version="1.0" encoding="UTF-8"?>
<itop_design xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0">
  <constants>
  </constants>
  <classes>
    <class id="Person">

      <methods>
        <method id="DisplayBareRelations" _delta="define">
          <static>false</static>
          <access>public</access>
          <type>Overload-cmdbAbstractObject</type>
          <code><![CDATA[   function DisplayBareRelations(WebPage $oPage, $bEditMode = false)
                {
                  // TODO: Update the WHERE condition as required when iterating through Ticket subclasses (i.e. UserRequest, Incident, Change, Problem) in $oSearch
                  $queryWhereCondition = "t.agent_id = :myself AND t.is_active_ticket = 'yes' AND t.operational_status = 'ongoing'";

                  parent::DisplayBareRelations($oPage, $bEditMode);

                  $sTicketListAttCode = 'tickets_list';

                  if (MetaModel::IsValidAttCode(get_class($this), $sTicketListAttCode))
                  {
                    // Display one list per leaf class (the only way to display the status as of now)
                    // i.e. UserRequest, Incident, Change, and Problem

                    $iTotal = 0;
                    $aSearches = array();

                    foreach (MetaModel::EnumChildClasses('Ticket') as $sSubClass)
                    {
                      if (!MetaModel::HasChildrenClasses($sSubClass))
                      {
                        $sStateAttCode = MetaModel::GetStateAttributeCode($sSubClass);
                        if ($sStateAttCode != '')
                        {
                          $oSearch = DBSearch::FromOQL("SELECT $sSubClass AS t WHERE $queryWhereCondition", array('myself' => $this->GetKey()));
                          $aSearches[$sSubClass] = $oSearch;

                          $oSet = new DBObjectSet($oSearch);
                          $iTotal += $oSet->Count();
                        }
                      }
                    }

                    $sCount = ($iTotal > 0) ? ' ('.$iTotal.')' : '';
                    $oPage->SetCurrentTab(Dict::S('Class:Person/Tab:OpenedTickets').$sCount);

                    foreach ($aSearches as $sSubClass => $oSearch)
                    {
                      $sBlockId = __class__.'_opened_'.$sSubClass;

                      $oPage->add('<fieldset>');
                      $oPage->add('<legend>'.MetaModel::GetName($sSubClass).'</legend>');
                      $oBlock = new DisplayBlock($oSearch, 'list', false);
                      $oBlock->Display($oPage, $sBlockId, array('menu' => false));
                      $oPage->add('</fieldset>');
                    }
                  }
                }]]>
          </code>
        </method>
      </methods>

    </class>
  </classes>
  <menus>
  </menus>
  <user_rights>
    <groups>
    </groups>
    <profiles>
    </profiles>
  </user_rights>
</itop_design>

dictionary.xml

<?php

Dict::Add('EN US', 'English', 'English', array(
    // Dictionary entries go here

    'Class:Person/Tab:OpenedTickets' => 'Active Tickets',
));
?>