>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #3091184. --> Reported by: [tim.weyand](https://www.drupal.org/user/2855389) >>> <p>Hi,<br> currently all created (workflow) content is displayed in the kanban view. </p> <p>I added a filter "Date range" which will, reduce the resultset (into the past), available Options are: </p> <ul> <li>1 Day</li> <li>7 Days</li> <li>30 Days</li> <li>90 Days</li> <li>1 Year</li> </ul> <p>There is a Setting Options and an Filter Option available. Filter Option is weighted higher then the Kanban Settings Option.</p> <p>However there might arise a problem from the Query Building on high volume sites, since the sql query gets all entity ids for a workflow and adds it in the sql array. Is it possible to refactor the sql so that the workflow entities are a part of the query? </p> <p><strong>SQL</strong></p> <pre>SELECT nfd.nid AS nid, nfd.title AS title, nfd.created AS created, nfd.status AS status, nfd.type AS type, ufd.name AS username, nfd.uid AS uid<br>FROM<br>{node_field_data} nfd<br>INNER JOIN {users_field_data} ufd ON nfd.uid = ufd.uid<br>WHERE (nfd.nid IN ('202440', '202446', '202458', '202464', '202470', '30940', '202392', '202476', '202482', '130', '29389',[...])) AND (nfd.created &gt;= '1569854491')<br>ORDER BY nfd.publish_on ASC</pre>