8 Replies Latest reply: Sep 2, 2014 2:05 AM by jagan mohan rao appala RSS

    Section access wild card

    Daniel Moore

      I'm trying to do a simple row level section access. It seems to work for users,  but I am trying to use wildcards for admins, so they can see all accounts. Unfortunately when I use the wildcard it's treated the same as any other text value - so it is looking for the REDUCTION called * and not finding any in the data.

       

      How do let QV know I'm looking ANYTHING not just something called *?

       

       

      Section Access;

      LOAD USERID,
      '*'
      as PASSWORD,
      ACCESS
      FROM
      Visibility.qvd
      (
      qvd) WHERE 1=1;

      SECTION APPLICATION;

      LOAD USERID,
          
      REDUCTION
      FROM
      Visibility.qvd
      (
      qvd) WHERE 1=1;