Add View with only certain records shown

jamesyesjames · Post by **jamesyesjames** » Tue Jun 17, 2014 1:59 am

Hi all,

I have a table called TimeSheets and I have created a View called "all Unpaid Time sheet".
Is there a way of making that View only show records which have nothing entered into the "Paid" field.

Any help on this would be amazing, Im sure its simple but haven't found a way to do it yet!

Thank,
James

danielc · Post by **danielc** » Tue Jun 17, 2014 8:51 am

Use "IS NULL" to select the record. See dev.mysql.com/doc/refman/5.0/en/working-with-null.html

jamesyesjames · Post by **jamesyesjames** » Tue Jun 17, 2014 10:47 pm

Thanks again Danielc

Do I put it into the Row_rendered script?

Cheers,
James

danielc · Post by **danielc** » Wed Jun 18, 2014 9:24 am

This will be part of your sql (your where clause) for your view.