<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Arial Unicode MS";
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
h3
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:13.5pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
pre
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle17
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1326072;
mso-list-template-ids:-1563244206;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
</head>
<body lang=PT link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Hi believe that I have
found the answer, but it is only available in the new 3.1M1 release, right?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Answer:<o:p></o:p></span></font></p>
<h3><b><font size=2 color=navy face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font>'from'<o:p></o:p></b></h3>
<ul type=disc>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>http://jira.jboss.com/jira/browse/JBRULES-341 <o:p></o:p></span></font></li>
</ul>
<p class=MsoNormal style='margin-left:35.4pt'><font size=3
face="Times New Roman"><span lang=EN-GB style='font-size:12.0pt'>'from' allows
the engine to reason over data not inside the engine, this can be used with
global variables to interact with data providing services, such as hibernate. MVEL
provides the scripting language capabilities for this, any previously bound
variable can be used in the MVEL expression. The following example shows a
hibernate named query with some dummy properties that returns a list of
Restaurants. Restaurant() is a standard pattern, and can have its own field
constraint and bindings like any other pattern. <o:p></o:p></span></font></p>
<pre style='margin-left:35.4pt'><font size=2 face="Courier New"><span
lang=EN-GB style='font-size:10.0pt'> $r : Restaurant( $postCode ) from hbSession.getNamedQuery( "some query" ).setProperties( [ key1 : value2, key2 : value ] ).list()<o:p></o:p></span></font></pre>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=2 color=navy face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:navy'>__________________________________<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:navy'>Francisco Brum - </span></font><font
color=navy><span style='color:navy'><a href="mailto:rui.arrenega@link.pt"
title="mailto:rui.arrenega@link.pt mailto:nuno.oliveira@link.pt"><font
size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'><span
title="mailto:rui.arrenega@link.pt">francisco.brum@link.pt</span></span></font></a><br>
</span></font><b><font size=2 color=teal face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:teal;font-weight:bold'>Link Consulting</span></font></b><font
size=2 color=navy face=Verdana><span style='font-size:10.0pt;font-family:Verdana;
color:navy'> - </span></font><font color=navy><span style='color:navy'><a
href="http://www.link.pt/" target="_BLANK㉜柦〠睰悴㌀㋰柴〠岨ሤ૔㌀㌐оᖰ"
title="http://www.link.pt/"><font size=2 face=Verdana><span style='font-size:
10.0pt;font-family:Verdana'><span title="http://www.link.pt/">http://www.link.pt/</span></span></font></a><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:navy'>Tel.: 213 100 031</span></font><font
color=navy><span style='color:navy'><br>
</span></font><font size=2 color=navy face=Verdana><span style='font-size:10.0pt;
font-family:Verdana;color:navy'>Av. Duque D'Ávila, 23 4º Esq.<br>
1000-138 Lisboa</span></font><font color=navy><span style='color:navy'><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
rules-users-bounces@lists.jboss.org
[mailto:rules-users-bounces@lists.jboss.org] <b><span style='font-weight:bold'>On
Behalf Of </span></b>Francisco Brum<br>
<b><span style='font-weight:bold'>Sent:</span></b> terça-feira, 27 de Fevereiro
de 2007 15:03<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">Rules
Users List</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> [rules-users] accessing
the data base</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Hi everybody!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>I would like to be able to access the data base
during the execution of a rule. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>The reason it’s because instead of asserting in
the working memory information as a global, it would be easy to make a SQL
query using hibernate to consult the information.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Can I implement this in a function of my global fact
or there is another way?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Thanks in advance for your attention!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>__________________________________<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>Francisco Brum - </span></font><a
href="mailto:rui.arrenega@link.pt"
title="mailto:rui.arrenega@link.pt mailto:nuno.oliveira@link.pt"><font
size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'><span
title="mailto:rui.arrenega@link.pt">francisco.brum@link.pt</span></span></font></a><br>
<b><font size=2 color=teal face=Verdana><span style='font-size:10.0pt;
font-family:Verdana;color:teal;font-weight:bold'>Link Consulting</span></font></b><font
size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'> - </span></font><a
href="http://www.link.pt/" target="_BLANK㉜柦〠睰悴㌀㋰柴〠岨ሤ૔㌀㌐оᖰ"
title="http://www.link.pt/"><font size=2 face=Verdana><span style='font-size:
10.0pt;font-family:Verdana'><span title="http://www.link.pt/">http://www.link.pt/</span></span></font></a><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>Tel.: 213 100 031</span></font><br>
<font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>Av.
Duque D'Ávila, 23 4º Esq.<br>
1000-138 Lisboa</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>