AnsweredAssumed Answered

SRM_RESOURCES.ID = PAC_MNT_RESOURCES.ID ( + ) - Incorrect ?

Question asked by navzjoshi00 Champion on Nov 26, 2014
Latest reply on Nov 26, 2014 by urmas

For one of the portlets, when I try to filter for a resource, A, it comes up with the information of another resource B

 

I checked the query and saw the following mentioned -

 

SRM_RESOURCES.ID = PAC_MNT_RESOURCES.ID ( + )

 

As faar as my understanding goes,

 

PAC_MNT_RESOURCES.ID = This column refers to the unique identifier for a row in this table.

 

And, the way to get the data for the resource data is to join by the resource_code (user_name) in the CMN_SEC_USERS table.

 

Please corect if wrong

 

NJ

Outcomes