<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Update vs insert</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3314" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=567471212-11092008><FONT face=Arial
color=#0000ff size=2>You might need to add the MemberDataRecords into WM and use
not exists</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=567471212-11092008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=567471212-11092008><FONT face=Arial
color=#0000ff size=2>when</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=567471212-11092008><FONT face=Arial
color=#0000ff size=2> $d : Data() </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=567471212-11092008> <FONT
face=Arial><FONT color=#0000ff size=2>$mdr : MemberDataRecord( $d1 :
loggedInDate )</FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=567471212-11092008> <FONT
face=Arial color=#0000ff size=2>not exists MemberDataRecord (
loggedInDate > $d1 )</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=567471212-11092008><FONT face=Arial
color=#0000ff size=2>then</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=567471212-11092008> <FONT
face=Arial color=#0000ff size=2>//Smurf</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=567471212-11092008><FONT face=Arial
color=#0000ff size=2>end</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=567471212-11092008><FONT face=Arial
color=#0000ff size=2> </FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> rules-users-bounces@lists.jboss.org
[mailto:rules-users-bounces@lists.jboss.org] <B>On Behalf Of </B>Kapila
Silwathge<BR><B>Sent:</B> 11 September 2008 13:09<BR><B>To:</B> Rules Users
List<BR><B>Subject:</B> Re: [rules-users] getting latest
date<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial>yeah.........i did the same with following
code</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>//////////////</FONT></DIV>
<DIV><FONT size=2>
<P align=left><FONT face=Verdana size=4>$d : Data($memDataRecods
:memberDataRecords ) </FONT></P>
<P align=left><FONT face=Verdana size=4></FONT></P>
<P></FONT><FONT size=4><FONT face=Verdana>$mdr :
MemberDataRecord($loggedindate:logged_in_date )<B><FONT
color=#960000>from</B></FONT></FONT></FONT><FONT size=4><FONT face=Verdana>
$memDataRecods <B><FONT color=#960000>not</B></FONT></FONT></FONT><FONT
size=2><FONT face=Verdana size=4> MemberDataRecord( logged_in_date <
$loggedindate )</FONT></FONT></P>
<P><FONT size=2><FONT face=Verdana size=4>//////////</FONT></FONT></P>
<P><FONT size=2><FONT face=Verdana size=4>when what happened was it iterates
over earch memDataRecods in decending order........</FONT></FONT></P>
<P><FONT size=2><FONT face=Verdana size=4>what i need is to get only the very
first record...........</FONT></P></FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=Pallav.Shyam@mscibarra.com
href="mailto:Pallav.Shyam@mscibarra.com">Shyam, Pallav (MSCIBARRA)</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=rules-users@lists.jboss.org
href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, September 11, 2008 5:09
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [rules-users] getting
latest date</DIV>
<DIV><BR></DIV>
<DIV>
<P><FONT face=Arial color=navy size=2>rule <BR>when<BR>m :
MemberDataRecords( d : loggedInDate) from Data( )<BR>and not
MemberDataRecords( loggedInDate < d) from Data(
)<BR><BR>then<BR><BR>end</FONT></P>
<P>
<HR tabIndex=-1 align=center width="100%" SIZE=2>
<FONT face=Tahoma size=2><B>From</B>: <A
href="mailto:rules-users-bounces@lists.jboss.org">rules-users-bounces@lists.jboss.org</A>
<RULES-USERS-BOUNCES@LISTS.JBOSS.ORG><BR><B>To</B>: <A
href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</A>
<RULES-USERS@LISTS.JBOSS.ORG><BR><B>Sent</B>: Thu Sep 11 19:05:22
2008<BR><B>Subject</B>: [rules-users] getting latest date <BR></FONT>
<P></P>
<DIV><FONT face=Arial>HI all.</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>I am inserting an Obect from a class called Data() to
the working memory</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>Data object has a Collection (ArrayList) of Objects
from a class called MemberDataRecords()</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>MemberDataRecords object has a field called
loggedInDate of type Date()(Accually SimpleDate a subclass of java util
date())</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>how can i get MemberDataRecords object which
contain the last loggedInDate </FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>Kapila Silwathge</FONT></DIV></DIV>
<DIV>
<HR>
</DIV>
<P class=BulletedList
style="MARGIN: 0in 0in 0pt; TEXT-INDENT: 0in; mso-list: none; tab-stops: .5in"><SPAN
style="FONT-SIZE: 8pt; COLOR: gray; mso-bidi-font-family: Arial"><FONT
face=Arial color=gray size=1>NOTICE: If received in error, please destroy
and notify sender. Sender does not intend to waive confidentiality or
privilege. Use of this email is prohibited when received in
error.</FONT></SPAN></P>
<DIV></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>rules-users
mailing
list<BR>rules-users@lists.jboss.org<BR>https://lists.jboss.org/mailman/listinfo/rules-users<BR></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>