sdk$runInlineQuery Filter with multiple options.

[dougneedham]

I need to be able to run an inline query where I can use a combination of filters.
For example: data <- sdk$runInlineQuery(model = "model_name",
view = "my_awesome_explore",
fields = c("id", "count"),
filters = list("field_name" = "filter_expression",
"another_field" = "filter_expression"),
How would I do something like this:

data <- sdk$runInlineQuery(model = "model_name",
view = "my_awesome_explore",
fields = c("id", "count"),
filters = list("field_name" = "filter_expression1","filter_expression2","filter_expression3")

[maxcorbin]

Hey @dougneedham, thanks for bringing this up. It's not immediately clear to me whether the Looker API accepts duplicate keys for the same field in the filters parameter. Based on what I know, I would expect the following to work:

filters = list("field_name" = "filter_expression1",
               "field_name" = "filter_expression2")

But this may not be the case based on how the Looker API expects the request and how LookR creates the request. There might be room for improvement on my end here. I'll do some testing and get back to you.

In the meantime, Looker allows you to combine multiple filter expressions into a single filter expression, with different methods for different data types. For example, with string type fields, you can use commas to match either string. FOO,BAR will match either FOO or BAR. For number type fields, you can use the AND and OR keywords. >10 AND <=20 will match numbers 11-20.