Bookshelf Home | Contents | Index | PDF |
Siebel Mobile Connector Guide > Working with the Siebel Mobile Connector > Real-Time Access to Data > Retrieving DataThis section describes how to retrieve data from SWE by using the XML Web Interface. Included is an overview of navigating to a screen, navigating within a screen, as well as information about queries and updates. Navigating to a ScreenNavigating to a screen is required to retrieve data about the screen's views and applets. The command GotoPageTab is used to go to a specific screen.
NOTE: GotoPageTab executes the default PDQ (predefined query) for that screen. The following is a list of screens provided in the Siebel Mobile Connector application definition to which you can navigate. Navigating Within a ScreenNavigating within a screen is required to perform an action on data from a screen's views and applets. You can use to the GotoView command to go to a particular Siebel view, where you can access the applets available to that view. The GotoView command requires the name of the view to be passed in the SWEView parameter. To navigate to a view or applet
For a list of the view and applet names to which you can navigate, see SMC Application Definition Quick Reference. Querying ItemsTo perform a query, you must navigate to the screen that allows queries and then you must send two separate requests to SWE. In the ExecuteQuery command block, you must specify a parameter to identify the column (the field you want to search) and a value to indicate the search criteria.
For a list of the view anapplet names to which you can navigate, see SMC Application Definition Quick Reference. Drilling Down on ItemsYou can drill down on a field by specifying the name of the applet field on which you want to drill down. The detailed information about the field is retrieved from the repository. In this way you can retrieve detailed information about specific items in applets on which you have queried.
For a list of the field names on which you can drill down, see SMC Application Definition Quick Reference. Executing Pre-Defined Queries (PDQs)You can execute pre-defined queries from your applications. You must invoke the ExecuteNamedQuery method and pass the name of the PDQ you want to apply.
Retrieving Large Data SetsIt may be necessary for an application to retrieve a very large set of data, or to obtain all the records in a set. You can retrieve large data sets by using the SWESetRowCnt parameter in your request to SWE. Set the parameter to a large number such as 100 to obtain up to 100 records. If you set the SWESetRowCnt parameter to a large number, it will take longer to get a response back from SWE and the performance may not be acceptable to your end user if this is a real-time action taken on their behalf. You can set the SWESetRowCnt parameter to a smaller number to improve performance, but check the results to see if there are additional records.
To retrieve all the records in a large set
Parsing Dates on RecordsApplications may need to parse the dates and times on records to perform operations on the data. Many fields contain date stamp information according to formats specified in the Siebel application definition. Your application must read the format specified in the FORMAT attribute to parse dates on records. In the following examples the date format is M/D/YYYY hh:mm:ss p and M/D/YYYY hh:mm p: <CONTROL HTML_TYPE="Field" CAPTION="Created" SCALE="0" DATATYPE="utcdatetime" HIDDEN="TRUE" NUMBER_BASED="FALSE" ID="1310" TYPE="TextBox" REQUIRED="TRUE" TEXT_BASED="FALSE" FORMAT="M/D/YYYY hh:mm:ss p" CALCULATED="FALSE" ENABLED="TRUE" MAX_LENGTH="32" NAME="Created">12/31/1979 04:00:00 PM</CONTROL> <CONTROL HTML_TYPE="Field" CAPTION="Start" SCALE="0" DATATYPE="utcdatetime" HIDDEN="FALSE" NUMBER_BASED="FALSE" ID="1801" TYPE="TextBox" REQUIRED="FALSE" TEXT_BASED="FALSE" FORMAT="M/D/YYYY hh:mm p" CALCULATED="FALSE" ENABLED="TRUE" MAX_LENGTH="32" NAME="Planned">8/12/1999 03:00 PM</CONTROL> NOTE: The FORMAT attribute uses the standard Siebel date format specification. For example, to indicate the month of March, a single capital M indicates that the month is represented by "3"; MM indicates "03"; MMM indicates "Mar"; and MMMM indicates "March." Retrieving Data from Hidden FieldsIn Siebel application definitions, some form applets are not entirely visible by default. On the user interface, the user must click the toggle button to switch between views of the form applet. When retrieving data from these forms, by default SWE will only return data from the visible fields. If you want data from the hidden fields, use the ToggleLayout command. The following example shows a SWE request for toggling the layout: http://localhost/start.swe?SWECmd=InvokeMethod&SWEApplet=Account+Entry+Applet&SWEView=Account Attachment+View&SWERowId=99-28B1T&SWENeedContext=true&SWEReqRowId=0&SWEMethod=ToggleLayout&SWESetMarkup=XML |
Siebel Mobile Connector Guide | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |