OpenACS

maltes
committed
MAIN:maltes:20050924111238
on 24 Sep 05
Added sorting by last_name if the party is a person (using sort_name)
/oracle/bboard-portlet-create.sql (+4 -2)
1 1 --
2 2 -- packages/bboard-portlet/sql/bboard-portlets-create.sql
3 3 --
4 4
5 5 -- Creates bboard datasources for portal portlets
6 6
7 7 -- Copyright (C) 2001 OpenForce, Inc.
8 8 -- @author Arjun Sanyal (arjun@openforce.net)
9 9 -- @creation-date 2001-30-09
10 10
11 11 -- $Id$
12 12
13 13 -- This is free software distributed under the terms of the GNU Public
14 14 -- License version 2 or higher.  Full text of the license is available
15 15 -- from the GNU Project: http://www.fsf.org/copyleft/gpl.html
16 16
  17 @bboard-portlet-sc-create.sql
  18
17 19 declare
18 20   ds_id portal_datasources.datasource_id%TYPE;
19 21 begin
20 22   ds_id := portal_datasource.new(
21       name             => 'bboard-portlet',
  23     name             => 'bboard_portlet',
22 24     description      => 'Displays the bboard for a given instance_id ',
23 25     configurable_p   => 't'
24 26   );
25 27
26 28   -- Instance_id must be configured
27 29   portal_datasource.set_def_param (
28 30         datasource_id => ds_id,
29 31         config_required_p => 't',
30 32         configured_p => 'f',
31 33         key => 'instance_id',
32 34         value => ''
33 35 );      
34 36
35 37   -- shaded_p
36 38   portal_datasource.set_def_param (
37 39         datasource_id => ds_id,
38 40         config_required_p => 't',
39 41         configured_p => 't',
40 42         key => 'shaded_p',
41 43         value => 'f'