Change Requests / Physical Items List

PS, it works in Director so it looks like a web only problem.

Hi Andrew,

I guess this is a bug. If the behaviour are different between interfaces, then it is definetly a Bug in web.

I will create a SR for you and will update you with the TS for the same.

I confirmed that there are not much changes for versions, the way it works for Phyysical Item list.

so you see the same behaviour as me?

Hi Manav,

When you look at what SQL is doing when using Director you
see this:

declare @p7 int

set @p7=1

declare @p9 int

set @p9=64

exec ebp_uprev_document
@pi_old_doc_id=34,@ps_new_revn_name=N'02',@ps_imp_co_ids=N'05',@ps_fwd_co_ids=N'0',@ps_copy_options=N'Header;Interfaces;ControlledObjects;ItemList;',@pi_copy_batch_size=200,@pi_copy_row_count=@p7
output,@pi_called_by=762,@pi_new_doc_id=@p9 output

select @p7, @p9

Notice that the copy options parameters include 'ItemList’

Now if you look at what happens when doing the same thing in
the Web you get this:

declare @p7 int

set @p7=0

declare @p9 int

set @p9=68

exec ebp_uprev_document @pi_old_doc_id=34,@ps_new_revn_name=N'02',@ps_imp_co_ids=N'5',@ps_fwd_co_ids=NULL,@ps_copy_options=N'Header;Interfaces;TemplateRef;ControlledObjects',@pi_copy_batch_size=200,@pi_copy_row_count=@p7 output,@pi_called_by=761,@pi_new_doc_id=@p9 output

select @p7, @p9

Take note that ItemList is missing from the copy options
parameters.  The next thing I like looked
for is what was populating the ps_copy_options parameter.  I suspect it’s a stored procedure called
ebpnew_get_copy_options

I determined that when you go to implement a physical item
list ECR from Director the systems runs this:

exec ebpnew_get_copy_options
@pi_object_id=34,@pi_object_type=3,@ps_option=N'Header',@ps_filter=N'HasData =
''Y''',@pi_start_at=1,@pi_rows=1000000,@pi_called_by=1

However when you try the same implementation from the web it
looks like this:

exec ebpnew_get_copy_options
@pi_object_id=34,@pi_object_type=3,@ps_option=N'Header',@ps_filter=NULL,@pi_start_at=1,@pi_rows=1000000,@pi_called_by=1

I really need a fix for this urgently.