Creating Object Query Indexes

Add indexes to object queries from the Properties view.

When creating indexes, the order in which you specify the attributes becomes the order in which the attributes appear in the index. Duplicate references to column names in the index definition are not allowed.

  1. In the Mobile Application Diagram, right-click the MBO, and select Show Properties View. Alternatively, click in the MBO title header to open the associated MBO properties view.
  2. In the Properties view, select the Attributes tab, then select the Object Queries tab.
  3. You can either:
    • Add an index to an existing object query – highlight the object query and select Edit. You cannot edit the findByPrimaryKey object query.
    • Create a new object query and add an index – select Add. This requires that a parameter be mapped to an attribute, which allows the index in the query to be generated.
  4. Define the query in the Query Definition window.
  5. Select Create an index. Unwired WorkSpace generates an index based on the query definition.