Exposing the flaggings table

I'm attaching a schema of how this can be done. This is a rip off of once-functional old patch I had laying around.

  // Advertise this table as a possible base table
  $data['flag_flagging']['table']['base'] = array(
    'field' => 'content_id',
    'title' => t('Flaggings'),
    'help' => t('Get at the individual flaggings.'),
    'numeric' => TRUE,
  );

'field' should point to 'fcid', of course, not to 'content_id'. (That snippet was written long ago, when we didn't yet have a primary key on that table.)

subscribing!

Another reason to expose this table:

Is there any trick to making the view sort on total flags within the past 24 hours?

If we expose this table, we will be able to do a "summary" on the flaggings done during the past X days/hours/etc.

Another reason to expose this table:

I need to get all flagged nodes from the users I have flagged.

[...]

Flag's Views implementation [...] should make the flagged content table (node) available for use as fields, filters, arguments, etc.

The patch achieves this by exposing three relationships: "The flagged node", "The flagged comment", The flagged user".

Another reason to expose this table:

[I want to add a section] "Users who have favorited this object have also favorited..."

(The "flagged node" relationship I mentioned in the previous reply solves this as well.)

There are many reasons to exposes this table. The code here complements the "flagging flaggings" feature which in itself solves many feature requests.

Tagging as 'flag 1.2' to try to help draw more attention to it.

Also added #464970: Natively support aliases for base tables.

Marked #433308: Get all nodes from all users I have flagged? (Flag Users) as a duplicate of this issue.

Moving.

I feel this would be a great addition as I am wanting to also view the number of flags a node has in a given timeframe and then cause the top flagged item to be hard posted to a front page. Any thoughts if this idea is on the same wavelength? I'd love to get involved but I am totally newb with PHP.

I would like the table exposed in views so that we can create a view of all the users who have flagged a particular node.

I would like the table exposed in views so that we can create a view of all the users who have flagged a particular node.

You can do that already. See the handbook page on this exact task: http://drupal.org/node/326308

ok almost have it, the handbook says
"you can easily turn it into a block. Add a "Block" display. Since blocks don't get arguments from the URL, you'll have to add the "Node ID from URL" default argument."

but I don't see this "Node ID from URL" option, where is it?

Nevermind, found it under "Provide default argument"