0 Replies Latest reply: Apr 23, 2014 8:12 AM by Friedrich Hofmann RSS

    SECTION_ACCESS with OMIT fields

    Friedrich Hofmann


      Hi,

       

      in my personell_app, I would like to introduce something new:

      - There should be names, but

      - ONLY for the HR department and myself

      => For all other users, the names should not be loaded into the DataModel.

       

      => In principle, this should be easy: In my SA (which I construct from two parts, a short inline_table and a LOAD from an excel file), I have introduced a new field, OMIT.

      => As I have eight name_fields (I had to work with alias names a few times to avoid synthetic keys), every user has eight lines in the
           Excel field.

      <=> It works but for the OMIT fields - those remain visible. I have only tested with one user (from the Excel list) and one chart (that is, two name_fields), but those are visible.

      Can anybody tell me what I'm doing wrong here?`

      I paste here the code for both parts of the SA. There must be something wrong there.

      Oh - I have checked that "restrict data based on ..." in the document_properties, and the one below ("restrictive mode") too.

       

      SA_temp:

      LOAD * INLINE [
          ACCESS, NTNAME, OMIT
          ADMIN, [domain]\friedrich.hofmann,
          USER, [domain]\SYNCREON\rgb1.hr,
      ]
      ;
      // Zunächst werden hier alle anderen User aus einer Excel-Liste angehängt

      Concatenate
      LOAD
          
      ACCESS,
          
      NTNAME,
          
      OMIT
      FROM
      [Users_with_limited_access_rights_b.xls
      (
      biff, embedded labels, table is [Sheet1$]);
      // Jetzt können wir diese Gesamttabelle RESIDENT laden und für den SA verwenden
      Section Access;
      LOAD
         
      ACCESS,
         
      NTNAME,
         
      OMIT
      RESIDENT SA_temp
      ;

      DROP TABLE SA_temp;


      (attached is the Excel file for the second part of the SA)

       

      Thanks a lot!

      Best regards,

       

      DataNibbler