Multiple database field comparison

[Juan Gordon]

Hi there,

Is there any way to compare multiple fields that refers to the same attribute? (for example first name and last name can be refer to the name attribute) do i have to modify the OysterSourceDescriptor for doing that? can i do something like this in source2 or source3? :

source1
<ReferenceItems>
    <!-- For Delimited -->
    <Item Name="username" Attribute="@RefID" Pos="0"/>
    <Item Name="complete_name" Attribute="name" Pos="1"/>
</ReferenceItems>

source2
<ReferenceItems>
    <!-- For Delimited -->
    <Item Name="username" Attribute="@RefID" Pos="0"/>
    <Item Name="fname" Attribute="name" Pos="1"/>
    <Item Name="lname" Attribute="name" Pos="1"/>
</ReferenceItems>

source3
<ReferenceItems>
    <!-- For Delimited -->
    <Item Name="username" Attribute="@RefID" Pos="0"/>
    <Item Name="fname + lname" Attribute="name" Pos="1"/>
</ReferenceItems>

Thanks a lot!

[John Talburt]

Juan,
Oyster does not support this. It makes a fundamental assumption that their
is uniform set of attributes across all sources and the rules assume that
you are always comparing values of the same attribute. Some systems handle
this by using a second level of attribute metadata, basically a type
attribute. In your example, in one source you could have Fname and Lname
that are typed as "Name" attributes, and the complete_name in the other
source also typed as "Name", then you could have a matching rule compares
on the term "Name" using a comparator that is smart enough to compare these
multi-valued fields.
Thanks,
-jrt-

On Wed, Apr 23, 2014 at 7:40 AM, Juan Gordon jegordon@users.sf.net wrote:

Hi there,

Is there any way to compare multiple fields that refers to the same
attribute? (for example first name and last name can be refer to the name
attribute) do i have to modify the OysterSourceDescriptor for doing that?
can i do something like this in source2? :

source1<referenceitems>

<item name="username" attribute="@RefID" pos="0">
<item name="complete_name" attribute="name" pos="1"></item></item></referenceitems>
source2<referenceitems>

<item name="username" attribute="@RefID" pos="0">
<item name="fname" attribute="name" pos="1">
<item name="lname" attribute="name" pos="1"></item></item></item></referenceitems>

Thanks a lot!

Multiple database field comparisonhttps://sourceforge.net/p/oysterer/discussion/general/thread/f93cb0ae/?limit=25#f047

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/oysterer/discussion/general/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/