I have a multiselect box on a field-- modelName
modelName can have different values or empty value.
eg. modelName="modelA" modelName="modelB" or modelName=""
modelName="*"
I set the default multiselect token to "*"
to select all of the records. But it will ignore modelName=""
(the null case)
Is there anyway to include the null case?
Thanks.
Search=1337
| eval UserBuilding=coalesce(UserBuilding, "nothing")
| stats count by UserBuilding
| table UserBuilding
try this, @jregruit
That will work, thank you!
@jregruit if your issue is resolved do accept/up vote the answer by @to4kawa.
Hi kualo,
I generally use
(modelName="*" OR NOT modelName="*")
Bye.
Giuseppe
I'm still a bit confused on this one, can someone please assist? I am trying to populate null values in a multiselect box. My current code is:
Search=1337 | stats count by UserBuilding | table UserBuilding
Right now, I am getting all entries with a value as a selection, but not the null values... Not sure what I am doing wrong. Any help is appreciated.
Thanks!
What should my syntax be here?
I don't think your query is wrong.
What do you want to populate?
null means nothing
In my multiselect checkbox, I would like to have a option for occurrences of null values.
Hi, @jregruit
stats by
remove null values.
Search has long lacked a good way to distinguish between a field that is not present vs a field that is present but has an empty-string value for the current record.
What I've generally had to do is (modelName="*" OR modelName="")
This isn't a full answer because it doesn't tell you how to handle this in a view. Sorry I'm not sure.