Smart Filters containing Multiple Items

[mrittlinger]

I'm having some trouble getting the smart filters to work with more complex constructs. I am using 0.7.

My value is json format and looks like this:

{
	"IsError": false,
	"Message": "Unauthorized",
	"ResponseContent": "",
	"RequestContent": "",
	"EventType": "fill",
	"SystemId": "5670",
	"Payload": "redacted"
}

I can filter by a single value. Both of these filters work fine individually:

value.SystemId == "5670"

value.Message.contains("Unauthorized")

If I try to combine them the data is not filtered (as if there is no filter). Clicking the "Submit" button returns immediately. I have tried these variations:

value.SystemId == "5670" && value.Message ==~ "Unauthorized*"

value.SystemId == "5670" && value.Message.contains("Unauthorized")

def systemid = value.SystemId
def msg = value.Message
systemid == "5670" && msg == "Unauthorized"

def systemid = value.SystemId
def msg = value.Message
systemid == "5670" && msg.contains("Unauthorized")

Similarly, I have also attempted to use the timestampMs field to filter by date range.
Groovy attempt -

import groovy.time.*

def startString = "2023-06-20T05:00:00.0Z"
def endString = "2023-06-20T06:00:00.0Z"

def start = Date.parse("yyyy-MM-dd'T'HH:mm:ss",startString).getTime()
def end = Date.parse("yyyy-MM-dd'T'HH:mm:ss",endString).getTime()

timestampMs >= start && timestampMs <= end

Java attempt -

import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.time.ZoneId;

var startString = "2023-06-20T05:00:00Z";
var endString = "2023-06-20T12:00:00Z";

var formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd'T'HH:mm:ss'Z'");

var start = LocalDateTime.parse(startString, formatter).atZone(ZoneId.systemDefault()).toInstant().toEpochMilli();
var end = LocalDateTime.parse(endString, formatter).atZone(ZoneId.systemDefault()).toInstant().toEpochMilli();

timestampMs >= start && timestampMs <= end;

Any advice on how to filter by multiple fields and date range would be greatly appreciated.

[iliax]

Hello @mrittlinger ! Thanks for raising it.
I just checked your scenario on v0.7.0 and I can't reproduce it.
Please check the screenshots - maybe I am doing smth wrong.

Messages in topic:

Adding filter:

Result:

---

---

Here are some questions:

1. what browser do you use?
2. are there any errors in kui logs?
3. are there errors showing in the right corner of messages view (see screenshot) ?

[ritchApps]

is the browser important?
what If I don't see any errors?
I'm not getting my messages filtered

[Haarolean]

@ritchApps #4437 (comment)

[bidyut90]

Hello team, I'm having trouble getting the date rage. Could someone please assist me?

[Haarolean]

#4437 (comment)

[benny-yamagata]

Just FYI, getting the same issue.
0.7.2 - Smart filters not working at all.
Getting 400 bad request in the console when I click submit.

[Haarolean]

#4437 (comment)