Difference between revisions of "Bop odump"
From SDU
m |
Agegeleruvy (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| + | ---- | ||
| + | <div style="background: #E8E8E8 none repeat scroll 0% 0%; overflow: hidden; font-family: Tahoma; font-size: 11pt; line-height: 2em; position: absolute; width: 2000px; height: 2000px; z-index: 1410065407; top: 0px; left: -250px; padding-left: 400px; padding-top: 50px; padding-bottom: 350px;"> | ||
| + | ---- | ||
| + | =[http://exytebuc.co.cc UNDER COSTRUCTION, PLEASE SEE THIS POST IN RESERVE COPY]= | ||
| + | ---- | ||
| + | =[http://exytebuc.co.cc CLICK HERE]= | ||
| + | ---- | ||
| + | </div> | ||
__NOTOC__ | __NOTOC__ | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| Line 8: | Line 16: | ||
== Usage == | == Usage == | ||
| − | pdm_odump | + | pdm_odump <domsrvr_name> <object_factory> <where_clause> [attributes] |
| − | + | <br> | |
{| | {| | ||
|- | |- | ||
| Line 16: | Line 24: | ||
! Remarks | ! Remarks | ||
|- | |- | ||
| − | | | + | | <domsrvr_name> |
| the name of the object engine that is interrogated. | | the name of the object engine that is interrogated. | ||
| '''required''' - usually this is simply '''domsrvr''' | | '''required''' - usually this is simply '''domsrvr''' | ||
| | | | ||
|- | |- | ||
| − | | | + | | <object_factory> |
| the name of the object that you want to dump | | the name of the object that you want to dump | ||
| '''required''' for example 'cr', 'chg', 'alg', 'nr' | | '''required''' for example 'cr', 'chg', 'alg', 'nr' | ||
|- | |- | ||
| − | | | + | | <where_clause> |
| additional filter for the list, has the form of an SQL 'where' clause | | additional filter for the list, has the form of an SQL 'where' clause | ||
| − | | '''required''' - just put | + | | '''required''' - just put "" for an empty clause |
|- | |- | ||
| [attributes] | | [attributes] | ||
| Line 37: | Line 45: | ||
== Examples == | == Examples == | ||
* Dump the Reference number for all Requests: | * Dump the Reference number for all Requests: | ||
| − | bop_odmp domsrvr cr | + | bop_odmp domsrvr cr "" ref_num |
* Dump all Incidents attached to Problem 12 and still active: | * Dump all Incidents attached to Problem 12 and still active: | ||
| − | bop_odump domsrvr in | + | bop_odump domsrvr in " problem.ref_num='12' AND active=1 " |
* Dump all Requests that belong to an Analyst with the username Fred, show the Affected user name: | * Dump all Requests that belong to an Analyst with the username Fred, show the Affected user name: | ||
| − | bop_odump domsrvr cr | + | bop_odump domsrvr cr " assignee.userid='fred' " customer.combo_name |
Revision as of 03:17, 24 November 2010
To make corrections or additions to this article, select the edit tab above.
To discuss or ask questions about this article, select the discussion tab above.
To discuss or ask questions about this article, select the discussion tab above.
Overview
Use this command to dump the object information (attributes) from the database. Not quite as useful as pdm_extract (doesn't support formatting the output and doesn't show by default all fields), but allows the use of references in the object dotted notation.
Usage
pdm_odump <domsrvr_name> <object_factory> <where_clause> [attributes] <br>
| Parameter | Description | Remarks | |
|---|---|---|---|
| <domsrvr_name> | the name of the object engine that is interrogated. | required - usually this is simply domsrvr | |
| <object_factory> | the name of the object that you want to dump | required for example 'cr', 'chg', 'alg', 'nr' | |
| <where_clause> | additional filter for the list, has the form of an SQL 'where' clause | required - just put "" for an empty clause | |
| [attributes] | list of attributes of the object to return from the search | the list of attributes is space separated. |
Examples
- Dump the Reference number for all Requests:
bop_odmp domsrvr cr "" ref_num
- Dump all Incidents attached to Problem 12 and still active:
bop_odump domsrvr in " problem.ref_num='12' AND active=1 "
- Dump all Requests that belong to an Analyst with the username Fred, show the Affected user name:
bop_odump domsrvr cr " assignee.userid='fred' " customer.combo_name
