DOC

cornerstone update

By Roberta Jones,2014-08-30 02:08
23 views 0
cornerstone update

Implementation Development RETS Extensions

    Cornerstone RETS Extensions

    Implementation Guide

    Created: June 4, 2006

Version 0.5 Saved: 2011-08-30 Page 1 of 44

    250851189.doc ?2005 Templates 4 Business Inc. All Rights Reserved.

    Implementation Development RETS Extensions

    DOCUMENT INFORMATION

     Customer MRIS

    Project Cornerstone

    Development Team

     Sergio Del Rio Author

    1.0 Version

    Status Production

    H:\Applic\platinum\doc\Cornerstone Update Course Material.doc Filename

     Diagrams

    HISTORY

    Version Date Description of changes

     1.0 04-May-2006 Initial Creation Derived from Cornerstone Update Design Document.

    1.1 19-Jul-2006 Updated Join section to reflect latest coding changes.

    Last saved by Sergio Del Rio on 8/30/2011 2:08:00 AM

    Version 0.5 Saved: 2011-08-30 Page 2 of 44

    250851189.doc ?2005 Templates 4 Business Inc. All Rights Reserved.

Implementation Development RETS Extensions

Table of Contents

    1 INTRODUCTION ............................................................................................................. 5 1.1 DOCUMENT PURPOSE ................................................................................................... 5 1.2 AUDIENCE.................................................................................................................... 5 1.3 DOCUMENT CONVENTIONS .......................................................................................... 5 1.4 REFERENCES ................................................................................................................ 5 2 METADATA EXTENSIONS ............................................................................................ 6 2.1 EXISTING METADATA EXTENSIONS .............................................................................. 6 2.1.1 METADATA-CLASS ............................................................................................. 6 2.1.2 METADATA-TABLE ............................................................................................ 6 2.1.3 METADATA-LOOKUP_TYPE ............................................................................. 7 2.1.4 METADATA-UPDATE ......................................................................................... 7 2.1.5 METADATA-UPDATE_TYPE .............................................................................. 7 2.1.6 METADATA-FOREIGNKEYS .............................................................................. 8 2.1.7 METADATA-VALIDATION_LOOKUP_TYPE ...................................................... 9 2.1.8 METADATA-VALIDATION_EXPRESSION .......................................................... 9 2.1.9 METADATA-VALIDATION_EXTERNAL ............................................................. 9 2.1.10 METADATA-VALIDATION_EXTERNAL_TYPE................................................. 10 2.2 LOOKUP METADATA EXTENSIONS.............................................................................. 11 2.2.1 METADATA-LOOKUP_PARENT ...................................................................... 11 2.2.2 METADATA-LOOKUP_TYPE_BY_PARENT ..................................................... 12 2.3 PRESENTATION METADATA EXTENSIONS ................................................................... 15 2.3.1 METADATA-COLUMN_GROUP_SET............................................................... 15 2.3.2 METADATA-COLUMN_GROUPS ..................................................................... 18 2.3.3 METADATA-COLUMN_GROUP_CONTROL .................................................... 19 2.3.4 METADATA-COLUMN_GROUP_TABLE .......................................................... 21 2.3.5 METADATA-COLUMN_GROUP_NORMALIZATION ....................................... 23 2.4 LOCALIZATION METADATA EXTENSIONS ................................................................... 26 2.4.1 METADATA-LOCALE_LOOKUP ...................................................................... 26 2.4.2 METADATA-LOCALE ....................................................................................... 27 2.4.3 METADATA-LOCALE_TABLE_SUPPRESSION ................................................ 29 2.4.4 METADATA-LOCALE_TABLE_TRANSLATION ................................................ 30 2.4.5 METADATA-LOCALE_LOOKUP_INFORMATION ........................................... 32 2.4.6 METADATA-LOCALE_LOOKUP_TYPE_SUPPRESSION ................................. 34 2.4.7 METADATA-LOCALE_LOOKUP_TYPE_TRANSLATION ................................. 36 3 RETS EXTENSIONS ...................................................................................................... 38 3.1 RETS SORT EXTENSION ............................................................................................. 38 3.2 RETS DISTINCT SEARCH ARGUMENT EXTENSION ...................................................... 38 3.3 RETS AGGREGATE FUNCTION EXTENSION ................................................................. 39 3.3.1 The Select Request Argument.............................................................................. 39 3.3.2 Return Data Format ........................................................................................... 39

    3.3.2.1 Compact and Compact Decoded Output ......................................................... 40

    3.3.2.2 XML Output .................................................................................................. 40 Version 0.5 Saved: 2011-08-30 Page 3 of 44 250851189.doc ?2005 Templates 4 Business Inc. All Rights Reserved.

Implementation Development RETS Extensions

    3.3.3 Using Aggregate Functions with Joins ................................................................ 40 3.4 RETS MULTI-RESOURCE JOIN EXTENSION ................................................................. 40

    3.4.1 The Join Request Argument ................................................................................ 41

    3.4.2 Return Data Format ........................................................................................... 42

    3.4.2.1 Compact and Compact Decoded Output ......................................................... 42

    3.4.2.2 XML Output .................................................................................................. 43 Version 0.5 Saved: 2011-08-30 Page 4 of 44 250851189.doc ?2005 Templates 4 Business Inc. All Rights Reserved.

Implementation Development RETS Extensions

1 Introduction

    1.1 Document Purpose

    This Document is intended to provide all relevant details of how MRIS has extended the RETS Metadata to provide clients with more information that will allow the development of fully functional 100% metadata aware products.

    1.2 Audience

    The audience for this document is the stakeholders representing MRIS third party developers. 1.3 Document Conventions

    This document observes the following typographical conventions.

    Data to be stored by MRIS is written in sans serif type, to distinguish it from real world objects

    and attributes that it represents. For example: an appliance is an indoor object, such as a stove or

    washing machine; but an appliance is a collection of data stored in the MRIS database about an appliance. An appliance type is one of the pieces of data in that collection.

    Named data values are written in italic sans serif type. For example, the possible values of

    appliance type are: stove, microwave, refrigerator, washer, drier, trash compactor, dishwasher.

    String literals alphanumeric data to go into the system exactly as shown, such as descriptions

    are written in sans serif type.

    1.4 References

    Tag Document Name Version Date

    RETS Real Estate Transaction Specification 1.7d5 01-SEP-2004

    Version 0.5 Saved: 2011-08-30 Page 5 of 44

    250851189.doc ?2005 Templates 4 Business Inc. All Rights Reserved.

Implementation Development RETS Extensions

2 Metadata Extensions

    2.1 Existing Metadata Extensions

    This section outlines all the existing Cornerstone Metadata Output Formats that have been

    extended for the Update Transaction to be successful.

    The following existing Metadata Output Formats have been extended 2.1.1 METADATA-CLASS

    The following table outlines the extensions to the CLASS metadata that were necessary to allow

    for a dynamically localizable user experience:

    Table 11-7.1 Metadata Content Extensions Class

    Metadata Field Content Type Description

    X-MRIS_LocaleLookupField 1*32ALPHANUM The SystemName of the field in the METADATA-

    TABLE that acts as the Localization field for this

    Class. The value in this field can be used to lookup

    the locale of a Class in METADTA-

    LOCALE_LOOKUP.

    2.1.2 METADATA-TABLE

    The following table outlines the extensions to the TABLE metadata that were necessary to make

    for a better user experience:

    Table 11-9.1 Metadata Content Extensions Table

    Metadata Field Content Type Description

    Interpretation URI An arbitrary URI or URL that is fully qualified and

    that an application will be able to successfully link

    to.

    X-MRIS_MinimumLength Numeric The minimum length that this field is allowed to

    have. This is used in both Search and Update

    transactions.

    X-MRIS_ImmediateRefresh Boolean A truth value which indicates whether a change to

    this field by the user should cause an automatic

    GUI refresh. This is primarily intended for use in

    fields that will be firing server side rules that need

    to be fired immediately.

    X-MRIS_SearchDefault Numeric The order that fields should appear in a default

    search screen that is executed in order to give the

    user a list of existing records to select from. Fields

    that should not appear in the default search screen

    should have a value of 0. Fields that should never Version 0.5 Saved: 2011-08-30 Page 6 of 44

    250851189.doc ?2005 Templates 4 Business Inc. All Rights Reserved.

Implementation Development RETS Extensions

    be visible to the user should have a value of -1.

    X-MRIS_UpperCase Boolean A truth value which indicates whether the server

    stores the data in this text field in all upper case.

    This allows a client to automatically convert data

    in these fields to upper case for both searches and

    queries.

    X-MRIS_BooleanLabels 1*40PLAINTEXT This is only valid for fields that have a Boolean

    Data Type. This is a comma separated list that

    indicates what string values are to be displayed in

    lieu of false and true. The first value is the

    replacement for false and the second value is the

    replacement for true. This is provided to allow GUI

    systems to display more meaningful values to the

    user rather than a simple „False‟ or „True‟, such as

    „No‟ or „Yes‟.

    2.1.3 METADATA-LOOKUP_TYPE

    The following table outlines the extensions to the LOOKUP_TYPE metadata that were necessary

    to make for a better user experience:

     Extensions LookupType Table 11-20.1 Metadata Content

    Metadata Field Content Type Description

    X-MRIS_DisplayOrder 1*5DIGIT The order in which to display the Lookup Type

    within the list for the Lookup.

    2.1.4 METADATA-UPDATE

    The following table outlines the extensions to the UPDATE metadata that were necessary to make

    for a better user experience:

    Table 11-13.1 Metadata Content Extensions Update

    Metadata Field Content Type Description

    UpdateName Additional Values Required: See Table 11-11 in

    RETS document. Update Name Function

    Release Releases the record that was previously

    checked out using the Search

    transaction with the ForUpdate=1

    request argument.

    2.1.5 METADATA-UPDATE_TYPE

    The following table outlines the extensions to the UPDATE_TYPE metadata that are necessary to

    make for a better user experience:

    Version 0.5 Saved: 2011-08-30 Page 7 of 44

    250851189.doc ?2005 Templates 4 Business Inc. All Rights Reserved.

Implementation Development RETS Extensions

Table 11-13.1 Metadata Content Extensions Update Type

    Metadata Field Content Type Description

    Attributes Additional Values Required: See Table 11-13 in

    RETS document. Value Meaning Description

    6 AutopopRequired Indicates that this field

    is mandatory before

    calling Update

    transaction for Auto

    Population.

    7 Hidden Indicates that this field

    may be used in

    ValidationExpressions

    but is to remain hidden

    from the user.

    Default

</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">Default value of field (i.e. value of not specified by user). </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">This field may also contain any valid tokens that are valid </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">in the set of Special Operan</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">d Tokens as specified in the </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">Validation Expression metadata.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">X</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">MRIS_DisplayOrder</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">Numeric</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">The order that fields should appear in a default one</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">line </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">search result that is executed in order to give the user a list </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">of existing records to select from for updat</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">ing them. Fields </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">that should not appear in the default one</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">line format should </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">have a value of 0. Fields that should never be visible to the </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">user should have a value of </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">1.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">X</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">MRIS_SearchOrder</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">Numeric</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">The order that fields should appear in a default search </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">screen that is executed in order to give the user a list of </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">existing record to select from for updating them. Fields that </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">should not appear in the default search screen should have a </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">value of 0. Fields that should never be visible to the user </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">should have a</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">value of </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">1.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">X</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">MRIS_OverrideOnInsert</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">Boolean</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">A truth value which indicates whether an Autopop, </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">ValidationExternal or SET ValidationExpression may be </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">overridden by a user for new data records.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">X</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">MRIS_OverrideOnUpdate</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">Boolean</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">A truth value which indicates</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">whether an Autopop, </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">ValidationExternal or SET ValidationExpression may be </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">overridden by a user when updating data records.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:28.7px;letter-spacing:2.15px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-weight:bold;font-size:17.22px;color:#000000;">2.1.6 METADATA-FOREIGNKEYS </span></p><p style="line-height:24.38px;letter-spacing:1.82px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">The following table outlines the extensions to the METADATA-FOREIGNKEYS metadata that </span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">were necessary to make for a better user experience: </span></p><p style="line-height:24.38px;letter-spacing:1.82px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;">Table 11-5.1</span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;"> Metadata Content </span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">–</span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;"> Extensions </span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">–</span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;"> Metadata ForeignKeys </span></p><p style="line-height:24.38px;letter-spacing:1.82px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;">Metadata Field</span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;">Content Type</span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;">Description</span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">X</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">MRIS_OneToManyFlag</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">Boolean</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">A truth value which indicates whether the foreign </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">key will return multiple rows if queried </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">from the </span></p><p style="line-height:17.51px;letter-spacing:1.31px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">Version </span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:10.5px;color:#000000;">0.5</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">Saved: </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">2011</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">08</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">30</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">Page</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">8</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">of </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">44</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span></p><p style="line-height:17.51px;letter-spacing:1.31px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">250851189.doc</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">?2005 Templates 4 Business Inc. All Rights Reserved.</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span></p><p style="line-height:17.51px;letter-spacing:1.31px;"><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span></p><div> </div></div> </div> </div> <div class="model pannel_mod" data-page="9"> <div id="page9" class="scrollLoading"> <div style="width:100%;height:100%;position:relative"><p style="line-height:17.51px;letter-spacing:1.31px;"><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">Implementation Development </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> RETS Extensions </span></p><p style="line-height:24.38px;letter-spacing:1.82px;"><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;"> </span></p><p style="line-height:24.38px;letter-spacing:1.82px;"><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">source to the destination.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:28.7px;letter-spacing:2.15px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-weight:bold;font-size:17.22px;color:#000000;">2.1.7 METADATA-VALIDATION_LOOKUP_TYPE </span></p><p style="line-height:24.38px;letter-spacing:1.82px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">This has been implemented as specified with the addition of the following extension: </span></p><p style="line-height:24.38px;letter-spacing:1.82px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">The server will accept an additional parameter in the ID in this metadata request. This additional </span></p><p style="line-height:24.38px;letter-spacing:1.82px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">parameter will be the value of a specific parent to return the Validation Lookup Type for. This </span></p><p style="line-height:24.38px;letter-spacing:1.82px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">provides the same functionality as METADATA-LOOKUP_TYPE_BY_PARENT as specified </span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">below. </span></p><p style="line-height:28.7px;letter-spacing:2.15px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-weight:bold;font-size:17.22px;color:#000000;">2.1.8 METADATA-VALIDATION_EXPRESSION </span></p><p style="line-height:24.38px;letter-spacing:1.82px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">The following table outlines the extensions to the METADATA-VALIDATION_EXPRESSION </span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">metadata that were necessary to make for a better user experience: </span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;">Table 11-37.1</span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;"> Metadata Content </span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">–</span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;"> Extensions </span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">–</span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;"> Validation Expression </span></p><p style="line-height:24.38px;letter-spacing:1.82px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;">Metadata Field</span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;">Content Type</span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;">Description</span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">X</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">MRIS_ConditionalValue</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">1*512TEXT</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">A test e</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">xpression that is to be executed before </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">attempting to execute the Value expression. If this </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">expression evaluates to TRUE, the Value </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">expression is to be executed. If it evaluates to </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">false, the Value expression is NOT to be executed.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">X</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">MRIS_Message</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">1*512TE</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">XT</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">A message to be displayed in the following cases:</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">1. Expression Type of ACCEPT results in FALSE.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">2. Expression Type of REJECT results in TRUE.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">3. Expression Type of WARNING results in </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">TRUE.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">X</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">MRIS_EventType</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">1*30TEXT</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">One of the following values:</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">;</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">NEW </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">–</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">E</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">xpression is to be applied only </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">when a new blank record is first created.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">;</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">INSERT </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">–</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">Expression is to be applied </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">only for new records.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">;</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">UPDATE </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">–</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">Expression is to be applied </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">only for existing records being edited.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">;</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">MODIFY </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">–</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">Expression is to be applied </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">for both </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">new and existing records.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">;</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">DELETE </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">–</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">Expression is to be applied </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">only when the record is about to be </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">deleted.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:28.7px;letter-spacing:2.15px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-weight:bold;font-size:17.22px;color:#000000;">2.1.9 METADATA-VALIDATION_EXTERNAL </span></p><p style="line-height:24.38px;letter-spacing:1.82px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">The following table outlines the extensions to the METADATA-VALIDATION_EXTERNAL </span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">metadata that were necessary to make for a better user experience: </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">Version </span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:10.5px;color:#000000;">0.5</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">Saved: </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">2011</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">08</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">30</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">Page</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">9</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">of </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">44</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span></p><p style="line-height:17.51px;letter-spacing:1.31px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">250851189.doc</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">?2005 Templates 4 Business Inc. All Rights Reserved.</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span></p><p style="line-height:17.51px;letter-spacing:1.31px;"><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span></p><div> </div></div> </div> </div> <div class="model pannel_mod" data-page="10"> <div id="page10" class="scrollLoading"> <div style="width:100%;height:100%;position:relative"><p style="line-height:17.51px;letter-spacing:1.31px;"><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">Implementation Development </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> RETS Extensions </span></p><p style="line-height:24.38px;letter-spacing:1.82px;"><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;"> </span></p><p style="line-height:24.38px;letter-spacing:1.82px;"><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;"> </span></p><p style="line-height:24.38px;letter-spacing:1.82px;"><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;">Table 11-38.1</span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;"> Metadata Content </span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">–</span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;"> Extensions </span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">–</span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;"> Validation External </span></p><p style="line-height:24.38px;letter-spacing:1.82px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;">Metadata Field</span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;">Content Type</span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;">Description</span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">X</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">MRIS_AutoQuery</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">Boolean</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">If true, there is no need to display an intermediary </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">query screen to the user before executing </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">a query </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">(after restricting query with X</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">MRIS_RestrictFields) on the external resource. If </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">false, then such a query would return too many </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">rows; in this case, the interface should allow the </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">user to further refine the search by entering data </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">into any of the </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">specified SearchFields before </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">executing the query.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">In either case, the user SHOULD be allowed to </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">further refine the query after they are given the </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">initial list of results.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">X</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">MRIS_AllowDirectEntry</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">Boolean</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">If true, users should be allowed to enter data into</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">all enterable fields that are being auto</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">filled based </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">on the ResultFields of the ValidationExternalType </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">metadata. In this case, the X</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">MRIS_OverrideOnInsert and X</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">MRIS_OverrideOnUpdate field settings must still </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">be honoured.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">If false, all fields are not d</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">irectly enterable by a </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">user and are only auto</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">filled based on the </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">ResultFields of the ValidationExternalType </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">metadata.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">X</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">MRIS_AllowInvalidData</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">Boolean</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">If true, users are not required to enter only valid </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">data into all fields that are in the X</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">MRIS_LookupBu</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">ttons list.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">If false, users MUST enter only valid data into all </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">fields that are in the X</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">MRIS_LokupButtons list.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:28.7px;letter-spacing:2.15px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-weight:bold;font-size:17.22px;color:#000000;">2.1.10 METADATA-VALIDATION_EXTERNAL_TYPE </span></p><p style="line-height:24.38px;letter-spacing:1.82px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">The following table outlines the extensions to the METADATA-</span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">VALIDATION_EXTERNAL_TYPE metadata that were necessary to make for a better user </span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">experience: </span></p><p style="line-height:24.38px;letter-spacing:1.82px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;">Table 11-40.1</span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;"> Metadata Content </span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">–</span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;"> Extensions </span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;">–</span><span style="font-family:Microsoft YaHei;font-size:14.63px;color:#000000;"> Validation External Type </span></p><p style="line-height:24.38px;letter-spacing:1.82px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;">Metadata Field</span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;">Content Type</span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;">Description</span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:14.63px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">X</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">MRIS_RestrictFields</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">1*1024PLAINTEXT</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">A comma separated list of valid field pairs joined </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">by = (equal</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">) the first is a target field in the table </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">being updated and the second is a source field in </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">the table being searched. The fields use a </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">SystemName from Section 11.3.2.</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;"><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;"><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">If values have been entered in the table being </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">updated for any of the above fields, the</span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">query </span></p><p style="line-height:22.27px;letter-spacing:1.67px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:13.36px;color:#000000;">executed on the source table must be restricted to </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">Version </span><span style="font-family:Microsoft YaHei;font-weight:bold;font-size:10.5px;color:#000000;">0.5</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">Saved: </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">2011</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">08</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">-</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">30</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">Page</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">10</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">of </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">44</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span></p><p style="line-height:17.51px;letter-spacing:1.31px;">&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">250851189.doc</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;">?2005 Templates 4 Business Inc. All Rights Reserved.</span><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span></p><p style="line-height:17.51px;letter-spacing:1.31px;"><span style="font-family:Microsoft YaHei;font-size:10.5px;color:#000000;"> </span></p><div> </div></div> </div> </div> </div> </div> </div> <div id="doc_sidebar" class="doc_sider"> <div class="doc_sider_inner"> <div id="relativeAjax" class="relative_mod"> </div> <div class="report_mod"> <p class="report_bd"><a href="javascript:void(0);" id="report" title="Report this document">Report this document <span class="icon icon_report"></span></a></p> <p>For any questions or suggestions please email <br /><a href="mailto:cust-service@docsford.com" title="cust-service@docsford.com">cust-service@docsford.com</a></p> </div> <!--advertisement--> <!-- <div class="right_ad_mod"> <div class="m1"> </div> </div> --> </div> </div> </div> </div> </div> <script type="text/javascript"> var picture_image_path_v1 = "http://st.docsford.com"; </script> <script type="text/javascript" src="http://www.docsford.com/js/jquery-1.11.1.min.js?rand=20160302"></script> <script type="text/javascript" src="http://www.docsford.com/js/common_global.js?rand=20160302"></script> <script> (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) })(window,document,'script','//www.google-analytics.com/analytics.js','ga'); ga('create', 'UA-62413738-1', 'auto'); ga('send', 'pageview'); </script> <div class="gobackTop"><a href="javascript:void(0);" class="t"></a></div> <script type="text/javascript">var addthis_config = {"data_track_addressbar":false};</script> <script type="text/javascript" src="//s7.addthis.com/js/300/addthis_widget.js#pubid=ra-559395ba386a9f3e" async="async"></script> <script type="text/javascript"> var readerConfig = { allPage:44, productId:250851189, docProductId:4298072, isLogin:0, productName:'cornerstone update', load_url:'http://st.docmatize.com/' }; (function(){ jQuery.post("http://www.docsford.com/productEnd/viewStat.do",{"enId":"4298072"}); })(); </script> <script type="text/javascript" src="http://www.docsford.com/js/reader_html_test.js?rand=20160302"></script> <script type="text/javascript"> var docsford = { init:function(){ var _this = this; if(jQuery(".search_input").length>0){ jQuery(".search_input").focus(); } _this.hastop(); _this.report(); }, hastop:function(){ var _this = this; jQuery(".btn_like").bind("click",function(){ _this.increaseVoteCount(1); }); jQuery(".btn_hit").bind("click",function(){ _this.increaseVoteCount(-1); }); }, increaseVoteCount:function(type){ jQuery.post("http://www.docsford.com/productEnd/increaseVoteCount.do",{ "enId":"4298072","type":type},function(data){ if(data == 0){ var left, top = 10; if(type == 1){ left = parseInt(jQuery(".btn_like").offset().left)+10; var oVoteNum = parseInt(jQuery("#hitNum").html()); jQuery("#hitNum").html(oVoteNum+1); }else{ left = parseInt(jQuery(".btn_hit").offset().left)+10; } if(jQuery('#zhan').length>0){ jQuery('#zhan').remove(); } var addP = jQuery('<div id="zhan" style="font-size:24px;"><b>+1<\/b></\div>').appendTo(jQuery(".toolbar_left_mod")); jQuery('#zhan').css({'position':'absolute','z-index':'1', 'color':'#2284e2','left':left+'px','top':top+'px'}).animate({top:top-10,left:left+10},'slow',function(){addP.fadeIn('fast').remove();}); }else{ //alert("You already had voted, please don't repeat voting!"); } }); }, report:function(){ var _this = this; var aReportBtn = jQuery("#report,.report_inline"); if(aReportBtn.length == 0){return;} aReportBtn.bind("click",function(){ jQuery.ajax({ type:'GET', url:"/jsp/productEnd/include/doc_layer.jsp", data:"layer=report", context: document.body, success:function(data){ if(data){ var oHtml = data; jQuery(this).append(oHtml); dialogBoxShadow(); setObjCenter("reportDiv"); _this.initReport(); } } }); }); }, initReport:function(){ var oErrorType = 3,oReportSubmit = jQuery("#reportSubmit"),aErrorType = jQuery("input[name='error']"), oTextArea = jQuery("#reportInfo"),oRepeatUrl = jQuery("#purl"); if(oReportSubmit.length>0){ oReportSubmit.bind("click",function(){ var result = getErrorType(); if(result == 3){return false;} jQuery.ajax({ url:"/productEnd/insertDocReport.do", data:"content="+encodeURI(oTextArea.val())+"&choose="+result+"&productId="+4298072+"&dupUrl="+oRepeatUrl.val(), success:function(data){ if(data == 2){//0:faild 1:repeat 2:success jQuery("#reportDiv .report_message,#reportDiv .dialog_buttons").hide(); jQuery(".report_tips").show(); commonConutHideBox('reportDiv',1,2); } else if(data == 0){ alert("Failure report!"); } else if(data == 1){ alert("You had reported this document,please don't reported again!"); } } }); }); } if(aErrorType.length>0){ aErrorType.bind("click",function(){ if(aErrorType.is(":checked")){ oReportSubmit.removeClass('btn_forbid'); } else{ oReportSubmit.addClass('btn_forbid'); } if(jQuery(this).data("error") == 2){ jQuery("#repeatproduct").show().focus(); } else{ jQuery("#repeatproduct").hide(); } }); } function getErrorType(){ jQuery.each(aErrorType,function(i){ if(jQuery(this).is(":checked")){ oErrorType = jQuery(this).data("error"); return false; } }); return oErrorType; } } } docsford.init(); function submit(){ if(jQuery(".search_input").length>0){ if(jQuery(".search_input").val()!=""){ document.forms[0].submit(); } else{ jQuery(".search_input").foucs(); } } } jQuery(function(){ var oBackTop = jQuery(".gobackTop"); var oSideBarW = oBackTop.width(); var pageWidth = jQuery(".global_wrapper").width(); jQuery(window).bind("scroll resize", setBarPosition); jQuery(".gobackTop").unbind(); jQuery(".gobackTop").bind("click",function(){ jQuery("html, body").animate({ scrollTop: 0 }, 120); }); function setBarPosition(){ var winh = jQuery(window).height(),winw = jQuery(window).width(); var oRight = (winw-pageWidth)/2+pageWidth+20; oBackTop.css({'left':oRight}); var st = jQuery(document).scrollTop(); (st > winh)? oBackTop.show(): oBackTop.hide(); } }); if(false){ showLogin(); } </script> </body> </html>