Bop odump - Revision history

Gityerfix: Reverted edits by Agegeleruvy (Talk); changed back to last version by Gityerfix

2010-11-30T05:28:27Z

Reverted edits by Agegeleruvy (Talk); changed back to last version by Gityerfix

Agegeleruvy at 03:17, 24 November 2010

2010-11-24T03:17:38Z

Gityerfix at 03:28, 27 July 2008

2008-07-27T03:28:07Z

Gityerfix at 06:48, 26 July 2008

2008-07-26T06:48:39Z

Gityerfix at 15:54, 18 July 2008

2008-07-18T15:54:06Z

Mitcr01 at 20:10, 11 February 2008

2008-02-11T20:10:46Z

Mitcr01 at 20:09, 11 February 2008

2008-02-11T20:09:23Z

Mitcr01 at 20:07, 11 February 2008

2008-02-11T20:07:59Z

Mitcr01 at 20:03, 11 February 2008

2008-02-11T20:03:25Z

Mitcr01: New page: == Usage == pdm_odump [attributes]
{| |- ! Parameter ! Description ! Remarks |- | | the name of the object engine that is...

2008-02-11T19:49:14Z

New page: == Usage == pdm_odump <domsrvr_name> <object_factory> <where_clause> [attributes] <br> {| |- ! Parameter ! Description ! Remarks |- | <domsrvr_name> | the name of the object engine that is...

New page

== 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 Requests attached to Problem 12 and still active
bop_odump domsrvr cr " problem.ref_num='12' AND active=1 "

* Dump all Requests that belong to an Analyst with the username Fred, show only the close date
bop_odump domsrvr cr " assignee.userid='fred' " close_date

----
<div align='center'><font color="red">To make corrections or additions to this article, select the ''edit'' tab above.<br>
To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>

[[Category:Commands|Commands man]]

@@ Line 1: / Line 1: @@
 __NOTOC__
 [[Category:Commands]]
@@ Line 16: / Line 8: @@
 == Usage ==
-pdm_odump &lt;domsrvr_name&gt; &lt;object_factory&gt; &lt;where_clause&gt; [attributes]
+pdm_odump <domsrvr_name> <object_factory> <where_clause> [attributes]
-&lt;br&gt;
+<br>
 {|
 |-
@@ Line 24: / Line 16: @@
 ! Remarks
 |-
-| &lt;domsrvr_name&gt;
+| <domsrvr_name>
 | the name of the object engine that is interrogated.
 | '''required''' - usually this is simply '''domsrvr'''
+|
 |-
-| &lt;object_factory&gt;
+| <object_factory>
 |  the name of the object that you want to dump
 | '''required''' for example 'cr', 'chg', 'alg', 'nr'
 |-
-| &lt;where_clause&gt;
+| <where_clause>
 | additional filter for the list, has the form of an SQL 'where' clause
-| '''required''' -  just put &quot;&quot; for an empty clause
+| '''required''' -  just put "" for an empty clause
 |-
 | [attributes]
@@ Line 45: / Line 37: @@
 == Examples ==
 * Dump the Reference number for all Requests:
-  bop_odmp domsrvr cr &quot;&quot; ref_num
+  bop_odmp domsrvr cr "" ref_num
 * Dump all Incidents attached to Problem 12 and still active:
-  bop_odump domsrvr in &quot; problem.ref_num='12' AND active=1 &quot;
+  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 &quot; assignee.userid='fred' &quot; customer.combo_name
+  bop_odump domsrvr cr " assignee.userid='fred' " customer.combo_name

@@ Line 1: / Line 1: @@
 __NOTOC__
 [[Category:Commands]]
-<div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br>
+{{Global Header}}
-To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>
+{{Global Announcement}}
 == Overview ==

@@ Line 1: / Line 1: @@
 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.
@@ Line 26: / Line 32: @@
 |  list of attributes of the object to return from the search
 |  the list of attributes is space separated.
 |-
 |}
 == Examples ==
@@ Line 40: / Line 44: @@
 * 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

@@ Line 40: / Line 40: @@
 * 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
 ----
-<div align='center'><font color="red">To make corrections or additions to this article, select the ''edit'' tab above.<br>
+<div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br>
 To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>
 [[Category:Commands|Commands man]]

@@ Line 32: / Line 32: @@
 == Examples ==
-* Dump the Reference number for all Requests
+* Dump the Reference number for all Requests:
   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 " problem.ref_num='12' AND active=1 "
-* Dump all Requests that belong to an Analyst with the username Fred, show only the close date
+* Dump all Requests that belong to an Analyst with the username Fred, show the Affected user name:
-  bop_odump domsrvr cr " assignee.userid='fred' " close_date
+  bop_odump domsrvr cr " assignee.userid='fred' " customer.combo_name

← Older revision		Revision as of 20:09, 11 February 2008
Line 1:		Line 1:
−	Use this command to dump the object information (attributes) from the database. Not quite as useful as [[pdm_extract]] (doesn't ~~allow~~ formatting and doesn't ~~output~~ by default all fields), but allows the use of references in the object dotted notation.	+	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 ==		== Usage ==

← Older revision		Revision as of 20:07, 11 February 2008
Line 1:		Line 1:
		+	Use this command to dump the object information (attributes) from the database. Not quite as useful as [[pdm_extract]] (doesn't allow formatting and doesn't output by default all fields), but allows the use of references in the object dotted notation.
		+
	== Usage ==		== Usage ==
	pdm_odump <domsrvr_name> <object_factory> <where_clause> [attributes]		pdm_odump <domsrvr_name> <object_factory> <where_clause> [attributes]