For each Content Type display number of nodes that have value on each CT's fields

Just for reference, this code returns the nodes of a certain content type that have value (not null) on a given field:

$ct_name = "theContentType";
$field_name = "theField";
$node_storage = \Drupal::entityTypeManager()->getStorage('node');

$nids = $node_storage->getQuery()->condition($field_name, NULL, "IS NOT NULL")->condition("type", $ct_name)->execute();

$nodes = $node_storage->loadMultiple($nids);

Why do this only for nodes when we can do it for all fieldable entities?

Hello @Tuni, yes, this is indeed a very interesting and useful functionality for detecting fields that are not in use and thus being able to simplify the content architecture.

I just want to add a clarification to the description of the functionality: in a first iteration, at least, this check should be performed only on fields that are not basic fields of the entity. Since these are the fields that can be eliminated, and also we would reduce the amount of information in the report, resulting in something more manageable and useful.

Ok to start with fields that are not basic fields of entities.

Status

First approach completed.

It has been implemented for the case of nodes. However, it would be advisable to implement a batch process since these queries might take some time. In the end, we performed an accounting of the usage of all fields.

It might be worthwhile to create another report from the perspective of the storage

I rebased the branch onto dev.

The report is working for me and I find it useful as is.

As an additional feature request, I'd like to see a % of content per bundle that has the field value. That can be a little more meaningful than the counts alone.

Hello Mortona:

Thank you very much for your collaboration. Yes, it is a good idea to show a statistic about the field usage.

We will include that information.

antonio.nunez → made their first commit to this issue’s fork.

The way nodes are counted has been optimized, and the query has been modified to avoid errors from non-existing fields or tables.