Biztalk Server Rule development query
I have a requirement for rule creation as below:
There is a xml message received with following structure:
when messages start coming I need to apply rules such that if the first message is accepted and if the same message (i.e. with the same messagename, and ServerName) arrives within 4 hours discard those following messages.
The plan is to save the accepted message (the first message ariving in a sql server DB and when subsequent messages arrives to compare with the records and find out if there is a similar message (i.e. with the same messagename, and ServerName) and the time difference is < or = 4 hrs.and discard those messages.
any idea of how we can check the time diff. and apply this BTS rule?
Thanks in advance,