Can you pick up the value in preprocessing and assign it to your callcontextbpm data and then use that in your post?
Rob Bucek
Production Control Manager
D&S Manufacturing
301 E. Main St. | PO Box 279
Black River Falls, WI 54615
715-284-5376 Ext. 311
Mobile: 715-896-3119
rbucek@...
Visit our newly redesigned Website at www.dsmfg.com<http://www.dsmfg.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, March 3, 2016 1:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] UD table
I have added a customized window, using UD table.
In UD04.Number03 I am storing a certain value for tool1 which is found in UD04.ShortChar05==>key1(value x)
as key 1 is incremented(a new entry created "x+1") I might be using again tool1(UD04.ShortChar05) but with a smaller value in UD04.Number03.
The smaller value from UD04.Number03, let's say I want to pass it to UD04.Number05 or whatever.
I have created a BPM on Update.UD04 and a post processing with custom code.
Inside I have the following code:
foreach (var ttUD04_R in ttUD04)
{
//Find out if all values in Db.UD04.ShortChar05 are unique:
var allUnique = Db.UD04.GroupBy(x => x.ShortChar05).All(g => g.Count() == 1);
if (allUnique == true)
{
string Tool = ttUD04_R.ShortChar05;
if (Tool.StartsWith("T."))
{
ttUD04_R.Number03 = (Convert.ToInt32(ttUD04_R.Number05) - Convert.ToInt32(ttUD04_R.Number04));
}
}
else
{
var ttUD04_Recs = (from ttUD04_Row in Db.UD04 where ttUD04_Row.Company == Session.CompanyID orderby ttUD04_Row.Number03 descending select ttUD04_Row).FirstOrDefault();
if(ttUD04_Recs != null)
{
ttUD04_R.Number05 = ttUD04_Recs.Number03;
}
}
}
I create key1 which is 1 then select tool1, then key1 which is 2 then select the same tool and it works ok, the value is passed from Number03 to Number05, but when I create next key1=3 and enter that same tool, it passes the value from key1=1, and not the last value from key2.
Is there a possibility of getting this to work?
I hope I have been clear enough.
Thanks!
[Non-text portions of this message have been removed]
Rob Bucek
Production Control Manager
D&S Manufacturing
301 E. Main St. | PO Box 279
Black River Falls, WI 54615
715-284-5376 Ext. 311
Mobile: 715-896-3119
rbucek@...
Visit our newly redesigned Website at www.dsmfg.com<http://www.dsmfg.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, March 3, 2016 1:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] UD table
I have added a customized window, using UD table.
In UD04.Number03 I am storing a certain value for tool1 which is found in UD04.ShortChar05==>key1(value x)
as key 1 is incremented(a new entry created "x+1") I might be using again tool1(UD04.ShortChar05) but with a smaller value in UD04.Number03.
The smaller value from UD04.Number03, let's say I want to pass it to UD04.Number05 or whatever.
I have created a BPM on Update.UD04 and a post processing with custom code.
Inside I have the following code:
foreach (var ttUD04_R in ttUD04)
{
//Find out if all values in Db.UD04.ShortChar05 are unique:
var allUnique = Db.UD04.GroupBy(x => x.ShortChar05).All(g => g.Count() == 1);
if (allUnique == true)
{
string Tool = ttUD04_R.ShortChar05;
if (Tool.StartsWith("T."))
{
ttUD04_R.Number03 = (Convert.ToInt32(ttUD04_R.Number05) - Convert.ToInt32(ttUD04_R.Number04));
}
}
else
{
var ttUD04_Recs = (from ttUD04_Row in Db.UD04 where ttUD04_Row.Company == Session.CompanyID orderby ttUD04_Row.Number03 descending select ttUD04_Row).FirstOrDefault();
if(ttUD04_Recs != null)
{
ttUD04_R.Number05 = ttUD04_Recs.Number03;
}
}
}
I create key1 which is 1 then select tool1, then key1 which is 2 then select the same tool and it works ok, the value is passed from Number03 to Number05, but when I create next key1=3 and enter that same tool, it passes the value from key1=1, and not the last value from key2.
Is there a possibility of getting this to work?
I hope I have been clear enough.
Thanks!
[Non-text portions of this message have been removed]