doSelectKD

Web Services Methods › Knowledge Management › Knowledge Management General Methods › doSelectKD

doSelectKD

The following parameters apply to the doSelectKD method:

Parameter	Type	Description
SID	Integer	Identifies the session retrieved from logging in.
whereClause	String	(Optional) Identifies the where clause for the query.
sortBy	String	Identifies the database field that you want to use for sorting the results. Multiple sort fields are not supported. The default is BU_RESULT, meaning that the faq rating sorts it. When id is used as the secondary sort, it always sorts the results.
desc	Boolean	Identifies the indicator available for sorting the results in descending order. Use True for descending and False for ascending the document order.
maxRows	Integer	Indicates the maximum number of rows to return. Specify -1 to return all rows. Note: Regardless of the integer specified, CA SDM will return a maximum of 250 rows per call.
attributes	String[]	Identifies the attribute list from which to fetch values. Dotted-attributes are permitted. If this field is blank, all value-based attributes are returned. These attributes cannot be defined as LOCAL in the majic definition file. LOCAL attributes are temporal; they have no database storage.
skip	Integer	Identifies the number of knowledge documents to skip from the beginning. Enter zero (0) to return all documents.

Description

Performs an SQL-like select on a Knowledge Document table. Supply one or more attributes you want fetched from the objects that match the supplied where clause.

Returns

A sequence of <UDSObject> elements. The following format applies:

<UDSObjectList>
<UDSObject>
 <Handle>
 <Attributes>
<AttributeName0>
<AttributeName1>

XML Element	Type	Description
<UDSObject>	Sequence	Contains a <Handle> element and an <Attributes> sequence.
<UDSObjectList>		Signifies the outer element, which contains a sequence of <UDSObject> elements.