Answers.Body: <p>Where did you get this <code>id NOT 874</code> syntax? I don't think that's supported. Entry fields already allow you to serach for related entries by ID, so one of those should work:</p>
  <pre><code>{% set myMoviesExceptJaws = entry.myFilmography.movies(['not', 574]).all() %}
  
  {% set myMoviesExceptJaws = entry.myFilmography.movies('not 574').all() %}
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-08-02T08:24:50.933Z
Answers.LastActivityDate: 2021-09-15T07:28:47.140Z
Answers.LastEditDate: 2021-09-15T07:28:47.140Z
Answers.UserDisplayName: MoritzLost
Body: <p>I can't quite figure out how to make this work:</p>
  <p>Say I have two sections, Actors and Movies.</p>
  <p>In my Actor section, I've got a Super Table field (myFilmography) with an Entries column to choose a single entry from the Movies section.</p>
  <p>On a given actor's page, I'd like to output the contents of the Super Table, excluding rows containing a match for a given movie(s).</p>
  <p>I've tried filtering on the id of the movie's entry, like this, but it doesn't seem to work:</p>
  <pre><code>{% set myMoviesExceptJaws = entry.myFilmography.movies('id NOT 874').all() %}
  </code></pre>
  <p>How do I filter out rows containing specific entries?</p>
  
Tags: <plugin-supertable>
Title: How to exclude Super Table rows matching given entry
ThreadText: # How to exclude Super Table rows matching given entry
  
  (Asked by: username_0 on 2021-07-30)
  
  I can't quite figure out how to make this work:
  
  Say I have two sections, Actors and Movies.
  
  In my Actor section, I've got a Super Table field (myFilmography) with an Entries column to choose a single entry from the Movies section.
  
  On a given actor's page, I'd like to output the contents of the Super Table, excluding rows containing a match for a given movie(s).
  
  I've tried filtering on the id of the movie's entry, like this, but it doesn't seem to work:
  
  ```
  {% set myMoviesExceptJaws = entry.myFilmography.movies('id NOT 874').all() %}
  
  ```
  
  How do I filter out rows containing specific entries?
  
  **Tags:** plugin-supertable
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2021-08-02. Score: 2 | Accepted answer
  
  Where did you get this `id NOT 874` syntax? I don't think that's supported. Entry fields already allow you to serach for related entries by ID, so one of those should work:
  
  ```
  {% set myMoviesExceptJaws = entry.myFilmography.movies(['not', 574]).all() %}
  
  {% set myMoviesExceptJaws = entry.myFilmography.movies('not 574').all() %}
  
  ```
  
  
  ---
  
  