function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
civiccivic 

VFpage SOQL query

I have few custom objects subscriptions,subscripion members,subscriptiongroup subscription & subscription group.

I have created a force.com site. I want to create aVF page which will display  the existing subscriptions & the eligible subscriptions of a contact filtered by the associated subscription group.

can i create a function get subscriptiongroup.contactId =subscriptiongroupId

I need to write a SOQL query which will achieve these tasks.

Pls help and if u need more information let meknow.

Thanks in advance