33393404-e29c-482b-8ff5-43e770c6a082Potential Duplicate Persons (First Name & Address Line 1)A listing of Potential Duplicate persons in the database, based on same first name and address line 1<Query QueryName="" QueryGUID="b14274ca-02e1-48a0-abcb-a3c118e30c06" SchemaGUID="33393404-e29c-482b-8ff5-43e770c6a082" SchemaVer="108"> <Properties /> <Top>All</Top> <ResultGrouping>2</ResultGrouping> <Select> <ReturnField> <FieldName>Person.EPrimaryEmailAddress</FieldName> <AggregationType>8</AggregationType> <ReturnSetOrder>0</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.EPrimaryEmailAddress</FieldName> <AggregationType>16</AggregationType> <ReturnSetOrder>1</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.TPhoneMobile</FieldName> <AggregationType>8</AggregationType> <ReturnSetOrder>2</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.TPhoneMobile</FieldName> <AggregationType>16</AggregationType> <ReturnSetOrder>3</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.APrimaryAddress1</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>4</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.PLastName</FieldName> <AggregationType>8</AggregationType> <ReturnSetOrder>5</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.PLastName</FieldName> <AggregationType>16</AggregationType> <ReturnSetOrder>6</ReturnSetOrder> <ReturnSetSortOrder>0</ReturnSetSortOrder> <ReturnSortDirection>1</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.PFirstName</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>7</ReturnSetOrder> <ReturnSetSortOrder>1</ReturnSetSortOrder> <ReturnSortDirection>1</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.PID</FieldName> <AggregationType>8</AggregationType> <ReturnSetOrder>8</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.PID</FieldName> <AggregationType>16</AggregationType> <ReturnSetOrder>9</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.PID</FieldName> <AggregationType>1</AggregationType> <ReturnSetOrder>10</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> </Select> <Where> <ConditionGroup GroupName="baseGroup" Behavior="0"> <Condition> <ComparisonFieldName>Person.PLastName</ComparisonFieldName> <ComparisonTypeName>is not null</ComparisonTypeName> <AggregationType>0</AggregationType> <ConditionValues /> <ValueSourceType>0</ValueSourceType> <ValueSourceTitle /> <DisplayConditionValues /> </Condition> <Condition> <ComparisonFieldName>Person.PFirstName</ComparisonFieldName> <ComparisonTypeName>is not null</ComparisonTypeName> <AggregationType>0</AggregationType> <ConditionValues /> <ValueSourceType>0</ValueSourceType> <ValueSourceTitle /> <DisplayConditionValues /> </Condition> <Condition> <ComparisonFieldName>Person.PPrefName</ComparisonFieldName> <ComparisonTypeName>is greater than</ComparisonTypeName> <AggregationType>1</AggregationType> <ConditionValues> <ConditionValue>1</ConditionValue> </ConditionValues> <ValueSourceType>0</ValueSourceType> <ValueSourceTitle /> <DisplayConditionValues /> </Condition> <Condition> <ComparisonFieldName>Person.APrimaryAddress1</ComparisonFieldName> <ComparisonTypeName>is greater than or equal to</ComparisonTypeName> <AggregationType>0</AggregationType> <ConditionValues> <ConditionValue>1</ConditionValue> </ConditionValues> <ValueSourceType>0</ValueSourceType> <ValueSourceTitle /> <DisplayConditionValues /> </Condition> </ConditionGroup> </Where> </Query>0truefalsefalse2010-06-07T08:38:50Connect4 Support<__OriginalRID>2000000001