[Developers] Searching for Non Null Values

[Dae Park]

On Mar 13, 2007, at 6:11 PM, Dae Park wrote:
> try
>
> {
>    "query":[{
>      "active_end":{
>        "value":null
>      },
>      "active_start":{
>        "value":null
>      },
>      "guid":null,
>      "name":null,
>      "name~=":"Blue",
>      "sort":"name",
>      "type":"/music/artist"
>    }]
> }


I should explain why that works (correct me if I am wrong tsturge) but

{
    "query":[{
      "active_end":null,
      "active_start":null,
      "guid":null,
      "name":null,
      "name~=":"Blue",
      "sort":"name",
      "type":"/music/artist"
    }]
}

is essentially the same as:

{
    "query":[{
      "active_end": {
	"value": null,
         "optional": true
      },
      "active_start":{
	"value": null,
         "optional": true
      },
      "guid":null,
      "name":null,
      "name~=":"Blue",
      "sort":"name",
      "type":"/music/artist"
    }]
}

so when you take out the optional for the value field, you're  
essentially asking for something that does not have a null value.

-dae