How to use SQL to filter out empty column values

Author	Message
sirlogalot	sirlogalot posted Last Week Topic Details Share Topic
Group: Forum Members Posts: 15, Visits: 44	Hi, I have a log I'm parsing that's JSON. Only some of the rows contain a certain key/value pair (in this case "Duration"). I've gotten those to parse out just fine. Now I want to use a SQL filter to limit the display to rows where Duration is > 2. The problem is I keep getting the error "No data is found for field 'Duration'". I haven't had any luck getting around this issue.
	Reply Like 0

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

sirlogalot - Last Week

Hi, The problem here is that sometimes the Duration field is NULL. To...

LogViewPlus Support - 2 Weeks Ago

I tried both null checks, but they both give me the "No data is found...

sirlogalot - Last Week

Thanks for the update. What version of LogViewPlus are you using?...

LogViewPlus Support - Last Week

I'm using v3.1.18. I just updated to v3.1.21 and tried both SQL...

sirlogalot - Last Week

I am surprised you are getting the same error when the type is...

LogViewPlus Support - 2 Weeks Ago

Here's a sanitized version from my logs. I was able to recreate the...

sirlogalot - Last Week

Thanks for the detailed bug report. I have recreated the issue on my...

LogViewPlus Support - 2 Weeks Ago

Login
Remember Me Reset Password Resend Validation Email Login