<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>

CC BY-SA 4.0
2019-06-22T21:16:19.880Z
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'
Kev N
CC BY-SA 4.0
2019-06-22T22:17:22.180Z
Actually I used
{{ submission.toadProfile }} not {{ submission.toadProfile.value }}   syntax and now all good cheers
Kev N
CC BY-SA 4.0
2019-06-22T08:32:40.987Z
2019-06-22T08:32:40.987Z
John Henry Donovan
<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>

<plugin-freeform>
Display freeform entries with a status on open – on the front end
# 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"],
                         }) %}

                         {# Submissions for {{ form.name }} #}


                         {% if submissions is empty %}
                         There are no submissions

                         {% else %}

                         

                              
                                   
                                        {% set myfield = (submissions|first).fieldMetadata.status('open) %}

                                        {{ myfield.toadName.label }}
                                        {{ myfield.toadProfile.label }}
                                   
                              

                              

                                   {% for submission in submissions %}
                                   
                                        
                                             {{ submission.toadName.value }}   
                                        

                                        
                                             {{ submission.toadProfile.value }}   
                                        
                                   
                                   {% endfor %}

                              

                         

                         {% 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 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'  
> **username_0**: Actually I used {{ submission.toadProfile }} not {{ submission.toadProfile.value }}   syntax and now all good cheers  

---

