12 Replies Latest reply: Aug 14, 2015 1:47 AM by Pradip Sen RSS

    Creating Flag  ! ?

    Priyanka Rao

      Hi,

      I have a scenario wherein, I have Rule_Set, ID_no, Sys_Key.

      Rule_SetID_noSys_Key
      Rule112341A
      Rule123451B
      Rule234561A
      Rule345671C

      There is another Table (a Mapping Load) which has Certain Rule_Set and Sys_Key Defined. like;

      Rule_SetSys_Key
      Rule11A
      Rule21A

       

      The requirement is , the  ID_no should be fetched , for the Rules mentioned in the Mapping Load Table for the Sys_Key, If the rule is not mentioned, then all the Sys_Key should be fetched. thus the result should be;

      Rule_SetID_noSys_Key
      Rule112341A
      Rule23456

      1A

      Rule3

      45671C

       

      The actual app has a complex data, hence Association is not the solution.

      I was thinking of creating the Flag , but it somehow is feting the 'ID_no 3456' in this case  for the condition where I am trying to get the rules not mentioned in the Mapping Table.

       

      Appreciate  any help!

      Thanks !