Im doing the Create & Use Custom Controllers from trailhead on module visual force basics, I do not know what to do but i have an error in my where clause
//This is my controller
public class NewCaseListController {
private String tipoCaso = 'New';
public List<Case> getNewCases(){
List<Case> lista = Database.query('SELECT Id, CaseNumber FROM Case WHERE Status = New');
return lista;
}
}
And my view
<apex:page controller="NewCaseListController" >
<apex:pageBlock>
<apex:repeat value="{! newcases}" var="case" >
<ul>
<apex:outputLink value="/{! case.Id }" ><li>{! case.Id }</li></apex:outputLink>
<li>{! case.CaseNumber }</li>
</ul>
</apex:repeat>
</apex:pageBlock>
</apex:page>
when preview, says:
expecting a colon, found 'New' An unexpected error has occurred. Your development organization has been notified.