select
distinct p.party_id, $sort_item
from
parties p
$left_join, cr_items ci, cr_revisions cr,
group_distinct_member_map
where
p.party_id = group_distinct_member_map.member_id
and ci.item_id = p.party_id and ci.latest_revision = cr.revision_id
and group_distinct_member_map.group_id in ('[join [contacts::default_groups] "','"]')
[contact::search_clause -and -search_id $search_id -query $query -party_id "p.party_id" -revision_id "revision_id"]
[template::list::orderby_clause -orderby -name "contacts"]
select
organizations.organization_id as party_id
from organizations, cr_items ci, cr_revisions cr,
group_distinct_member_map
where
organizations.organization_id = group_distinct_member_map.member_id
and group_distinct_member_map.group_id in ('[join [contacts::default_groups] "','"]')
and ci.item_id = organizations.organization_id and ci.latest_revision = cr.revision_id
[contact::search_clause -and -search_id $search_id -query $query -party_id "organizations.organization_id" -revision_id "revision_id"]
[template::list::orderby_clause -orderby -name "contacts"]
select
persons.person_id as party_id
from persons, cr_items ci, cr_revisions cr,
group_distinct_member_map
where
persons.person_id = group_distinct_member_map.member_id
and group_distinct_member_map.group_id in ('[join [contacts::default_groups] "','"]')
and ci.item_id = persons.person_id and ci.latest_revision = cr.revision_id
[contact::search_clause -and -search_id $search_id -query $query -party_id "persons.person_id" -revision_id "revision_id"]
[template::list::orderby_clause -orderby -name "contacts"]
select $extend_query
organizations.name,
first_names, last_name,
parties.party_id,
parties.email,
parties.url,
to_char(cr.publish_date, :date_format) as publish_date
from parties
left join persons on (parties.party_id = persons.person_id)
left join organizations on (parties.party_id = organizations.organization_id), cr_items ci, cr_revisions cr
where ci.item_id = party_id and ci.latest_revision = cr.revision_id
[template::list::page_where_clause -and -name "contacts" -key "party_id"]
$group_by_group_id
[template::list::orderby_clause -orderby -name "contacts"]
select distinct parties.party_id
from parties,
cr_items
where parties.party_id = cr_items.item_id
and parties.party_id in ( select group_approved_member_map.member_id
from group_approved_member_map
where group_approved_member_map.group_id in ([template::util::tcl_to_sql_list [contacts::default_group]]) )
[contact::search_clause -and -search_id $search_id -query $query -party_id "parties.party_id" -revision_id "cr_items.live_revision"]
select
csem.extend_id
from
contact_search_extend_map csem,
contact_extend_options ceo
where
ceo.extend_id = csem.extend_id
and ceo.aggregated_p = 'f'
and csem.search_id = :search_id
select distinct
$extend_query
rel.object_id_one as party_id,
rel.object_id_two as employee_id
from
acs_rels rel,
parties p
where
rel.rel_type = 'contact_rels_employment'
and rel.object_id_one = p.party_id
[template::list::page_where_clause -and -name "contacts" -key "party_id"]
select
rel.object_id_one as party_id,
rel.object_id_two as employee_id
from
acs_rels rel, persons p
where
rel.rel_type = 'contact_rels_employment'
and person_id = object_id_one
order by last_name
select
object_type
from
contact_searches
where
search_id = :search_id
select
object_type
from
contact_searches
where
search_id = :search_id
select
type
from
contact_search_conditions
where
search_id = :search_id