Photo tag (FQL)

From Facebook Developer Wiki

Jump to: navigation, search


Contents

Description

The FQL photo_tag table. Query this table to return information about a photo tag.

To structure your query, use the table name (photo_tag in this case) in the FROM clause. The items in the Name column correspond to columns in the table that can be referenced in the SELECT and WHERE clauses.

You can also use the photo_tag FQL table to query for photos associated with a group (given its gid) or event (given its eid). See below for sample queries on how to do this.

In order to make your query indexable, the WHERE in your query should contain an = or IN clause for one of the columns marked with a * in the Indexable column of the table.

The See Also section lists API functions that work on similar data; their documentation pages contain additional information about the contents of the column and example FQL queries.

Columns

IndexableNameTypeDescription
* pid string The ID of the photo being queried. The pid cannot be longer than 50 characters.
Note: Because the pid is a string, you should always wrap the pid in quotes when referenced in a query.
* subject int For tagged users, use the user ID of the subject for the tag being queried. For photos associated with events or groups, use the eid or gid for subject.
text string The content of the tag being queried.
xcoord float The center of the tag's horizontal position, measured as a floating-point percentage from 0 to 100, from the left edge of the photo.
ycoord float The center of the tag's vertical position, measured as a floating-point percentage from 0 to 100, from the top edge of the photo.
created time The date that the tag being queried was created.

Examples

Get all pids of photos associated with a user, given its user id (uid).

SELECT pid FROM photo_tag WHERE subject=$uid


Get all pids of photos associated with an event, given its event id (eid).

SELECT pid FROM photo_tag WHERE subject=$eid


Get all pids of photos associated with a group, given its group id (gid).

SELECT pid FROM photo_tag WHERE subject=$gid

See Also

reference