2 Replies Latest reply: Jun 28, 2017 11:37 PM by Ramachandra Geethala RSS

    section access mask

    Ramachandra Geethala

      Hi Hunters,

       

      I have a requirement in the section access like below.

       

      input.

       

         

      sitestatedisitnctsales
      Indiaapongole80
      Indiaapnell85
      indiabhpparadise23
      indiabhpcellorium45
      usremedycalom86
      usremedysiral75
      kenadakalosarichel66
      kenadakalosasilaj89
      kenadasumeraaparlak25
      non-southpradeshkilkut36

      non-south


       

      pradeshsuraj25

       

      output for admin.


         

      sitestatedisitnctsales
      Indiaapongole80
      Indiaapnell85
      indiabhpparadise23
      indiabhpcellorium45
      usremedycalom86
      usremedysiral75
      kenadakalosarichel66
      kenadakalosasilaj89
      kenadasumeraaparlak25
      non-southpradeshkilkut36
      non-southpradeshsuraj25


      out put for who is having india access

         

         

      sitestatedisitnctsales
      Indiaapongole80
      Indiaapnell85
      indiabhpparadise23
      indiabhpcellorium45
      site2remedydefault86
      site2remedydefault75
      site3kalosadefault66
      site3kalosadefault89
      site3sumeradefault25
      non-southpradeshkilkut36
      non-southpradeshsuraj25


      out put for  who is having us access

       

         

      sitestatedisitnctsales
      site1apdefault80
      site1apdefault85
      site1bhpdefault23
      site1bhpdefault45
      usremedycalom86
      usremedysiral75
      site3kalosadefault66
      site3kalosadefault89
      site3sumeradefault25
      non-southpradeshkilkut36

      non-south

       

       

      pradeshsuraj25

       

        • Re: section access mask
          Antonio Mancini

          Hi,

           

          SECTION Access;
          LOAD * Inline [
          ACCESS,USERID,PASSWORD,SITE
          ADMIN,ADMIN,ADMIN,
          USER,USER1,USER1,INDIA
          USER,USER1,USER1,NON-SOUTH
          USER,USER2,USER2,US
          USER,USER2,USER2,NON-SOUTH
          ]
          ;
          SECTION Application;

          LOAD Upper(Site) as SITE,* Inline [
          Site state disitnct sales
          India ap ongole 80
          India ap nell 85
          India bhp paradise 23
          India bhp cellorium 45
          us remedy calom 86
          us remedy siral 75
          kenada kalosa richel 66
          kenada kalosa silaj 89
          kenada sumera aparlak 25
          non-south pradesh kilkut 36
          non-south pradesh suraj 25
          ]
          (delimiter is
          spaces);

           

          See Attachment.

           

          Users :

          ADMIN,ADMIN

          USER1,USER1

          USER2,USER2

           

          Regards,

          Antonio