Customized TablePane for browsing SQL tables. More...


Public Member Functions | |
| _.Library.Status | DrawBODY (_.CSP.Util.PageInstance pInstance) |
| Draw the BODY of the detail pane. | |
| _.Library.Status | ExecuteResultSet (_.Library.ResultSet pRS, _.Library.String pID) |
| This method performs the actual execution of the ResultSet. More... | |
| _.Library.String | GetPageType () |
| This method returns the page type based on PageName. | |
| _.Library.Status | OnDrawFilter (_.CSP.Util.PageInstance pInstance) |
| This callback draws the search mask within the filter box. | |
Public Member Functions inherited from TablePane | |
| _.Library.Status | CreateDataSet (_.Library.String pID, _.Library.String pFileID, _.Library.String pTempID) |
| Runs the query and builds a temp file. | |
| _.Library.Status | CreateResultSet (_.Library.String pID, _.Library.ResultSet pRS) |
| This method creates the ResultSet object. More... | |
| _.Library.Status | CreateTempFile (_.Library.String pFileID, _.Library.String pTempID, _.Library.String pID, _.Library.ResultSet pRS) |
| Execute a result set and create a temp file. | |
| _.Library.Status | DrawBODY (_.CSP.Util.PageInstance pInstance) |
| Draw the BODY of the detail pane. | |
| _.Library.Status | DrawHEAD (_.CSP.Util.PageInstance pInstance) |
| Overwritten by subclasses to draw anything this pane needs for the HEAD section. | |
| DrawLastUpdate () | |
| Show Last Update box. | |
| _.Library.Status | DrawSearch (_.CSP.Util.PageInstance pInstance) |
| This callback is invoked when specific or advanced search criteria is being drawn to. More... | |
| _.Library.Status | DrawTable (_.CSP.Util.PageInstance pInstance, _.Library.String pID, _.Library.String pFileID, _.Library.String pTempID, _.Library.Integer pPageNo, _.Library.String pSort, _.Library.Integer pDirection, _.Library.String pFilter, _.Library.String pCBState, _.Library.String pFound) |
| Generate JavaScript to draw the table. More... | |
| GetDescriptiveText () | |
| Return (localized) text message displayed near top of page. More... | |
| _.Library.Integer | GetItemsPerPage () |
| Returns default items per page value. | |
| _.Library.Status | OnDrawFilter (_.CSP.Util.PageInstance pInstance) |
| This callback is invoked when the table filter is being drawn to. More... | |
| _.Library.String | OnGenerateCode () |
| Subclasses override this to generate code during CSP processing. | |
| def | __init__ (self) |
| Max number of columns to show. More... | |
Public Member Functions inherited from Pane | |
| _.Library.Status | DrawCommandForm (_.CSP.Util.PageInstance pInstance) |
| Generic method to draw a command form for a pane. | |
| _.Library.Status | DrawCommands (_.CSP.Util.PageInstance pInstance) |
| Generic method to draw commands for a pane;. More... | |
| _.Library.String | GenerateCode () |
| Called by CSP rules engine to generate code to construct an instance. More... | |
Public Member Functions inherited from RegisteredObject | |
| _.Library.Status | OnAddToSaveSet (_.Library.Integer depth, _.Library.Integer insert, _.Library.Integer callcount) |
| This callback method is invoked when the current object is added to the SaveSet,. More... | |
| _.Library.Status | OnClose () |
| This callback method is invoked by the <METHOD>Close</METHOD> method to. More... | |
| _.Library.Status | OnConstructClone (_.Library.RegisteredObject object, _.Library.Boolean deep, _.Library.String cloned) |
| This callback method is invoked by the <METHOD>ConstructClone</METHOD> method to. More... | |
| _.Library.Status | OnNew () |
| This callback method is invoked by the <METHOD>New</METHOD> method to. More... | |
| _.Library.Status | OnValidateObject () |
| This callback method is invoked by the <METHOD>ValidateObject</METHOD> method to. More... | |
Public Member Functions inherited from Adaptor | |
| _.Library.Status | XMLExport (_.Library.String top, _.Library.String format, _.XML.Namespaces namespaces, attrs, _.Library.String createId, _.Library.String typeAttr, oreflist, idlist, _.Library.String initialIndent, _.Library.Boolean local, _.Net.MIMEPart mimeAttachments) |
| Serialize an XML enabled class as an XML document and write. More... | |
| _.Library.Status | XMLExportToStream (_.Stream.Object export, _.Library.String top, _.Library.String format, _.XML.Namespaces namespaces, attrs, _.Library.String createId, _.Library.String typeAttr, oreflist, idlist, _.Library.String initialIndent) |
| Serialize an XML enabled class as an XML document and appends it to a stream. More... | |
| _.Library.Status | XMLExportToString (_.Library.String export, _.Library.String top, _.Library.String format, _.XML.Namespaces namespaces, attrs, _.Library.String createId, _.Library.String typeAttr, oreflist, idlist, _.Library.String initialIndent) |
| Serialize an XML enabled class as an XML document and write it to a string. More... | |
Static Public Member Functions | |
| _.Library.Integer | GetOpenTableMaxRows () |
| Returns default OpenTableMaxRows value. | |
| _.Library.String | GetSearchMask () |
| Generic Method being called from the Routine panes to return search mask. | |
| OpenTableMaxRowsUpdate (_.Library.Integer OpenTableMaxRows) | |
| Called from client to update OpenTableMaxRows. | |
Static Public Member Functions inherited from TablePane | |
| DrawStatusError (_.Library.String tSC) | |
| Generic method to draw error message for object status code. | |
| FilterTable (_.Library.Integer pPageNo, _.Library.Integer pTimeSlot, _.Library.String pTempID, _.Library.String pSort, _.Library.String pDirection, _.Library.String pFilter, _.Library.String pPageClass, _.Library.String pFrame, _.Library.String pCBState, pID1, pID2, _.Library.String pNS) | |
| Called from client to refilter the table. | |
| ItemsPerPageUpdate (_.Library.Integer pPageSize) | |
| Called from client to update ItemsPerPage. | |
| _.Library.String | LocalizeColumnName (_.Library.String pName, pHelpMsg) |
| Lookup a column name in the localization global and return localized. More... | |
| PurgeTempData () | |
| Purge all out-of-date temp data used by TablePane. | |
| RefreshTable (_.Library.Integer pPageNo, _.Library.Integer pTimeSlot, _.Library.String pTempID, _.Library.String pSort, _.Library.String pDirection, _.Library.String pFilter, _.Library.Boolean pAuto, _.Library.String pPageClass, _.Library.String pFrame, _.Library.String pCBState, _.Library.String pID1, _.Library.String pID2, _.Library.String pNS, _.Library.Integer pRate) | |
| Called from client to refresh the table. | |
Static Public Member Functions inherited from Pane | |
| _.Library.String | LocalizeText (_.Library.String pText, _.Library.String pDomain) |
| Return the localized version of the string pText. More... | |
| _.Library.String | QuoteCOS (_.Library.String pText) |
| Return a quoted, COS version of a string. | |
Static Public Member Functions inherited from Adaptor | |
| _.Library.Status | XMLDTD (_.Library.String top, _.Library.String format, _.Library.Boolean input, dtdlist) |
| Write the DTD to the current device for this XML enabled class serialized as. More... | |
| _.Library.RegisteredObject | XMLNew (_.XML.Document document, _.Library.Integer node, _.Library.RegisteredObject containerOref) |
| Get an instance of an XML enabled class. More... | |
| _.Library.Status | XMLSchema (_.Library.String top, _.Library.String format, _.Library.String namespacePrefix, _.Library.Boolean input, _.Library.Boolean refOnly, schema) |
| Write an XML Schema fragment to the current device which describes an XML enabled class and dependent classes. More... | |
| _.Library.String | XMLSchemaNamespace () |
| Get the namespace to which this class belongs for use in schema generation. More... | |
| _.Library.Status | XMLSchemaType (_.XML.Schema schemaInstance, _.XML.Node node, _.Library.String top, _.Library.Boolean encoded, _.Library.Boolean summary, _.Library.Boolean input, _.Library.Boolean refOnly) |
| Add a complexType to the schema that is respresented by an <class>XML.Schema</class> instance. More... | |
Static Public Attributes | |
| HIDEFILTERWHENEMPTY = None | |
| display filter box when there are no results so that user can adjust their mask for tables. | |
Static Public Attributes inherited from TablePane | |
| COLUMNDOMAIN = None | |
| This class is used internally by InterSystems IRIS. More... | |
| COLUMNHELPDOMAIN = None | |
| Default localization domain used for column headers help messages. | |
| HIDEFILTERWHENEMPTY = None | |
| Do not display filter box when there are no results. | |
| RefreshRate = None | |
| Default refresh rate (in milliseconds) | |
| SHOWSEARCHFORM = None | |
| Show advanced search form. | |
| SHOWSQLINFO = None | |
| Should this page display SQL Info. | |
| SHOWSTATISTICS = None | |
| Should this page display timing stats. | |
| WrapLimit = None | |
| Default wrap limit. | |
Static Public Attributes inherited from Pane | |
| DOMAIN = None | |
| Default Localization Domain. | |
Static Public Attributes inherited from RegisteredObject | |
| CAPTION = None | |
| Optional name used by the Form Wizard for a class when generating forms. More... | |
| JAVATYPE = None | |
| The Java type to be used when exported. | |
| PROPERTYVALIDATION = None | |
| This parameter controls the default validation behavior for the object. More... | |
Static Public Attributes inherited from Adaptor | |
| ATTRIBUTEQUALIFIED = None | |
| ATTRIBUTEQUALIFIED controls the format of exported XML by controlling whether attributes. More... | |
| ELEMENTQUALIFIED = None | |
| ELEMENTQUALIFIED controls the format of exported XML. More... | |
| NAMESPACE = None | |
| NAMESPACE specifies the XML namespace to be used when projecting the. More... | |
| SUPPRESSTYPEPREFIX = None | |
| SUPPRESSTYPEPREFIX allows the type name that refers to this class. More... | |
| XMLDEFAULTREFERENCE = None | |
| XMLDEFAULTREFERENCE specifies the default value of the XMLREFERENCE property parameter. More... | |
| XMLENABLED = None | |
| If this parameter is true then XML-enabling methods. More... | |
| XMLFORMAT = None | |
| The XMLFORMAT parameter controls the generation of the XMLExport and XMLImport. More... | |
| XMLIGNOREINVALIDATTRIBUTE = None | |
| The XMLIGNOREINVALIDATTRIBUTE parameter allows the programmer to control handling of unexpected. More... | |
| XMLIGNOREINVALIDTAG = None | |
| The XMLIGNOREINVALIDTAG parameter allows the programmer to control handling of unexpected. More... | |
| XMLIGNORENULL = None | |
| XMLIGNORENULL allows the programmer to override the default XML handling. More... | |
| XMLINCLUDEINGROUP = None | |
| XMLINCLUDEINGROUP allows the programmer to control whether a class is included. More... | |
| XMLINHERITANCE = None | |
| If the XMLINHERITANCE parameter is set to "LEFT", then in the case of multiple. More... | |
| XMLNAME = None | |
| This parameter provides the default XMLNAME for the class. More... | |
| XMLNIL = None | |
| The XMLNIL class parameter controls the use of xsi:nil by XMLExport. More... | |
| XMLNILNOOBJECT = None | |
| The XMLNILNOOBJECT parameter allows creation of an object to be skipped for elements. More... | |
| XMLPREFIX = None | |
| The XMLPREFIX parameter controls the prefix to be used for the XML namespace that. More... | |
| XMLSEQUENCE = None | |
| If the XMLSEQUENCE = 1, then the order of the XML elements must match the. More... | |
| XMLSUMMARY = None | |
| The summary fields to be used when an object is referenced are specified. More... | |
| XMLTYPE = None | |
| This parameter provides the default XMLTYPE for the class. More... | |
| XMLUNSWIZZLE = None | |
| If the XMLUNSWIZZLE parameter is set to 1, then single object. More... | |
| XMLUSEEMPTYELEMENT = None | |
| If the XMLUSEEMPTYELEMENT parameter is set to 1, then the empty element shorthand (<tag>) More... | |
Additional Inherited Members | |
Public Attributes inherited from TablePane | |
| Actions | |
| An array of actions, indexed by column name in the query. More... | |
| AutoRefresh | |
| If true, then this table is automatically updated. More... | |
| CheckboxId | |
| If set, name of column that provides unique id values for checkboxes. More... | |
| Conditions | |
| A list of conditions; these are expressions that. More... | |
| HiddenColumns | |
| Comma-separated list of columns that should not be displayed. More... | |
| ItemsPerPage | |
| Number of items to show per page. More... | |
| MaxColumns | |
| MaxResults | |
| Max number of results to find. More... | |
| Query | |
| Name of the class query that provides info for the Table. More... | |
| SQLQuery | |
| Optional SQL query for this table. More... | |
| ShowCheckboxes | |
| If true, then checkboxes are displayed with each row. More... | |
| ShowFilter | |
| If true, then display the Filter box. More... | |
| ShowLastUpdate | |
| Show Last Update box (if set to 0 then do not show last update box) More... | |
| ShowRowNumbers | |
| If true, then rows numbers are displayed. More... | |
| ShowSearchPage | |
| ShowZebra | |
| If true, then rows are displayed using zebra styling. More... | |
| Sortable | |
| If true, then rows in the table can be sorted. More... | |
| bgcolor | |
| Table background color. More... | |
| border | |
| Border of table (default is 0) More... | |
| cellpadding | |
| Cellpadding (default is 0) More... | |
| cellspacing | |
| Cellspacing (default is 0) More... | |
Public Attributes inherited from Pane | |
| Align | |
| Suggestion for how to align this pane; Actual implementation is up. More... | |
| CommandFormClass | |
| Name of class used to provide an option CommandForm: a form. More... | |
| CommandFormObject | |
| Used to hold the object instance for the command form. More... | |
| CommandSubmitPage | |
| Page (URL) to go to when the command form is submitted. More... | |
| Commands | |
| A list of commands; these are actions that. More... | |
| FrameStyle | |
| Optional Style Sheet for a pane; Set to "none" to supress style-sheet for a fram. More... | |
| Name | |
| Transient: name of the pane/frame this pane is being used for. More... | |
| Styles | |
| Arbitrary array of styles (name/value pairs). More... | |
| Text | |
| Test for this pane. More... | |
| URL | |
| Optional URL to display instead of this pane (for frame-pages) More... | |
Public Attributes inherited from abstractRefreshable | |
| enableAutoRefresh | |
| True if pages in the management portal are permitted to use auto-refresh behaviour. More... | |
Customized TablePane for browsing SQL tables.
Added textbox to allow user to enter maximum number of rows to load for Open Table
| _.Library.Status ExecuteResultSet | ( | _.Library.ResultSet | pRS, |
| _.Library.String | pID | ||
| ) |
This method performs the actual execution of the ResultSet.
pID(3) is the searchMask from user clicking the "Go" rather than user clicking a schema which sets $ID(2). If it is from Go then it is possible user removed the mask then default to "*". Otherwise retain the last mask.
Reimplemented from TablePane.