1 Reply Latest reply: Aug 16, 2012 7:51 AM by Rajni Batra RSS

    Session Access not working properly (QV11)

    Ronald Calolot

      Hi Guys,

       

       

      I encountered a weird situation wherein section access is not working properly. If I login using AA, the COUNTRY is filtered by INDIA, which supposed to see all the data. If I login using BB, COUNTRY is filtered correctly. Is this a bug or did I miss something?

       

      Here's my code:

       

      SECTION ACCESS;

      SECURITY_TABLE:

      LOAD * INLINE

             [

          ACCESS, USERID, PASSWORD, NTNAME, COUNTRY

          ADMIN , AA,  AA,     *,  *

          USER , BB,  BB,      *,  INDIA

       

          ]

             ;

            

      SECTION APPLICATION;

       

      LOAD * INLINE [

      COUNTRY

      AUSTRALIA

      SINGAPORE

      PHILIPPINES

      INDIA

       

      ];

       

       

      Thanks,

       

      Ronald

        • Re: Session Access not working properly (QV11)
          Rajni Batra

          when we use * as above u have written it will display only values of Country you defined in inline Table,

          if you want to display all the countries then u have to write then in the table,

           

          e.g.

           

           

              ACCESS, USERID, PASSWORD, NTNAME, COUNTRY

              ADMIN , AA,  AA,     *,  INDIA

              ADMIN , AA,  AA,     *,  AUSTRALIA

               ADMIN , AA,  AA,     *,  U.S.A

              USER , BB,  BB,      *,  INDIA

           

             OR(IN EXCEL)

           

          ACCESS USERID PASSWORD NTNAME COUNTRY

          ADMIN      AA            AA                   *               *

          USER       BB           BB                  *               INDIA

                                                                                     AUSTRALIA

                                                                                      U.S.A

           

           

          Hope to Help !!!