Setting up default filter for entity Account

[greenbits]

Hello,
I have added the boolean field cHidden to the entity Account.
In list view I only want to show accounts which are not hidden.
I have added a primary filter to select only active records, but still all records are shown.
What am I doing wrong?

Following this post https://forum.espocrm.com/forum/deve...-espocrm-7-0-x I have setup the following:

/custom/Espo/Custom/Select/Account/PrimaryFilters/Active.php

<?php

namespace Espo\Custom\Select\Account\PrimaryFilters;

use Espo\Core\Select\Primary\Filter;
use Espo\ORM\Query\SelectBuilder;

class Active implements Filter
{
public function apply(SelectBuilder $queryBuilder): void
{
$queryBuilder->where([
'cHidden' => false,
]);
}
}

/custom/Espo/Custom/Resources/metadata/selectDefs/Account.json

{
"primaryFilterClassNameMap": {
"active": "Espo\\Custom\\Select\\Account\\PrimaryFilters\\Active"
}
}

/custom/Espo/Custom/Resources/metadata/clientDefs/Account.json

{
"filterList": [
{
"name": "active"
}
]
}

/custom/Espo/Custom/Resources/i18n/de_DE/Account.json

{
"presetFilters": {
"active": "active"
}
}​

[ChrisSka83]

Have you tried this?
So with Classes

namespace Espo\Custom\Classes\Select\Account\PrimaryFilters;​ 

[ChrisSka83]

I just saw that you have a different folder structure.
Normally there is a Classes folder between custom\Espo\custom and Select.

[greenbits]

Yes, I tried this. I moved the filter to the directory /custom/Espo/Custom/Classes/Select/Account/PrimaryFilters/Active.php and changed the namespace. In /custom/Espo/Custom/Ressources/metadata/selectDefs/Account.json I adjusted the path, but the filter still does not work.

[radek]

Could it be the double S in Ressources? Try "Resources" in your folder structure instead.

[greenbits]

Sorry, that was a misspelling in my question. The folder name is Resources.

[greenbits]

I finally managed to setup the default filter. This is how it works:


/custom/Espo/Custom/Classes/Select/Account/PrimaryFilters/Active.php

<?php
namespace Espo\Custom\Classes\Select\Account\PrimaryFilters;
use Espo\Core\Select\Primary\Filter;
use Espo\ORM\Query\SelectBuilder;
class Active implements Filter
{
    public function apply(SelectBuilder $queryBuilder): void
    {
        $queryBuilder->where([
            'cHidden' => false,
        ]);
    }
}​

/custom/Espo/Custom/Classes/Select/Account/PrimaryFilters/Inactive.php

<?php
namespace Espo\Custom\Classes\Select\Account\PrimaryFilters;
use Espo\Core\Select\Primary\Filter;
use Espo\ORM\Query\SelectBuilder;

class Inactive implements Filter
{
    public function apply(SelectBuilder $queryBuilder): void
    {
        $queryBuilder->where([
            'cHidden' => true,
        ]);
    }
}​​

/custom/Espo/Custom/Resources/metadata/selectDefs/Account.json

{
  "primaryFilterClassNameMap": {
    "active": "Espo\\Custom\\Classes\\Select\\Account\\PrimaryFilters\\Active",
    "inactive": "Espo\\Custom\\Classes\\Select\\Account\\PrimaryFilters\\Inactive"
  }
}​​

/custom/Espo/Custom/Resources/metadata/clientDefs/Account.json

{
  "defaultFilterData": {
    "primary": "active"
  },
  "selectDefaultFilters": {
    "filter": "active"
  },
  "filterList":[
    {
      "name":"active"
    },
    {
      "name":"inactive"
    }
  ]
}​​

There is no need to edit /custom/Espo/Custom/Resources/i18n/de_DE/Account.json.