Symptoms

Incorrect syntax near 'NULLORDER'. 
 

Diagnoses

When applying an IS NULL filter, Sort, and when Paging is not enabled on a list view the following error occurs:

Incorrect syntax near 'NULLORDER'. Incorrect syntax near 'NULLORDER'.
•Type: SourceCode.SmartObjects.Client.SmartObjectException
•Source: SourceCode.SmartObjects.Client
•Method Base
◦Member Type: Method
◦Name: GetSmartObjectReader
◦Module
Scope Name: SourceCode.SmartObjects.Client.dll
◦Declaring Type
Full Name: SourceCode.SmartObjects.Client.SmartObjectClientServer
•Stack Trace:
at SourceCode.SmartObjects.Client.SmartObjectClientServer.GetSmartObjectReader(SmartObject smartObject, ExecuteListReaderOptions options, Dictionary`2and propertyReference)
at SourceCode.SmartObjects.Client.SmartObjectClientServer.ExecuteListReader(SmartObject smartObject, ExecuteListReaderOptions options)
at SourceCode.Forms.AppFramework.FormsApiToXml.ToXmlList()
at SourceCode.Forms.AppFramework.FormRuntime.SmartObjectExecution(XPathNavigator nav, Boolean outputDependencies, SmartObjectClientServer svr)
at SourceCode.Forms.AppFramework.FormRuntime.WorkXmlToApi(String xml)
at SourceCode.Forms.Runtime.AJAXCall.ProcessRequest(HttpContext context)
 

Resolution

This "Incorrect syntax near 'NULLORDER'." error is a bug with the 4.6.9 release and will be fixed in the upcoming release of 4.6.10.

Unfortunately there is a not a workaround at the moment, aside from removing/changing one of the applied conditions to continue development:
- usage of the IsNull
- usage of the sort
- usage of paging