[Filter notes by label]

Hi,
I am struggling with filtering notes. User supplies the project name, shot and task, with optional note label filtering and optional version filtering (for version notes).
Maybe there is a way to directly query that? I do not know how to find out if note has particular label

Thank you

 

self.ftrack_label = self.ftrack_session.query(
                            'NoteLabel where name is "{}"'.format(label)
                        ).first()
notes = []
f_task = self.ftrack_session.query(
    'Task where name is {} and parent.name is {}'
    ' and project.full_name is {}'.format(task, shot,
					  project)).first()
if do_version:
    assets = self.ftrack_session.query(
	'select asset.name, version from AssetVersion '
	'where task_id is "{}" and asset.name is_not '
	'none order by version desc'.format(
	    f_task['id'])).all()

    version_gui = int(version)
    for one_asset in assets:
	version_asset = int(one_asset['version'])
	if version_gui == version_asset:
	    for one_note in one_asset['notes']:
		content = one_note['content']
		_save = False
		if do_label:
		    l = one_note['note_label_links']
		    if self.ftrack_label['id'] in l:
			_save = True
		else:
		    _save = True
		if _save:
		    v = version_matching(content, version)
		    if v is not None:
			notes.append(content)
else:
    for one_note in f_task['notes']:
	_save = False
	content = one_note['content']
	if do_label:
	    l = one_note['note_label_links']
	    if self.ftrack_label['id'] in l:
		_save = True
	else:
	    _save = True
	if _save:
	    v = version_matching(content, version)
	    if v is not None:
		notes.append(content)

 

[ftrack.server Storage usage]

Thank you, I will try that

[ftrack.server Storage usage]

We have more than thousand projects in Ftrack, and are reaching 80% of the 500GB quota.

Is there a way to find out per project storage?

Is there a way to delete video from (old/hidden) projects, and keep just stills / thumbnails only?

Any news on archiving old projects, mentioned here and here?
 

Thank you

Jirka

[User Attribute]

Hi,

I would be also interested in a way to get "live" price per shot and per project by adding day/hour rate to users.

Thank you,

Jirka