E9: BPM updating unrelated table from method

Yahoo Archive
1

No lock means you are not locking the record for update.
Also you may want to limit your query to rowmod u

On Mar 25, 2015 5:28 PM, "sergio prieto s_a_prieto@... [vantage]" <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p><div style="color:#000;background-color:#fff;font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px;"><div dir="ltr"><span>My guess... and I have to say it is only a guess... probably you needed to move the BPM to the Update method instead of updateMaster? just a thought. </span></div><div></div><div> </div><div><div dir="ltr" style="margin:0.1em 0px;padding:0px;font-family:HelveticaNeue,;"><font>Kind Regards,</font></div><div dir="ltr" style="margin:0.1em 0px;padding:0px;font-family:HelveticaNeue,;"><font>Sergio P. </font></div><div dir="ltr" style="margin:0.1em 0px;padding:0px;font-family:HelveticaNeue,;"><font>CTO, Sr. Partner</font></div><div dir="ltr" style="margin:0.1em 0px;padding:0px;font-family:HelveticaNeue,;"><font>Kind Regards,</font></div><div dir="ltr" style="margin:0.1em 0px;padding:0px;font-family:HelveticaNeue,;"><font>Sergio P.</font></div><div dir="ltr" style="margin:0.1em 0px;padding:0px;font-family:HelveticaNeue,;"><font><br></font></div><div dir="ltr" style="margin:0.1em 0px;padding:0px;font-family:HelveticaNeue,;"><span style="font-size:small;">Mayan Technologies USA, Inc.</span><font><br></font></div><div dir="ltr" style="margin:0.1em 0px;padding:0px;font-family:HelveticaNeue,;"><span style="font-size:small;"><a rel="nofollow">(858) 900.1555</a></span></div><div dir="ltr" style="margin:0.1em 0px;padding:0px;font-family:HelveticaNeue,;"><font><a rel="nofollow" target="_blank" href="mailto:sprieto@...">sprieto@...</a></font></div><div dir="ltr" style="margin:0.1em 0px;padding:0px;font-family:HelveticaNeue,;"><a rel="nofollow" target="_blank" href="http://www.mayantechs.com/" style="margin:0px;padding:0px;color:blue;outline:none;font-size:9pt;background:rgb(255,255,255);">www.mayantechs.com</a><br></div><div><br></div></div>  <br><div><br><br></div><div> <div style="font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr"> <font face="Arial"> On Wednesday, March 25, 2015 7:19 AM, &quot;<a rel="nofollow" target="_blank" href="mailto:jockthemotie@...">jockthemotie@...</a> [vantage]&quot; &lt;<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>&gt; wrote:<br> </font> </div>  <br><br> <div><div><div>

 

<div>
  
  
  <div>Hi all, </div><div><br clear="none"></div><div>Thanks a lot for your help!</div><div><br clear="none"></div><div>With the messaging thrown in to the BPM I was able to see the initial query wasn&#39;t getting any data for some reason, no idea why.  I ended up moving to a post processing directive and it started to work.</div><div><br clear="none"></div><div>Thanks so much for the help.</div>

</div>
 


<div style="color:#fff;min-height:0;"></div></div>



</div>
 


<div style="color:#fff;min-height:0;"></div>
2

Hello, 


I'm drawing a blank here and I feel dumb for not being able to get this, but after an update to the shiphead table, I want to trigger a write to the Part table based on the PNs in the shipdtl.  Essentially, the code I have is this: 


for each ttshipdtl, each part where part.company=ttshipdtl.Company and part.partnum=ttshipdtl.partnum no-lock.


if available part then do:


part.checkbox10 = false.


end.


end.



but it's not working.


I know in Vantage you had to call the lib/update in bpm but in E9 I didn't think you had to do that.


Can I do this inside a BPM?  Am I better off using data directives?

3

Try

 

ASSIGN Part.CheckBox10 = FALSE.

 

Brenda

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 23, 2015 6:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: BPM updating unrelated table from method

 

 

Hello, 

 

I'm drawing a blank here and I feel dumb for not being able to get this, but after an update to the shiphead table, I want to trigger a write to the Part table based on the PNs in the shipdtl.  Essentially, the code I have is this: 

 

for each ttshipdtl, each part where part.company=ttshipdtl.Company and part.partnum=ttshipdtl.partnum no-lock.

 

if available part then do:

 

part.checkbox10 = false.

 

end.

 

end.

 

 

but it's not working.

 

I know in Vantage you had to call the lib/update in bpm but in E9 I didn't think you had to do that.

 

Can I do this inside a BPM?  Am I better off using data directives?

4
Hi Brenda, 

I've tried assign, set, etc but I can't seem to get it to work.  I'm wondering if I'm just not catching the part in the for each query.  I'm not sure how I can check that...or if I need to just continually iterate until I get something.  

For the record, I am in ShipHead update master for the Method.  
5
Have you tried removing the “no-lock”.
I believe this makes the query read-only.





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:454f85.png@bf4de5e2.4f93977e]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, March 24, 2015 7:57 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E9: BPM updating unrelated table from method



Hi Brenda,

I've tried assign, set, etc but I can't seem to get it to work. I'm wondering if I'm just not catching the part in the for each query. I'm not sure how I can check that...or if I need to just continually iterate until I get something.

For the record, I am in ShipHead update master for the Method.



[Non-text portions of this message have been removed]
6
That could be it.  I'll give it an exclusive lock and give it a try. 
7
You can add a message on any section of your code to check to check how far along your code the BPm is being executed. Simply type in message :whatehever text" + PartNum. Then you will look into your server log for your messages. We use this process all the time to debug BPMs. 

Try this out, and check on your server logs. Its this a regular method directive or a data directive? Could be that your ttShipDtl table has no data at all or simply doesnt have a valid part at the moment of your BPM execution...

message "initial BPM".
for each ttshipdtl, each part where part.company=ttshipdtl.Company and part.partnum=ttshipdtl.partnum no-lock.
 Message "Each ShipDtl" +  ttShipDtl.Partnum.
if available part then do:
 Message "Part found" + Part.PartNum.
part.checkbox10 = false.
 
end.
 
end.
 

 
Kind Regards,
Sergio P. 
CTO, Sr. Partner
Kind Regards,
Sergio P.

Mayan Technologies USA, Inc.
(858) 900.1555
sprieto@...




On Tuesday, March 24, 2015 7:13 AM, "jockthemotie@... [vantage]" <vantage@yahoogroups.com> wrote:


  
<div id="ygrps-yiv-643868320yiv0932131546ygrp-text">
  
  
  <div>That could be it. &nbsp;I&#39;ll give it an exclusive lock and give it a try.&nbsp;</div>

</div>
 


<div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546 -- #ygrps-yiv-643868320yiv0932131546ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-mkp #ygrps-yiv-643868320yiv0932131546hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-mkp #ygrps-yiv-643868320yiv0932131546ads {
margin-bottom:10px;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-mkp .ygrps-yiv-643868320yiv0932131546ad {
padding:0 0;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-mkp .ygrps-yiv-643868320yiv0932131546ad p {
margin:0;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-mkp .ygrps-yiv-643868320yiv0932131546ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-sponsor #ygrps-yiv-643868320yiv0932131546ygrp-lc {
font-family:Arial;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-sponsor #ygrps-yiv-643868320yiv0932131546ygrp-lc #ygrps-yiv-643868320yiv0932131546hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-sponsor #ygrps-yiv-643868320yiv0932131546ygrp-lc .ygrps-yiv-643868320yiv0932131546ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546activity span {
font-weight:700;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546activity span span {
color:#ff7900;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546activity span .ygrps-yiv-643868320yiv0932131546underline {
text-decoration:underline;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 .ygrps-yiv-643868320yiv0932131546attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 .ygrps-yiv-643868320yiv0932131546attach div a {
text-decoration:none;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 .ygrps-yiv-643868320yiv0932131546attach img {
border:none;padding-right:5px;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 .ygrps-yiv-643868320yiv0932131546attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 .ygrps-yiv-643868320yiv0932131546attach label a {
text-decoration:none;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 .ygrps-yiv-643868320yiv0932131546bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 .ygrps-yiv-643868320yiv0932131546bold a {
text-decoration:none;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 dd.ygrps-yiv-643868320yiv0932131546last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 dd.ygrps-yiv-643868320yiv0932131546last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 dd.ygrps-yiv-643868320yiv0932131546last p span.ygrps-yiv-643868320yiv0932131546yshortcuts {
margin-right:0;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 div.ygrps-yiv-643868320yiv0932131546attach-table div div a {
text-decoration:none;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 div.ygrps-yiv-643868320yiv0932131546attach-table {
width:400px;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 div.ygrps-yiv-643868320yiv0932131546file-title a, #ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 div.ygrps-yiv-643868320yiv0932131546file-title a:active, #ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 div.ygrps-yiv-643868320yiv0932131546file-title a:hover, #ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 div.ygrps-yiv-643868320yiv0932131546file-title a:visited {
text-decoration:none;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 div.ygrps-yiv-643868320yiv0932131546photo-title a, #ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 div.ygrps-yiv-643868320yiv0932131546photo-title a:active, #ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 div.ygrps-yiv-643868320yiv0932131546photo-title a:hover, #ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 div.ygrps-yiv-643868320yiv0932131546photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 div#ygrps-yiv-643868320yiv0932131546ygrp-mlmsg #ygrps-yiv-643868320yiv0932131546ygrp-msg p a span.ygrps-yiv-643868320yiv0932131546yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 .ygrps-yiv-643868320yiv0932131546green {
color:#628c2a;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 .ygrps-yiv-643868320yiv0932131546MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 o {
font-size:0;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546photos div {
float:left;width:72px;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546reco-category {
font-size:77%;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546reco-desc {
font-size:77%;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 .ygrps-yiv-643868320yiv0932131546replbq {
margin:4px;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-mlmsg select, #ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 input, #ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-mlmsg pre, #ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 code {
font:115% monospace;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-mlmsg #ygrps-yiv-643868320yiv0932131546logo {
padding-bottom:10px;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-msg p#ygrps-yiv-643868320yiv0932131546attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-reco #ygrps-yiv-643868320yiv0932131546reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-sponsor #ygrps-yiv-643868320yiv0932131546ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-sponsor #ygrps-yiv-643868320yiv0932131546ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-sponsor #ygrps-yiv-643868320yiv0932131546ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-text {
font-family:Georgia;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-text tt {
font-size:120%;}

#ygrps-yiv-643868320 #ygrps-yiv-643868320yiv0932131546 #ygrps-yiv-643868320yiv0932131546ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-643868320



8
Thanks Sergio!

I'll try that too.  

Currently, it's a pre processing method directive on CustShip.UpdateMaster.  My trigger is the shiphead.readytoinvoice flag changing from false to true.

I'll add in the messaging and check out the appserver logs.  Does the messaging have to be Verbose on the logs?
9
If you're doing ABL you can also put comments that will be displayed when the BPM runs which eliminates the need to go to the appserver logs. Here's an example with the messages commented out (ABL comments are enclosed in /*   */) in a Post-Processing action. I used this to check my before and after values.

for each ttCustomer no-lock.

/*find the ShipTo record for ttCustomer and update Intrntlship*/
        for each ShipTo where ShipTo.Company = ttCustomer.Company and ShipTo.CustNum = ttCustomer.CustNum
        and ShipTo.ShipToNum = "" exclusive-lock.
                if available ShipTo then do:
                        /*{lib/PublishInfoMsg.i &InfoMsg = "'Found ShipTo' + String(ttCustomer.IntrntlShip) + String(ShipTo.IntrntlShip)"}.*/
                        ASSIGN ShipTo.IntrntlShip = ttCustomer.IntrntlShip.
                        /*{lib/PublishInfoMsg.i &InfoMsg = "'Found ShipTo' + String(ttCustomer.IntrntlShip) + String(ShipTo.IntrntlShip)"}.*/
                end.
        end.

end.


Sue


---In vantage@yahoogroups.com, <jockthemotie@...> wrote :

Thanks Sergio!

I'll try that too.  

Currently, it's a pre processing method directive on CustShip.UpdateMaster.  My trigger is the shiphead.readytoinvoice flag changing from false to true.

I'll add in the messaging and check out the appserver logs.  Does the messaging have to be Verbose on the logs?
10
Hi all, 

Thanks a lot for your help!

With the messaging thrown in to the BPM I was able to see the initial query wasn't getting any data for some reason, no idea why.  I ended up moving to a post processing directive and it started to work.

Thanks so much for the help.
11
My guess... and I have to say it is only a guess... probably you needed to move the BPM to the Update method instead of updateMaster? just a thought. 
 
Kind Regards,
Sergio P. 
CTO, Sr. Partner
Kind Regards,
Sergio P.

Mayan Technologies USA, Inc.
(858) 900.1555
sprieto@...




On Wednesday, March 25, 2015 7:19 AM, "jockthemotie@... [vantage]" <vantage@yahoogroups.com> wrote:


  
<div id="ygrps-yiv-2140096754yiv0018926199ygrp-text">
  
  
  <div>Hi all,&nbsp;</div><div><br clear="none"></div><div>Thanks a lot for your help!</div><div><br clear="none"></div><div>With the messaging thrown in to the BPM I was able to see the initial query wasn&#39;t getting any data for some reason, no idea why. &nbsp;I ended up moving to a post processing directive and it started to work.</div><div><br clear="none"></div><div>Thanks so much for the help.</div>

</div>
 


<div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199 -- #ygrps-yiv-2140096754yiv0018926199ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-mkp #ygrps-yiv-2140096754yiv0018926199hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-mkp #ygrps-yiv-2140096754yiv0018926199ads {
margin-bottom:10px;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-mkp .ygrps-yiv-2140096754yiv0018926199ad {
padding:0 0;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-mkp .ygrps-yiv-2140096754yiv0018926199ad p {
margin:0;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-mkp .ygrps-yiv-2140096754yiv0018926199ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-sponsor #ygrps-yiv-2140096754yiv0018926199ygrp-lc {
font-family:Arial;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-sponsor #ygrps-yiv-2140096754yiv0018926199ygrp-lc #ygrps-yiv-2140096754yiv0018926199hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-sponsor #ygrps-yiv-2140096754yiv0018926199ygrp-lc .ygrps-yiv-2140096754yiv0018926199ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199activity span {
font-weight:700;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199activity span span {
color:#ff7900;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199activity span .ygrps-yiv-2140096754yiv0018926199underline {
text-decoration:underline;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 .ygrps-yiv-2140096754yiv0018926199attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 .ygrps-yiv-2140096754yiv0018926199attach div a {
text-decoration:none;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 .ygrps-yiv-2140096754yiv0018926199attach img {
border:none;padding-right:5px;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 .ygrps-yiv-2140096754yiv0018926199attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 .ygrps-yiv-2140096754yiv0018926199attach label a {
text-decoration:none;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 .ygrps-yiv-2140096754yiv0018926199bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 .ygrps-yiv-2140096754yiv0018926199bold a {
text-decoration:none;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 dd.ygrps-yiv-2140096754yiv0018926199last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 dd.ygrps-yiv-2140096754yiv0018926199last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 dd.ygrps-yiv-2140096754yiv0018926199last p span.ygrps-yiv-2140096754yiv0018926199yshortcuts {
margin-right:0;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 div.ygrps-yiv-2140096754yiv0018926199attach-table div div a {
text-decoration:none;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 div.ygrps-yiv-2140096754yiv0018926199attach-table {
width:400px;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 div.ygrps-yiv-2140096754yiv0018926199file-title a, #ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 div.ygrps-yiv-2140096754yiv0018926199file-title a:active, #ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 div.ygrps-yiv-2140096754yiv0018926199file-title a:hover, #ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 div.ygrps-yiv-2140096754yiv0018926199file-title a:visited {
text-decoration:none;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 div.ygrps-yiv-2140096754yiv0018926199photo-title a, #ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 div.ygrps-yiv-2140096754yiv0018926199photo-title a:active, #ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 div.ygrps-yiv-2140096754yiv0018926199photo-title a:hover, #ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 div.ygrps-yiv-2140096754yiv0018926199photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 div#ygrps-yiv-2140096754yiv0018926199ygrp-mlmsg #ygrps-yiv-2140096754yiv0018926199ygrp-msg p a span.ygrps-yiv-2140096754yiv0018926199yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 .ygrps-yiv-2140096754yiv0018926199green {
color:#628c2a;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 .ygrps-yiv-2140096754yiv0018926199MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 o {
font-size:0;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199photos div {
float:left;width:72px;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199reco-category {
font-size:77%;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199reco-desc {
font-size:77%;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 .ygrps-yiv-2140096754yiv0018926199replbq {
margin:4px;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-mlmsg select, #ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 input, #ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-mlmsg pre, #ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 code {
font:115% monospace;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-mlmsg #ygrps-yiv-2140096754yiv0018926199logo {
padding-bottom:10px;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-msg p#ygrps-yiv-2140096754yiv0018926199attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-reco #ygrps-yiv-2140096754yiv0018926199reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-sponsor #ygrps-yiv-2140096754yiv0018926199ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-sponsor #ygrps-yiv-2140096754yiv0018926199ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-sponsor #ygrps-yiv-2140096754yiv0018926199ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-text {
font-family:Georgia;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-text tt {
font-size:120%;}

#ygrps-yiv-2140096754 #ygrps-yiv-2140096754yiv0018926199 #ygrps-yiv-2140096754yiv0018926199ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-2140096754