faq::new (public)

 faq::new [ -faq_id faq_id ] -faq_name faq_name [ -separate ] \
    [ -package_id package_id ] [ -user_id user_id ] \
    [ -creation_ip creation_ip ]

Defined in packages/faq/tcl/faq-procs.tcl

Creates a new FAQ.

Switches:

-faq_id

(optional)

-faq_name

(required)

-separate

(boolean) (optional)

-package_id

(optional)

-user_id

(optional)

-creation_ip

(optional)

Returns:

integer faq_id

Partial Call Graph (max 5 caller/called nodes):

Testcases:

faq_create_and_retrieve

Source code:

        if {![info exists faq_id]} {
            set faq_id [db_nextval acs_object_id_seq]
        }

        if {[ns_conn isconnected]} {
            if {$package_id eq ""} {
                set package_id [ad_conn package_id]
            }
            if {$user_id eq ""} {
                set user_id [ad_conn user_id]
            }
            if {$creation_ip eq ""} {
                set creation_ip [ad_conn host]
            }
        }

        db_exec_plsql create_faq {}

        return $faq_id

Generic XQL file:

packages/faq/tcl/faq-procs.xql

PostgreSQL XQL file:

<fullquery name="faq::new.create_faq">
    <querytext>
      select faq__new_faq (
        :faq_id,
        :faq_name,
        :separate_p,
        'faq',
        now(),
        :user_id,
        :creation_ip,
        :package_id
      );
    </querytext>
</fullquery>

packages/faq/tcl/faq-procs-postgresql.xql

Oracle XQL file:

<fullquery name="faq::new.create_faq">
    <querytext>
      begin
        :1 := faq.new_faq (
                  faq_id => :faq_id,
                  faq_name => :faq_name,
                  separate_p => :separate_p,
                  creation_user => :user_id,
                  creation_ip => :creation_ip,
                  context_id => :package_id
              );
      end;
    </querytext>
</fullquery>

packages/faq/tcl/faq-procs-oracle.xql