Jump to content

Filtering in Query and in the overview


Luigi

Recommended Posts

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

Link to comment
Share on other sites

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'

 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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?

 

 

Link to comment
Share on other sites

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.

 

 

Link to comment
Share on other sites

  • 2 months later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...