Answers.Body: <p>Have you tried the syntax for one status rather than an array?</p>
  
  <pre><code>{% set submissions = craft.freeform.submissions({
        form: formHandle,
        status: "open",
  }) %}
  </code></pre>
  
  <p>Ref: <a href="http://docs.solspace.com/craft/freeform/v2/template-functions/freeform.submissions.html#param-status" rel="nofollow noreferrer">http://docs.solspace.com/craft/freeform/v2/template-functions/freeform.submissions.html#param-status</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-06-22T21:16:19.880Z
Answers.Text: Thanks John, no tried that I don't understand why its throwing an error:
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sub_freeform_statuses.handle' in 'where clause'
Answers.UserDisplayName: Kev N
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-06-22T22:17:22.180Z
Answers.Text: Actually I used
  {{ submission.toadProfile }} not {{ submission.toadProfile.value }}   syntax and now all good cheers
Answers.UserDisplayName: Kev N
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-06-22T08:32:40.987Z
Answers.LastActivityDate: 2019-06-22T08:32:40.987Z
Answers.UserDisplayName: John Henry Donovan
Body: <p>I'm using this code in my template</p>
  
  <pre><code>{% set formHandle = 'toad' %}
                           {% set submissions = craft.freeform.submissions({
                                form: formHandle,
                              status: ["open"],
                           }) %}
  
                           {# &lt;h3&gt;Submissions for {{ form.name }}&lt;/h3&gt; #}
  
  
                           {% if submissions is empty %}
                           &lt;h4&gt;There are no submissions&lt;/h4&gt;
  
                           {% else %}
  
                           &lt;table class="table"&gt;
  
                                &lt;thead&gt;
                                     &lt;tr&gt;
                                          {% set myfield = (submissions|first).fieldMetadata.status('open) %}
  
                                          &lt;th&gt;{{ myfield.toadName.label }}&lt;/th&gt;
                                          &lt;th&gt;{{ myfield.toadProfile.label }}&lt;/th&gt;
                                     &lt;/tr&gt;
                                &lt;/thead&gt;
  
                                &lt;tbody&gt;
  
                                     {% for submission in submissions %}
                                     &lt;tr&gt;
                                          &lt;td&gt;
                                               {{ submission.toadName.value }}   
                                          &lt;/td&gt;
  
                                          &lt;td&gt;
                                               {{ submission.toadProfile.value }}   
                                          &lt;/td&gt;
                                     &lt;/tr&gt;
                                     {% endfor %}
  
                                &lt;/tbody&gt;
  
                           &lt;/table&gt;
  
                           {% endif %}
  </code></pre>
  
  <p>But get the error:</p>
  
  <pre><code>Error Info: Array
  (
      [0] =&gt; 42S22
      [1] =&gt; 1054
      [2] =&gt; Unknown column 'sub_freeform_statuses.handle' in 'where clause'
  )
  ↵
  Caused by: PDOException
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sub_freeform_statuses.handle' in 'where clause'
  </code></pre>
  
  <p>Is it possible to show just form entries with an open status only? without
   status: ["open"],
  the template works fine</p>
  
Tags: <plugin-freeform>
Title: Display freeform entries with a status on open – on the front end
ThreadText: # Display freeform entries with a status on open – on the front end
  
  (Asked by: username_0 on 2019-06-21)
  
  I'm using this code in my template
  
  ```
  {% set formHandle = 'toad' %}
                           {% set submissions = craft.freeform.submissions({
                                form: formHandle,
                              status: ["open"],
                           }) %}
  
                           {# <h3>Submissions for {{ form.name }}</h3> #}
  
                           {% if submissions is empty %}
                           <h4>There are no submissions</h4>
  
                           {% else %}
  
                           <table class="table">
  
                                <thead>
                                     <tr>
                                          {% set myfield = (submissions|first).fieldMetadata.status('open) %}
  
                                          <th>{{ myfield.toadName.label }}</th>
                                          <th>{{ myfield.toadProfile.label }}</th>
                                     </tr>
                                </thead>
  
                                <tbody>
  
                                     {% for submission in submissions %}
                                     <tr>
                                          <td>
                                               {{ submission.toadName.value }}   
                                          </td>
  
                                          <td>
                                               {{ submission.toadProfile.value }}   
                                          </td>
                                     </tr>
                                     {% endfor %}
  
                                </tbody>
  
                           </table>
  
                           {% endif %}
  
  ```
  
  But get the error:
  
  ```
  Error Info: Array
  (
      [0] => 42S22
      [1] => 1054
      [2] => Unknown column 'sub_freeform_statuses.handle' in 'where clause'
  )
  ↵
  Caused by: PDOException
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sub_freeform_statuses.handle' in 'where clause'
  
  ```
  
  Is it possible to show just form entries with an open status only? without
  status: ["open"],
  the template works fine
  
  **Tags:** plugin-freeform
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-06-22. Score: 1 | Accepted answer
  
  Have you tried the syntax for one status rather than an array?
  
  ```
  {% set submissions = craft.freeform.submissions({
        form: formHandle,
        status: "open",
  }) %}
  
  ```
  
  Ref: <http://docs.solspace.com/craft/freeform/v2/template-functions/freeform.submissions.html#param-status>
  
  > **Comments:**
  > **username_0**: Thanks username_1, no tried that I don't understand why its throwing an error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sub_freeform_statuses.handle' in 'where clause'  
  > **username_0**: Actually I used {{ submission.toadProfile }} not {{ submission.toadProfile.value }}   syntax and now all good cheers  
  
  ---
  
  