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. | |
![]() | |
_.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... | |
![]() | |
_.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... | |
![]() | |
_.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... | |
![]() | |
_.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. | |
![]() | |
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. | |
![]() | |
_.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. | |
![]() | |
_.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. | |
![]() | |
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. | |
![]() | |
DOMAIN = None | |
Default Localization Domain. | |
![]() | |
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... | |
![]() | |
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 | |
![]() | |
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... | |
![]() | |
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... | |
![]() | |
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.