Thread

Hi,

Continuing on with the student thing. I now need to have where statements in the template. For instance I want to find out if a student has 3 or more “A’s”. I know this can be done with the query plugin, but i’m using the url to get data per username, so i’m thinking that is no good?
Can i use the count function to do this?

Thanks.

Sorry, should read “Where conditional in template”

Have you reviewed the available parameters for the channel:entries tag?

Hi,

Yeah i’ve reviewed the tags, but i was thinking i need a where clause?

Sorry i’m very early in development with EE.

Thanks.

You aren’t writing SQL. EE is taking your combination of EE tag pairs and parameters and writing that SQL for you.

There is a parameter for the channel:entries tag pair that does effectively the same thing as a SQL where clause.

Give the docs another look and if you don’t spot it I’ll link to it.

Ah so its the “search:field_name=” ? That looks interesting. Can i still get a count of the results returned from that though? Also sometimes i need to get a count and not display the result as a number.

Thanks.

Try it…;)

Ok that seems pretty straight forward, although its just returning all the results from the user.

{exp:channel:entries channel="results" search:field_one="text" search:field_two="number"}

<table>
 {results}
 <tr>
   <td>{results:date}</td>
   <td>{results:venue}</td>
   <td>{results:country}</td>
   <td>{results:session}</td>
   <td>{results:position}</td>
   <td>{results:fastest_lap}</td>
 </tr>
 

 {/results}
 
</table>

{/exp:channel:entries}

Am i using the correct tags to return the results?

Thanks.

Are your fields literally named “field_one” and “field_two”?

And are you searching for the literal strings of “text” and “number” ?

Hi,

Sorry no they’re just fillers. Field one is text and field two is a number.

I don’t understand why you are using fillers. You need to use actual field names and actual search strings that are in the content for it to work.

{exp:channel:entries channel="results" search:session="Race" search:position="01"}

<table>
 {results}
 <tr>
   <td>{results:date}</td>
   <td>{results:venue}</td>
   <td>{results:country}</td>
   <td>{results:session}</td>
   <td>{results:position}</td>
   <td>{results:fastest_lap}</td>
 </tr>
 

 {/results}
 
</table>

{/exp:channel:entries}

Sorry the fillers were just for this post. The above is the exact code i’m using.

Ok, on a brand new page, that seems to work fine. Not what i’ve done/haven’t done but its all good. Thanks for your help.