Filtering in Query and in the overview

[Luigi]

A few questions about filtering in Query

• Is there a way to filter all tasks without an assignee? or looking for empty assignments?
• Is there a way to filter in query an asset type?

...And about filtering the new Overview User view:

• Is there a way to filter only non assigned user?
• Is there a way to filter user per project?

Thanks,

Luigi

[Mattias Lagergren]

14 hours ago, Luigi said:

A few questions about filtering in Query

Is this from the Web UI or from the API?

[Mattias Lagergren]

Quote

 

...And about filtering the new Overview User view:

Is there a way to filter only non assigned user?

Is there a way to filter user per project?

 

There is currently not but we are planning on adding more filter options.

[Luigi]

It was a question for filter in Query in the Web UI. Sorry for not specifying.

[Mattias Lagergren]

This should allow you to filter tasks based on lack of assignments:

not assignments any ()

For the other one with asset types, is that in the Versions view or Tasks view? Could you elaborate a little on what you want to see.

[Luigi]

Thanks for the response. It worked perfectly.

If I'm in the Task view I can Query in Query (task): 

type.name != 'Animation'

If I'm in the Version view I can not filter out a specific Asset type (version): Camera, Image or Plate

e.g. type.name != 'Upload'

No attribute u'type' exists for schema u'AssetVersion'

 

[Eric Hermelin]

Hi Luigi,

When filtering based on the asset type name on the versions page you would have to use

ie:

asset.type.name = "Camera"

 

cheers

Eric

[Luigi]

I noticed that when filtering in the UI query, some operations are not working.

I was wondering if only a couple of operation listed in your docs are working in the UI query, since they are listed in the API section.

e.g. start after “2015-06-01”

I'm getting here the error message no attribute u'start' exists

OR

bid >= 10

Its not giving error messages, but I can't see any changes even if my bid days could be filtered

OR

author has (first_name is “Luigi” and last_name is “Pisciotta”)

It's failing to parse my query

[Mattias Lagergren]

e.g. start after “2015-06-01”

The `start` attributes is actually `start_date`. 

bid >= 10

This is can be confusing but internally bid is stored in seconds.

author has (first_name is “Luigi” and last_name is “Pisciotta”)

Is this in the Tasks spreadsheet? Are you looking for tasks with notes from a certain author?

 

 

[Luigi]

What do you mean with

Quote

bid is stored in seconds

how many seconds are a bid unit.

Quote

Is this in the Tasks spreadsheet?

Yes. I tried it there and in the version sheet too. It was as an example in your doc site and I found it very interesting to check where a comment of a Supe. or Coord. was added.

 

 

[Luigi]

ok. I found it out with the bid, but is there a way to make math in the query field?

e.g. bid = ((60*60*8)*1,5)
 

[Luigi]

Any response on my last question? is there a way to query math operations in the browser UI?

[Mattias Lagergren]

Hi Luigi, at the moment there are no math operations implemented in the browser UI or API.