|
Home > Archive > BizTalk Server General > February 2005 > updating an existing row in BAM tables
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
updating an existing row in BAM tables
|
|
| siddharth 2005-02-14, 5:50 pm |
| Hi All,
Please if some one can help me with following.
i am simplifying my current project requirements only emphasizing on my
question.
so i have two orchestrations.
1)newServiceRequestOrchestration ==> this orchestration receives new service
request. it does some common validation on data and then just stores the data.
now, to store the data(service request) i am using BAM.
lets say 'newServiceRequestOrchestration' receives one service request . so
after execution of the orchestration instance i would see
one row in BAM (Activity_completed) table with a status of 'NEW'.
'status' is my own field ..tells me about the status of the service request
...if it's 'NEW' or 'COMPLETED' etc..
2)ServiceRequestCompletionOrchestration ==> after the row is saved in BAM
tables by first orchestartion , user will be able to work on it by a asp.net
interface.
so for that i am planning to pull(stored procedure) this 'NEW' service
request directly form BAM tables and present in a user interface(ASP.net) .
now this is where second orchestration comes into picture...when user
works(completes) the service request and saves it... data will flow through
the second orchestration
'ServiceRequestCompletionOrchestration'.
i could BAM this data again..but the problem is i will end up creating a new
row in the same BAM table.
i do not want to create a new row as far as possible..i want to be able to
update just the 'status'
field of the same(old) row from 'NEW' to 'Completed'...
how do i do that?
i have looked at "construct connected activities in msdn"
http://msdn.microsoft.com/library/d...acking_wdec.asp
....i am not sure if that's same as my case because this explains how you can
update the same row ..but they are still happening in short time window.
in other words even before biztalk(BAM) really commits the data....which is
different from my case where i have committed the data once ..now at later
point of time i want go back and modify the same data...
thanks
siddharth
| |
| Ian Cross (Cassium) 2005-02-14, 8:46 pm |
| Are you using the BAM API or TPE to capture the data
This should be simple to do with the BAM API if you use UpdateActivity (with
the same ActivityId). The BAM record should only move to the Completed table
if you use EndActivity. Once the BAM Activity has moved to completed, it
makes sense that a new row is completed if you start referencing again...
Cheers, Ian
"siddharth" wrote:
> Hi All,
> Please if some one can help me with following.
>
> i am simplifying my current project requirements only emphasizing on my
> question.
> so i have two orchestrations.
>
> 1)newServiceRequestOrchestration ==> this orchestration receives new service
> request. it does some common validation on data and then just stores the data.
> now, to store the data(service request) i am using BAM.
>
> lets say 'newServiceRequestOrchestration' receives one service request . so
> after execution of the orchestration instance i would see
> one row in BAM (Activity_completed) table with a status of 'NEW'.
>
> 'status' is my own field ..tells me about the status of the service request
> ..if it's 'NEW' or 'COMPLETED' etc..
>
> 2)ServiceRequestCompletionOrchestration ==> after the row is saved in BAM
> tables by first orchestartion , user will be able to work on it by a asp.net
> interface.
>
> so for that i am planning to pull(stored procedure) this 'NEW' service
> request directly form BAM tables and present in a user interface(ASP.net) .
>
>
> now this is where second orchestration comes into picture...when user
> works(completes) the service request and saves it... data will flow through
> the second orchestration
> 'ServiceRequestCompletionOrchestration'.
>
> i could BAM this data again..but the problem is i will end up creating a new
> row in the same BAM table.
> i do not want to create a new row as far as possible..i want to be able to
> update just the 'status'
> field of the same(old) row from 'NEW' to 'Completed'...
>
> how do i do that?
>
> i have looked at "construct connected activities in msdn"
> http://msdn.microsoft.com/library/d...acking_wdec.asp
> ...i am not sure if that's same as my case because this explains how you can
> update the same row ..but they are still happening in short time window.
> in other words even before biztalk(BAM) really commits the data....which is
> different from my case where i have committed the data once ..now at later
> point of time i want go back and modify the same data...
>
> thanks
> siddharth
>
| |
| siddharth 2005-02-14, 8:46 pm |
| Ian,
thanks for the reply..
i am using TPE .
could you explian what you mean by
"Once the BAM Activity has moved to completed, it
makes sense that a new row is completed if you start referencing again"
thanks
siddharth
"Ian Cross (Cassium)" wrote:
[vbcol=seagreen]
> Are you using the BAM API or TPE to capture the data
>
> This should be simple to do with the BAM API if you use UpdateActivity (with
> the same ActivityId). The BAM record should only move to the Completed table
> if you use EndActivity. Once the BAM Activity has moved to completed, it
> makes sense that a new row is completed if you start referencing again...
>
> Cheers, Ian
>
>
>
> "siddharth" wrote:
>
| |
| siddharth 2005-02-14, 8:46 pm |
| Ian ,
i am trying to modify the row after it has moved in BAM completed table.
so first orchestration does it work ..so you will see a row in completed
table.
now at some later point of time aps.net interface pulls this row ..changes
it and wants to save the changes ...basically update the same row in bam.
i confused ,if use of BAM , the way i am using it ..is correct...
may be it's more for read only data gathering(monitoring) ..but not for
modifying(updating) it at later point of time as i am trying to do..
even if i decide to use API to accomplish this ..
can i go back and update a row in completed table after EndActivity is
called on it.
-siddharth
"Ian Cross (Cassium)" wrote:
[vbcol=seagreen]
> Are you using the BAM API or TPE to capture the data
>
> This should be simple to do with the BAM API if you use UpdateActivity (with
> the same ActivityId). The BAM record should only move to the Completed table
> if you use EndActivity. Once the BAM Activity has moved to completed, it
> makes sense that a new row is completed if you start referencing again...
>
> Cheers, Ian
>
>
>
> "siddharth" wrote:
>
| |
| Derek Tan [MSFT] 2005-02-14, 8:46 pm |
| Hi Siddharth,
The link http://msdn.microsoft.com/library/d...acking_wdec.asp applies to
your case.
In your first orchestration "newServiceRequestOrchestration", create a continuation folder that has a unique key (any data
item that is unique) mapped to it. You can rename the continuation folder to (say), "Orch1".
In the other orchestration "ServiceRequestCompletionOrchestration", create a continuation ID that has the same unique
key mapped to it, making sure that the name of the continuation ID is "Orch1" as well.
When you run the first orchestration again, we should see that the record ends up in the active bam table. Only when you
run the other orchestration, does the record go to the completed table.
Regards,
Derek [MSFT]
--------------------
>Thread-Topic: updating an existing row in BAM tables
>thread-index: AcUS8x0DWRkBjuSzTAyX2TLBUNfIcw==
>X-WBNR-Posting-Host: 63.166.226.90
>From: =?Utf-8?B?c2lkZGhhcnRo?= <siddharth@discussions.microsoft.com>
>References: <02F6DA54-CF07-47FD-8399-B14EFE6EA6CA@microsoft.com> <2B9DD4D4-C277-4E5F-832A-
08FA4C0EB5D7@microsoft.com>
>Subject: RE: updating an existing row in BAM tables
>Date: Mon, 14 Feb 2005 16:13:02 -0800
>Lines: 76
>Message-ID: <A0F9D02F-F028-4A6C-9DCE-6E544BAF6B44@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>Path: TK2MSFTNGXA01.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.biztalk.general:11173
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>Ian,
>thanks for the reply..
>i am using TPE .
>
>could you explian what you mean by
>"Once the BAM Activity has moved to completed, it
>makes sense that a new row is completed if you start referencing again"
>
>thanks
>siddharth
>
>"Ian Cross (Cassium)" wrote:
>
>
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to
the terms specified at http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread
from which they originated.
| |
| siddharth 2005-02-14, 8:46 pm |
| thanks Derek,
so idea is that once you set up continuation ...item(row) will not be moved
to completed table untill it completes the last step(orchestration) in
continution.
i need to try this in a sample application....
i will post a update.
thanks
siddharth
"Derek Tan [MSFT]" wrote:
> Hi Siddharth,
>
> The link http://msdn.microsoft.com/library/d...acking_wdec.asp applies to
> your case.
>
> In your first orchestration "newServiceRequestOrchestration", create a continuation folder that has a unique key (any data
> item that is unique) mapped to it. You can rename the continuation folder to (say), "Orch1".
>
> In the other orchestration "ServiceRequestCompletionOrchestration", create a continuation ID that has the same unique
> key mapped to it, making sure that the name of the continuation ID is "Orch1" as well.
>
> When you run the first orchestration again, we should see that the record ends up in the active bam table. Only when you
> run the other orchestration, does the record go to the completed table.
>
> Regards,
> Derek [MSFT]
>
> --------------------
> 08FA4C0EB5D7@microsoft.com>
>
>
> --
>
> This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to
> the terms specified at http://www.microsoft.com/info/cpyright.htm
>
> Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread
> from which they originated.
>
>
| |
| Derek Tan [MSFT] 2005-02-14, 8:46 pm |
| Yes, that is the case. Try out our SDK http://www.msdn.microsoft.com/libra...rl=/library/en-
us/def/htm/ebiz_def_portal_page.asp to get a better understanding.
You can use the bm deploy created view that unions the active and completed tables.
Regards,
Derek [MSFT]
--------------------
>Thread-Topic: updating an existing row in BAM tables
>thread-index: AcUS/A4VFX/pcSivSMG8wrOMQrOT2Q==
>X-WBNR-Posting-Host: 63.166.226.83
>From: =?Utf-8?B?c2lkZGhhcnRo?= <siddharth@discussions.microsoft.com>
>References: <02F6DA54-CF07-47FD-8399-B14EFE6EA6CA@microsoft.com> <2B9DD4D4-C277-4E5F-832A-
08FA4C0EB5D7@microsoft.com> <A0F9D02F-F028-4A6C-9DCE-6E544BAF6B44@microsoft.com> <9fRXVivEFHA.4072
@TK2MSFTNGXA01.phx.gbl>
>Subject: RE: updating an existing row in BAM tables
>Date: Mon, 14 Feb 2005 17:17:02 -0800
>Lines: 144
>Message-ID: <57E05B43-111F-4F02-A454-BE22295BE3A7@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>Path: TK2MSFTNGXA01.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.biztalk.general:11178
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>thanks Derek,
>so idea is that once you set up continuation ...item(row) will not be moved
>to completed table untill it completes the last step(orchestration) in
>continution.
>
>i need to try this in a sample application....
>i will post a update.
>thanks
>siddharth
>
>
>"Derek Tan [MSFT]" wrote:
>
to[vbcol=seagreen]
data[vbcol=seagreen]
newsgroup/thread[vbcol=seagreen]
>
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to
the terms specified at http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread
from which they originated.
| |
| siddharth 2005-02-15, 5:50 pm |
| Hi Derek,
we can do continutaion becase we had two seprate orchestrations..
so..
lets say between 'NEW' and 'COMPLETED' there is another status called
'INPROCESS' ...
so flow is
Step1==> first orchestration saves item(row) in BAM with a status of 'NEW'
step2==>asp.net interface pulls it and makes some changes in data and saves
it .
lets say only partial(some business rules) data is changed so now it's in
'INPROCESS' and not completed.
still asp.net will pass data through same second orchestration
'ServiceRequestCompletionOrchestration'.
step3==> now at later point of time user(asp.net) interface will pull this
partialy edited
'INPROCESS' record and and do all required changes ...
now state changes to 'COMPLETED'...so now the same row in bam need to be
updated with status of 'COMPLETED'.
but the problem here is it's same second
orchestration'ServiceRequestCompletionOr
chestration' is used again to to
persists data to BAM.
so when the step2 was executing that time itself ...item will move to
completed becuse for BAM it's just
two step continuation...but businesswise it's three step process before a
item could be marked as completed.
how do i handle this WITHOUT introducing a sperate third orcehstration so
that BAM knows that it's three step continuation.
I want to be able to use TPE as far as possible.
thanks
siddharth
"Derek Tan [MSFT]" wrote:
> Yes, that is the case. Try out our SDK http://www.msdn.microsoft.com/libra...rl=/library/en-
> us/def/htm/ebiz_def_portal_page.asp to get a better understanding.
>
> You can use the bm deploy created view that unions the active and completed tables.
>
> Regards,
> Derek [MSFT]
>
> --------------------
> 08FA4C0EB5D7@microsoft.com> <A0F9D02F-F028-4A6C-9DCE-6E544BAF6B44@microsoft.com> <9fRXVivEFHA.4072
> @TK2MSFTNGXA01.phx.gbl>
> to
> data
> newsgroup/thread
>
>
> --
>
> This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to
> the terms specified at http://www.microsoft.com/info/cpyright.htm
>
> Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread
> from which they originated.
>
>
| |
| Derek Tan [MSFT] 2005-02-15, 5:50 pm |
| Hi Siddharth,
In the new scenario that you are decribing:
If the 2nd orchestration is called more than once, you have to create two activities, one for the first orchestration and the other for the 2nd orchestration. You will then use
relationship folders in TPE to link these two activities together. See http://www.msdn.microsoft.com/libra...portal_page.asp for
details. Note that since you're calling the 2nd orchestration twice, you should use unique activity Ids each time it is being called. Continuation is not used in this case.
You can then create a custom view joining the existing views to get a single unified view that you want. Refer to http://www.msdn.microsoft.com/libra...rl=/library/en-
us/sdk/htm/ebiz_prog_bam2_xxbo.asp on how to query Bam data.
Regards,
Derek
--------------------
>Thread-Topic: updating an existing row in BAM tables
>thread-index: AcUTgwDsgSXj9VLITTaVi7QER2oSXw==
>X-WBNR-Posting-Host: 63.166.226.115
>From: =?Utf-8?B?c2lkZGhhcnRo?= <siddharth@discussions.microsoft.com>
>References: <02F6DA54-CF07-47FD-8399-B14EFE6EA6CA@microsoft.com> <2B9DD4D4-C277-4E5F-832A-08FA4C0EB5D7@microsoft.com> <A0F9D02F-F028-4A6C-
9DCE-6E544BAF6B44@microsoft.com> <9fRXVivEFHA.4072@TK2MSFTNGXA01.phx.gbl> <57E05B43-111F-4F02-A454-BE22295BE3A7@microsoft.com>
<wwfuRJwEFHA.4072@TK2MSFTNGXA01.phx.gbl>
>Subject: RE: updating an existing row in BAM tables
>Date: Tue, 15 Feb 2005 09:23:02 -0800
>Lines: 242
>Message-ID: <89DFD090-1A91-4720-97C3-3A7C6505FEDA@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.biztalk.general:11247
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>Hi Derek,
>we can do continutaion becase we had two seprate orchestrations..
>
>so..
>lets say between 'NEW' and 'COMPLETED' there is another status called
>'INPROCESS' ...
>
>so flow is
>Step1==> first orchestration saves item(row) in BAM with a status of 'NEW'
>
>
>step2==>asp.net interface pulls it and makes some changes in data and saves
>it .
>lets say only partial(some business rules) data is changed so now it's in
>'INPROCESS' and not completed.
>
>still asp.net will pass data through same second orchestration
>'ServiceRequestCompletionOrchestration'.
>
>
>step3==> now at later point of time user(asp.net) interface will pull this
>partialy edited
>'INPROCESS' record and and do all required changes ...
>now state changes to 'COMPLETED'...so now the same row in bam need to be
>updated with status of 'COMPLETED'.
>
>
>but the problem here is it's same second
> orchestration'ServiceRequestCompletionOr
chestration' is used again to to
>persists data to BAM.
>
>so when the step2 was executing that time itself ...item will move to
>completed becuse for BAM it's just
>two step continuation...but businesswise it's three step process before a
>item could be marked as completed.
>
>how do i handle this WITHOUT introducing a sperate third orcehstration so
>that BAM knows that it's three step continuation.
>
>I want to be able to use TPE as far as possible.
>
>thanks
>siddharth
>
>
>
>"Derek Tan [MSFT]" wrote:
>
>
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
| |
| siddharth 2005-02-17, 5:51 pm |
| derek thanks for you reply..
if i use 'relationship' ...won't i endup creating two rows in the second
activity for the same item.
one for ...'INPROCESS' status....
then a second row for ....'COMPLETED'...
as far as i know.. relation ship does not help me with updating the same
row..relationship will help me in relating the two rows in second actvity to
a row in first activity.....
i am trying to avoid having multiple rows in BAM storage for the same item
just because i have to update one of the coulumn in the row..'STATUS' column
in myexample.
thanks
siddharth
"Derek Tan [MSFT]" wrote:
> Hi Siddharth,
>
> In the new scenario that you are decribing:
> If the 2nd orchestration is called more than once, you have to create two activities, one for the first orchestration and the other for the 2nd orchestration. You will then use
> relationship folders in TPE to link these two activities together. See http://www.msdn.microsoft.com/libra...portal_page.asp for
> details. Note that since you're calling the 2nd orchestration twice, you should use unique activity Ids each time it is being called. Continuation is not used in this case.
>
> You can then create a custom view joining the existing views to get a single unified view that you want. Refer to http://www.msdn.microsoft.com/libra...rl=/library/en-
> us/sdk/htm/ebiz_prog_bam2_xxbo.asp on how to query Bam data.
>
> Regards,
> Derek
>
>
> --------------------
> 9DCE-6E544BAF6B44@microsoft.com> <9fRXVivEFHA.4072@TK2MSFTNGXA01.phx.gbl> <57E05B43-111F-4F02-A454-BE22295BE3A7@microsoft.com>
> <wwfuRJwEFHA.4072@TK2MSFTNGXA01.phx.gbl>
>
>
> --
>
> This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
>
>
| |
| Derek Tan [MSFT] 2005-02-17, 8:48 pm |
| Hi Siddharth,
In your main activity (say) M, you will have a single row with status column as "NEW" and activity Id (say), "A".
In your other activity (say) R, you will have two rows, one with status column as "INPROCESS" and activity Id (say) "B" and the other row with status column as "COMPLETED" and activity Id (say) "C".
As you have used TPE to relate these two activities (M & R) together, using the relationship view, you can find out which other activity instances are related to "A" (in this case, they would be "B" & "C"). To have a
unified view of the process, create a new customized Sql view that joins the two views of activity M and R using the relationship view that shows you the final status.
Hope this helps.
Derek [MSFT]
--------------------
>Thread-Topic: updating an existing row in BAM tables
>thread-index: AcUVHJnYJrmo8+B3S5yu1wpM23dDIg==
>X-WBNR-Posting-Host: 63.166.226.83
>From: =?Utf-8?B?c2lkZGhhcnRo?= <siddharth@discussions.microsoft.com>
>References: <02F6DA54-CF07-47FD-8399-B14EFE6EA6CA@microsoft.com> <2B9DD4D4-C277-4E5F-832A-08FA4C0EB5D7@microsoft.com> <A0F9D02F-F028-4A6C-9DCE-6E544BAF6B44@microsoft.com>
<9fRXVivEFHA.4072@TK2MSFTNGXA01.phx.gbl> <57E05B43-111F-4F02-A454-BE22295BE3A7@microsoft.com> <wwfuRJwEFHA.4072@TK2MSFTNGXA01.phx.gbl> <89DFD090-1A91-4720-97C3-
3A7C6505FEDA@microsoft.com> <QUzSUa6EFHA.1240@TK2MSFTNGXA01.phx.gbl>
>Subject: RE: updating an existing row in BAM tables
>Date: Thu, 17 Feb 2005 10:15:03 -0800
>Lines: 316
>Message-ID: <BA37E99F-A4C4-42CE-97D9-41EA03516253@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.biztalk.general:11353
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>derek thanks for you reply..
>
>if i use 'relationship' ...won't i endup creating two rows in the second
>activity for the same item.
>
>one for ...'INPROCESS' status....
>then a second row for ....'COMPLETED'...
>
>as far as i know.. relation ship does not help me with updating the same
>row..relationship will help me in relating the two rows in second actvity to
>a row in first activity.....
>
>i am trying to avoid having multiple rows in BAM storage for the same item
>just because i have to update one of the coulumn in the row..'STATUS' column
>in myexample.
>
>thanks
>siddharth
>
>
>"Derek Tan [MSFT]" wrote:
>
>
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
| |
| siddharth 2005-02-25, 8:46 pm |
| thanks
"Derek Tan [MSFT]" wrote:
> Hi Siddharth,
>
> In your main activity (say) M, you will have a single row with status column as "NEW" and activity Id (say), "A".
>
> In your other activity (say) R, you will have two rows, one with status column as "INPROCESS" and activity Id (say) "B" and the other row with status column as "COMPLETED" and activity Id (say) "C".
>
> As you have used TPE to relate these two activities (M & R) together, using the relationship view, you can find out which other activity instances are related to "A" (in this case, they would be "B" & "C"). To have a
> unified view of the process, create a new customized Sql view that joins the two views of activity M and R using the relationship view that shows you the final status.
>
> Hope this helps.
> Derek [MSFT]
>
>
> --------------------
> <9fRXVivEFHA.4072@TK2MSFTNGXA01.phx.gbl> <57E05B43-111F-4F02-A454-BE22295BE3A7@microsoft.com> <wwfuRJwEFHA.4072@TK2MSFTNGXA01.phx.gbl> <89DFD090-1A91-4720-97C3-
> 3A7C6505FEDA@microsoft.com> <QUzSUa6EFHA.1240@TK2MSFTNGXA01.phx.gbl>
>
>
> --
>
> This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
>
> Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
>
>
|
|
|
|
|