Update event property

[benjamine.leon]

Hello,

   Currently updating event properties as a preprocessing step of the
stream is available.  

update istream AlertEvent
  set severity = 'High'
  where severity = 'Medium' and reason like '%withdrawal limit%'

Is it possible to update a property of an event   when a different event
is triggered?

Something like

Update istream AlertEvent as a
Set severity='High'   when select  * from TradeEvent as b where
b.tradeId=a.tradeId and b.tradeType='new'

Whenever there is a trade event and it's type is 'new'  and if there is
already an AlertEvent with that trade id, update the severity to high?

Thanks,
Ben


_______________________________________________

This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent to the foregoing.  Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP.  This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

[Thomas Bernhardt]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi Ben,

well when talking about a stream of AlertEvent events then which event in that stream would be updated? I would presume the events held in a named window? We allow insert/remove into a named window and update of an event in a named window is not currently possible.

Best regards
Tom

---

From: "benjamine.leon@..." <benjamine.leon@...>
To: user@...
Sent: Mon, November 2, 2009 4:05:19 PM
Subject: [esper-user] Update event property

Hello,

  Currently updating event properties as a preprocessing step of the
stream is available. 

update istream AlertEvent
  set severity = 'High'
  where severity = 'Medium' and reason like '%withdrawal limit%'

Is it possible to update a property of an event  when a different event
is triggered?

Something like

Update istream AlertEvent as a
Set severity='High'  when select  * from TradeEvent as b where
b.tradeId=a.tradeId and b.tradeType='new'

Whenever there is a trade event and it's type is 'new'  and if there is
already an AlertEvent with that trade id, update the severity to high?

Thanks,
Ben


_______________________________________________

This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent to the foregoing.  Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP.  This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

[Thomas Bernhardt]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi Ben,

well when talking about a stream of AlertEvent events then which event in that stream would be updated? I would presume the events held in a named window? We allow insert/remove into a named window and update of an event in a named window is not currently possible.

Best regards
Tom

---

From: "benjamine.leon@..." <benjamine.leon@...>
To: user@...
Sent: Mon, November 2, 2009 4:05:19 PM
Subject: [esper-user] Update event property

Hello,

  Currently updating event properties as a preprocessing step of the
stream is available. 

update istream AlertEvent
  set severity = 'High'
  where severity = 'Medium' and reason like '%withdrawal limit%'

Is it possible to update a property of an event  when a different event
is triggered?

Something like

Update istream AlertEvent as a
Set severity='High'  when select  * from TradeEvent as b where
b.tradeId=a.tradeId and b.tradeType='new'

Whenever there is a trade event and it's type is 'new'  and if there is
already an AlertEvent with that trade id, update the severity to high?

Thanks,
Ben


_______________________________________________

This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent to the foregoing.  Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP.  This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

[Thomas Bernhardt]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi Ben,

well when talking about a stream of AlertEvent events then which event in that stream would be updated? I would presume the events held in a named window? We allow insert/remove into a named window and update of an event in a named window is not currently possible.

Best regards
Tom

---

From: "benjamine.leon@..." <benjamine.leon@...>
To: user@...
Sent: Mon, November 2, 2009 4:05:19 PM
Subject: [esper-user] Update event property

Hello,

  Currently updating event properties as a preprocessing step of the
stream is available. 

update istream AlertEvent
  set severity = 'High'
  where severity = 'Medium' and reason like '%withdrawal limit%'

Is it possible to update a property of an event  when a different event
is triggered?

Something like

Update istream AlertEvent as a
Set severity='High'  when select  * from TradeEvent as b where
b.tradeId=a.tradeId and b.tradeType='new'

Whenever there is a trade event and it's type is 'new'  and if there is
already an AlertEvent with that trade id, update the severity to high?

Thanks,
Ben


_______________________________________________

This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent to the foregoing.  Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP.  This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

[Thomas Bernhardt]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi Ben,

well when talking about a stream of AlertEvent events then which event in that stream would be updated? I would presume the events held in a named window? We allow insert/remove into a named window and update of an event in a named window is not currently possible.

Best regards
Tom

---

From: "benjamine.leon@..." <benjamine.leon@...>
To: user@...
Sent: Mon, November 2, 2009 4:05:19 PM
Subject: [esper-user] Update event property

Hello,

  Currently updating event properties as a preprocessing step of the
stream is available. 

update istream AlertEvent
  set severity = 'High'
  where severity = 'Medium' and reason like '%withdrawal limit%'

Is it possible to update a property of an event  when a different event
is triggered?

Something like

Update istream AlertEvent as a
Set severity='High'  when select  * from TradeEvent as b where
b.tradeId=a.tradeId and b.tradeType='new'

Whenever there is a trade event and it's type is 'new'  and if there is
already an AlertEvent with that trade id, update the severity to high?

Thanks,
Ben


_______________________________________________

This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent to the foregoing.  Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP.  This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

[Thomas Bernhardt]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi Ben,

well when talking about a stream of AlertEvent events then which event in that stream would be updated? I would presume the events held in a named window? We allow insert/remove into a named window and update of an event in a named window is not currently possible.

Best regards
Tom

---

From: "benjamine.leon@..." <benjamine.leon@...>
To: user@...
Sent: Mon, November 2, 2009 4:05:19 PM
Subject: [esper-user] Update event property

Hello,

  Currently updating event properties as a preprocessing step of the
stream is available. 

update istream AlertEvent
  set severity = 'High'
  where severity = 'Medium' and reason like '%withdrawal limit%'

Is it possible to update a property of an event  when a different event
is triggered?

Something like

Update istream AlertEvent as a
Set severity='High'  when select  * from TradeEvent as b where
b.tradeId=a.tradeId and b.tradeType='new'

Whenever there is a trade event and it's type is 'new'  and if there is
already an AlertEvent with that trade id, update the severity to high?

Thanks,
Ben


_______________________________________________

This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent to the foregoing.  Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP.  This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

[Thomas Bernhardt]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi Ben,

well when talking about a stream of AlertEvent events then which event in that stream would be updated? I would presume the events held in a named window? We allow insert/remove into a named window and update of an event in a named window is not currently possible.

Best regards
Tom

---

From: "benjamine.leon@..." <benjamine.leon@...>
To: user@...
Sent: Mon, November 2, 2009 4:05:19 PM
Subject: [esper-user] Update event property

Hello,

  Currently updating event properties as a preprocessing step of the
stream is available. 

update istream AlertEvent
  set severity = 'High'
  where severity = 'Medium' and reason like '%withdrawal limit%'

Is it possible to update a property of an event  when a different event
is triggered?

Something like

Update istream AlertEvent as a
Set severity='High'  when select  * from TradeEvent as b where
b.tradeId=a.tradeId and b.tradeType='new'

Whenever there is a trade event and it's type is 'new'  and if there is
already an AlertEvent with that trade id, update the severity to high?

Thanks,
Ben


_______________________________________________

This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent to the foregoing.  Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP.  This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

[Thomas Bernhardt]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi Ben,

well when talking about a stream of AlertEvent events then which event in that stream would be updated? I would presume the events held in a named window? We allow insert/remove into a named window and update of an event in a named window is not currently possible.

Best regards
Tom

---

From: "benjamine.leon@..." <benjamine.leon@...>
To: user@...
Sent: Mon, November 2, 2009 4:05:19 PM
Subject: [esper-user] Update event property

Hello,

  Currently updating event properties as a preprocessing step of the
stream is available. 

update istream AlertEvent
  set severity = 'High'
  where severity = 'Medium' and reason like '%withdrawal limit%'

Is it possible to update a property of an event  when a different event
is triggered?

Something like

Update istream AlertEvent as a
Set severity='High'  when select  * from TradeEvent as b where
b.tradeId=a.tradeId and b.tradeType='new'

Whenever there is a trade event and it's type is 'new'  and if there is
already an AlertEvent with that trade id, update the severity to high?

Thanks,
Ben


_______________________________________________

This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent to the foregoing.  Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP.  This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email

[Thomas Bernhardt]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi Ben,

well when talking about a stream of AlertEvent events then which event in that stream would be updated? I would presume the events held in a named window? We allow insert/remove into a named window and update of an event in a named window is not currently possible.

Best regards
Tom

---

From: "benjamine.leon@..." <benjamine.leon@...>
To: user@...
Sent: Mon, November 2, 2009 4:05:19 PM
Subject: [esper-user] Update event property

Hello,

  Currently updating event properties as a preprocessing step of the
stream is available. 

update istream AlertEvent
  set severity = 'High'
  where severity = 'Medium' and reason like '%withdrawal limit%'

Is it possible to update a property of an event  when a different event
is triggered?

Something like

Update istream AlertEvent as a
Set severity='High'  when select  * from TradeEvent as b where
b.tradeId=a.tradeId and b.tradeType='new'

Whenever there is a trade event and it's type is 'new'  and if there is
already an AlertEvent with that trade id, update the severity to high?

Thanks,
Ben


_______________________________________________

This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent to the foregoing.  Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP.  This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email