Copyright © 2024, Oracle and/or its affiliates.
Field Index SQL Mapping

Class /search

Search objects to hold pre-created search templates to be used with PCM_OP_SEARCH opcode. The alternative is to define the search templates at run-time when calling the opcode. But the pre-created templates allow reuse of search templates across many searches. Also, these search objects are cached in the dm (oracle or odbc). The other benefit is that documented search object illustrate the kinds of searches done on different classes of objects. These search objects can also be used to do step searches (retrieving partial results) using the PCM_OP_STEP_SEARCH opcode. A pre-defined set of search objects are loaded into the system during installation from the init_objects.source file.

Notes

  • This object can be read by anyone.
  • This object can be modified only by the owner.
  • This object can be created by anyone.

Links



Field Index

Type Field Name
poid PIN_FLD_POID
timestamp PIN_FLD_CREATED_T
timestamp PIN_FLD_MOD_T
string PIN_FLD_READ_ACCESS
string PIN_FLD_WRITE_ACCESS
string PIN_FLD_CREATE_ACCESS
int PIN_FLD_FLAGS
string PIN_FLD_NAME
string PIN_FLD_TEMPLATE


Field Details

poid PIN_FLD_POID

Object Identifier for an instance of this class. Portal object ids have four pieces of information: database number, class type, sequence id, revision.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

timestamp PIN_FLD_CREATED_T

Time the object was created.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

timestamp PIN_FLD_MOD_T

Time the object was last modified.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

string PIN_FLD_READ_ACCESS

Read Access level for object. Valid values are S(Self), G(Global), L(BrandLineage), B(BrandGroup), A(Ancestral).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

string PIN_FLD_WRITE_ACCESS

Write Access level for object. Valid values are S(Self), G(Global), L(BrandLineage), B(BrandGroup), A(Ancestral).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

string PIN_FLD_CREATE_ACCESS

Create Access level for object. Valid values are O(BrandOwner), R(Root), N(Any).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

int PIN_FLD_FLAGS

SRCH_DISTINCT (256) - Preferred to avoid duplicates, since semantics are: 'select poids of matching objects, then do a READ_{OBJ,FLDS} on those'. SRCH_CALC_ONLY_1 (1) - Returns value in PIN_FLD_AMOUNT in RESULTS array. Use 0 if 'distinct' is not desired.

Notes

  • Required on object creation
  • Cannot be modified

Links

string PIN_FLD_NAME

Search name

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 255 bytes

Links

string PIN_FLD_TEMPLATE

Search template string. The usual form of the template is: select X from /<object>/$1 where F1 <op> V1 and F2 <op> V2

Notes

  • Required on object creation
  • Cannot be modified
  • Maximum length is 2000 bytes

Links



SQL Mapping


Type Field Name Table Column Name
base-class /search search_t
poid PIN_FLD_POID poid*
timestamp PIN_FLD_CREATED_T created_t
timestamp PIN_FLD_MOD_T mod_t
string PIN_FLD_READ_ACCESS read_access
string PIN_FLD_WRITE_ACCESS wrtie_access
string PIN_FLD_CREATE_ACCESS create_access
int PIN_FLD_FLAGS flags
string PIN_FLD_NAME name
string PIN_FLD_TEMPLATE template
Column names marked with * are actually column prefixes. For poid type fields, the column prefix is used to create the columns poid_id0, poid_db and poid_type if the prefix is "poid". For PIN_FLD_POID in the base table, an additional column named poid_rev is created to hold the poid revision. For buffer fields, two columns are created - one in the containing table and one in the buffer table. For example if the prefix is "buf", then the column name in the buffer table is buffer_buf and the column name in the containing table is buffer_size.

Field Index This Class