Active Posts — APG vNext Community

 ·  ASP Playground

Active Posts shows the most recently updated threads across all categories in the APG vNext support community.

Browse the Forum

To view active discussions, visit the community forum directly. The forum software provides real-time filtering by most recent posts, active threads, and recent visits.

Popular Discussion Areas

Return to the community home to browse all categories.

Understanding the Active Posts View in APG vNext

The Active Posts view is one of the most frequently used navigation shortcuts in APG vNext. It surfaces threads that have received new replies within a configurable time window, giving members a fast way to catch up on ongoing discussions without browsing each forum category individually. For community managers, it also serves as a real-time pulse check on engagement — a quiet Active Posts list is an early signal that re-engagement strategies are needed.

How Active Posts Are Calculated

APG vNext defines an "active" post as any thread that has received at least one new reply within the past N hours, where N is configurable in Admin Panel → Settings → Display → Active Posts Window. The default is 24 hours. The view excludes threads in forums the current member does not have read permission for, making it safe to expose to all member groups without permission leakage.

Configuring the Active Posts Window

<!-- web.config — active posts time window -->
<appSettings>
  <add key="APG.ActivePosts.HoursWindow"  value="24" />
  <add key="APG.ActivePosts.MaxResults"   value="50" />
  <add key="APG.ActivePosts.ShowExcerpt"  value="true" />
  <add key="APG.ActivePosts.ExcerptWords" value="30" />
</appSettings>

Reducing the window to 6–12 hours increases relevance for high-traffic communities. For smaller communities with infrequent posting, a 72-hour window ensures the list never appears empty.

Adding Active Posts to the Homepage Sidebar

The Active Posts widget can be embedded in the forum homepage sidebar via Admin Panel → Display Settings → Sidebar Widgets → Enable "Active Discussions". This shows the top 5–10 most recently active threads as a compact list, encouraging new visitors to dive directly into live conversations.

Performance Considerations

The Active Posts query scans the apg_Posts table ordered by LastPostDate DESC with a date filter. On large forums (500,000+ posts), ensure this index exists:

CREATE NONCLUSTERED INDEX IX_apg_Posts_LastPostDate
ON apg_Posts (LastPostDate DESC)
INCLUDE (ThreadID, ForumID, PostCount);

Without this index, the Active Posts query performs a full table scan on every page load. APG vNext 5.x creates this index automatically during fresh installation, but it may be missing on databases upgraded from 3.x.

RSS Feed for Active Posts

APG vNext exposes an RSS feed for active posts at /community/rss-active.ashx. This allows members to subscribe in their RSS reader and get notified of new activity without visiting the forum. It also enables external integrations — for example, posting the latest active discussions to a Slack channel or Discord server automatically.

Using Active Posts for Community Management

Beyond member navigation, the Active Posts view is a powerful tool for community managers. Monitoring active posts gives early warning of trending topics, emerging issues, and sudden spikes in activity that may indicate a community crisis (e.g., a controversial post going viral within your community).

Setting Up Active Posts Monitoring

APG vNext administrators can subscribe to an email digest of the most active threads for a given time period. Configure in Admin Panel → Reports → Activity Digest:

<!-- Email digest for active posts -->
<add key="APG.Digest.ActivePosts.Enabled"   value="true" />
<add key="APG.Digest.ActivePosts.Schedule"  value="0 8 * * *" />
<!-- Daily at 8:00 AM, using cron syntax -->
<add key="APG.Digest.ActivePosts.MaxItems"  value="10" />
<add key="APG.Digest.Recipients"            value="[email protected]" />

Filtering Active Posts by Category

On communities with many sub-forums, the global Active Posts view can be noisy. APG vNext supports per-category active post filters via URL parameters:

<!-- Active posts filtered to a specific forum -->
https://yourforum.com/community/Active?forumId=48

<!-- Active posts from the last 6 hours only -->
https://yourforum.com/community/Active?hours=6

<!-- Combined -->
https://yourforum.com/community/Active?forumId=48&hours=6

Link to filtered active post views from category-specific landing pages to give members in specialised sub-communities a focused activity feed.

Exporting Active Posts Data via API

For communities that feed their active post data into external dashboards or analytics tools, APG vNext 5.1+ exposes a REST API endpoint:

// GET active posts via APG vNext API
const response = await fetch(
  '/api/v1/posts/active?hours=24&maxResults=50',
  { headers: { 'X-APG-ApiKey': 'your-api-key' } }
);
const data = await response.json();

// data.posts = [
//   { threadId, title, replyCount, lastPostDate, lastPostAuthor, forumName },
//   ...
// ]

// Example: push to Slack channel
data.posts.slice(0, 5).forEach(post => {
  slackClient.chat.postMessage({
    channel: '#forum-activity',
    text: `New activity: ${post.title} (${post.replyCount} replies)`
  });
});

Troubleshooting Empty Active Posts List

If the active posts list is empty despite recent forum activity, the most common cause is incorrect server time. The time filter compares LastPostDate against GETDATE() on the SQL Server. If SQL Server time is more than the configured window behind the actual posting time, posts fall outside the filter window:

-- Check SQL Server time vs. system clock:
SELECT GETDATE() AS SQLServerTime;
-- Compare with actual server time in Windows clock settings

-- Also verify the highest recent post date:
SELECT MAX(PostDate) AS MostRecentPost FROM apg_Posts;
-- If this is hours or days old, no new posts have been made

Related Resources