PDS Bug ? (incrorrect stored procedure)

M

Mikaelo

Hello!

I have some problems when working with RBS structure from PDS.

When i update RBS using PDS methods it corrupt view in PWA.

I trace problem to MSP_PDS_CacheFullName stored procedure
it contain sql - query like

select @code_mask = AS_VALUE
from MSP_FIELD_ATTRIBUTES fa inner join MSP_ATTRIBUTE_STRINGS ats on
fa.AS_ID = ats.AS_ID
where fa.ATTRIB_ID = 200
and fa.ATTRIB_FIELD_ID = @field_id
and fa.PROJ_ID = @ent_global_id

i think this is no right code because if you look to db documentation you
see that key to MSP_ATTRIBUTE_STRINGS not only as_id by also proj_id

i think right code is

select @code_mask = AS_VALUE
from MSP_FIELD_ATTRIBUTES fa inner join MSP_ATTRIBUTE_STRINGS ats on
fa.AS_ID = ats.AS_ID and fa.PROJ_ID = ats.PROJ_ID
where fa.ATTRIB_ID = 200
and fa.ATTRIB_FIELD_ID = @field_id
and fa.PROJ_ID = @ent_global_id

Am I Right ?

Thanks
 
Top