Hi,
I’m trying to query the number of actions for just 1 day. So far I have the following but getting an “expression could not be parsed” error.
ids of bes actions whose (name of it contains “testapp”, time issued of it = now > 1 * day)
Thanks,
There are a couple issues with this, but it’s most of the way there!
The first is that you’re making a tuple in your whose close, which won’t work. You’ll need to use standard AND/OR boolean operators: (name of it contains “testapp” AND time issued etc).
Your other problem is that you’re a little mixed up in the actions in the last day section. Right now you’ve asked it for actions where the time issued equals now is greater than one day. You want (now - 1*day) to get one day ago.
Putting everything together would be something like this:
(ids of it) of bes actions whose ((name of it contains "testapp") AND (time issued of it > now - 1*day))
A couple other tips: you probably want to cast the string of the name of the app as lowercase to account for any weird capitalization issues. That’d be
(ids of it) of bes actions whose ((name of it as lowercase contains "testapp") AND (time issued of it > now - 1*day))
I also put (ids of it) in parenthesis so it’s easy to add additional things you’re interested in, like who took the action:
(ids of it, names of issuers of it) of bes actions whose ((name of it contains "testapp") AND (time issued of it > now - 1*day))
2 Likes