Jump to content

Search the Community

Showing results for tags 'query'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Company news
    • General announcements
  • ftrack Studio (main app)
    • General discussion
    • Feature requests
    • API
    • Help
    • Actions and Widgets
    • ftrack Go
  • ftrack Review
    • General discussion
    • Feature requests
    • Help
  • Connect and plugins
    • General discussion
    • Connect package releases
    • Feature requests
    • Help
    • Connect plugins releases
  • Advisory Forum
  • Tech preview
    • API
    • New integrations
    • Studio overview
    • ftrack Review


There are no results to display.

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start





Website URL







Found 15 results

  1. Hello, I need to write some checks using the python api to make sure the current ftrack project is configured correctly. There fore i need to query the currents project Project Schema and check its configuration. Specifically: I need to query the assigned Objecty (ObjectTypes) of a Project Schema. I can access the the Types and objects with 'ProjectSchema.get_types()' as well as the statuses an by calling 'ProjectSchema.get_statuses()' but i can't find a way to actually figure out if an object (ObjectType) is assigned to the list of objects of the particular Project Sc
  2. Hello everybody! This action populates some custom attributes within a Task that is nested under selected item. These attributes are paths to working directories and render outputs.. I have other actions that rely on these custom paths to do other things such as opening a shot with quicktime / launching the shot folder in explorer /etc.. Everything works as it should.... but I am concerned about the efficiency and speed of my code as populating each task takes about a second... and of course, the more tasks nested under my selection, the longer this process takes.
  3. I'm writing an action script that get as input all tasks whose parent(Asset Build) have a specific value in a custom attribute. Ideally, the right value of the custom attribute would be found in the Filter button/option from the site. The first problem is that i want to be able to query all tasks that have the right filter value using the API's expression language. Something like this: filtered_value = ??? #somehow get the filter from the site list_of_tasks = session.query('Task where parent.custom_attributes.my_custom_attr is {0}'.format(filtered_value)).all() The second problem
  4. Hi, You implemented in the version filter in the version view a "latest Version" checker box field, to be able to see just the latest versions. I'm missing this feature in the Widget settings of the Latest Version. Is there a way to query the latest version through the query field? Thanks. Best, Luigi
  5. Hi, We would like to be able to filter all latest versions of type "X" (e.g. a released playblast) that have a task "Y" (e.g. animation) and are linked to my current selection "Z" (e.g. a character in my asset library) We need to be able to query it though the browser UI of ftrack, without any line of code or a developer for it. e.g.: Show me the latest playblasts from the animation dept linked to my selected character The interface should filter the list accordingly. a simple query like: task.type.name="Animation" AND asset.parent.incoming_link.from = MY_SELECTION
  6. Hi, I'm trying to figure out a query to retrieve all or selected custom_attributes in a query. I have some custom attributes on a project and my session has autopopulating turned OFF. project = session.query('select custom_attributes from Project where name is "{0}"'.format(name)).one() if I try to access my custom attribute "foo" the value of it is not set print project['custom_attributes']['foo'] > NOT_SET I tried to pass the attribute name directly to the query but that in key error project = session.query('select custom_attributes.foo from Project where name is "{
  7. Hi, We are in the process of evaluating ftrack as a replacement for our in-house system. Quite often we need to find database entries based on a system path. From the system path, we can extract the project/sequence/shot etc names that are unique for an entity. One way to retrieve a shot information is with multiple queries to access specific IDs: project_number = 4444 sequence = 'Online' shot_name = 'sh010' project_id = session.query('select name, id from Project where name is {0}'.format(project_number)).first()['id'] sequence_id = session.query('select id from Sequence wh
  8. jerome

    Query join

    Hi, Is it possible to send queries with the new API that will use joins on several objects. I would like to query an asset for a specific asset build, i.e. something like this: Asset where parent.id is ( select id from AssetBuild where project.id is <projectId> and name is "<myAssetBuildName>")Is this kind of request valid with the new API ?
  9. Hi all, I have 2 assets in Ftrack: 'asset_name' and 'ASSET_NAME'. When I query via the API both assets, all the time I get only the first one because the name is not case sensitive. Example: assets = session.query("Asset where name is 'asset_name'").all() print len(assets) print assets[0]['name'] print assets[0]['id'] # Return: 1 asset_name 4c63aa70-6475-11e6-b6fd-005056a76761 assets = session.query("Asset where name is 'ASSET_NAME'").all() print len(assets) print assets[0]['name'] print assets[0]['id'] # Return: 1 asset_nam
  10. In our Ftrack installation, we have defined a custom attribute at the project level--let's call it "locations". I would like to create a function that allows users to add an additional location to a project after querying that the provided argument is indeed an available option in the collection of locations. I can't find an example of this kind of query; I just need to know whether this is something attached to Session or somewhere else. So let's say locations = {'Uptown': 'uptown', 'Downtown': 'downtown', 'Midtown': 'midtown'} (in settings it's an Enumerator that seems to be represented
  11. So I'm trying to create a tool that creates tasks from Maya. I got the initial prototype working, but I'm having trouble with optimization. Originally, when the user hit the create task button, the session would query the schema, get the available task types, and then put them into a combobox. This worked fine, but the long loading time proved to be too slow for production. So I figured what if I loaded the task types when the user first ran the tool? That way when they went to create a task, the combobox would be filled and ready to go. This worked at first, but along the way thi
  12. I'm trying to figure out how to query what an item is based on user selection. In my tool, a user might be selecting a Sequence, Task, Shot, etc and I'd like different things to happen based on their selection. Is there any way to query this with the new API? The docs seem to just show how to query something only if you know exactly what entity type you want. I have this right now: dir_contents = [] for item in project['children']: dir_contents.append( item ) for item in dir_contents: item_name = item['name'] item_type = item['context_type'] item_id = item['id'] When I
  13. 1) I'm having trouble getting the criteria system to work. When the tool starts up, in the main window module queries all of the active projects and populates a QTreeView: session = ftrack_api.Session() dir_contents = [] for project in session.query('Project'): dir_contents.append( project ) When a user selects a project to work with, another module creates a tab and queries the project data- populating this new tab with directory hierarchy, tasks, thumbnails, notes, etc. I was able to begin querying a project's ftrack data by using the legacy method getProject('string'), b
  14. jerome

    Query operator

    Hi, Is there a simple way to query for the last version of an asset with the new API ? And more generally is there a plan to add new selection operator like: max, avg, sum or count ? Cheers, Jerome
  15. I want to get list of task that was changed in status or published during some period of time. There should be a function with input - start_date,end_date and output - List of Tasks
  • Create New...