[Progress Communities] [Progress OpenEdge ABL] Forum Post: SQL code to list pages linked to events

[vaughnc@badgley.com]

Is there a SQL means of listing all pages linked to active events? I need the content_id of the event and the page url_name_ to build an appropriate invitation email hyperlink. I can see all active events with the following: SELECT * FROM sf_events WHERE status = 2 I can see the various pages here: SELECT * FROM sf_page_node I can't seem to find the relationship between the two tables. Can anyone please help? SQL would be the best solution for me. However, I'm open to an API approach.

Continue reading...