Versions Compared

Old Version 17

changes.mady.by.user Radek Micka

Saved on

compared with

New Version 18

changes.mady.by.user Radek Micka

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Sv translation
languageen

Here is an example of a security level definition.

Let's assume:

  • today's date is 11.11.2020
  • User info is set to 11


We will be using this query:

Code Block
languagesql
select MDS74.L_RESTRICTION from $mainDataset(78) PT JOIN $dataset(74) MDS74 ON (PT.L_EXTENDED=MDS74.L_ADDINFO) where (PT.L_MAIN = '$user(info)' AND PT.L_START<= '$date(now)')

This query will be used as an example of how to use JOIN or variables.


We will be applying our restriction to column L_PARTITION



From the last table where we applied our security level, the logged user will get only rows where Partition value is 1 (orange colour)

Sv translation
languagesk

Here is an example of a security level definition.

Let's assume:

  • today's date is 11.11.2020
  • User info is set to 11


We will be using this query:

Code Block
languagesql
select MDS74.L_RESTRICTION from $mainDataset(78) PT JOIN $dataset(74) MDS74 ON (PT.L_EXTENDED=MDS74.L_ADDINFO) where (PT.L_MAIN = '$user(info)' AND PT.L_START<= '$date(now)')

This query will be used as an example of how to use JOIN or variables.


We will be applying our restriction to column L_PARTITION


Image Added


From the last table where we applied our security level, the logged user will get only rows where Partition value is 1 (orange colour)

Note

Ibap použivatelia s rolou "manažér dát" môžu vytvárať a spravovať skupiny dát.

Otvorte stránku Skupiny dát z hlavného menu. 

  1. Kliknite na odkaz "Vytvoriť skupinu dát". Otvorí sa nové okno. 
  2. Zadajte meno novej skupin dát.
Note

Názov musí byť unikátny pre celú doménu. Ak sa zadané meno zhoduje s už existujúcim menom, objaví sa varovná hláška a nové skupin dát nebude vytvorená.

Nová skupina dát neobsahuje žiadne ukazovatele alebo atribúty. Je možné ich vytvoriť dvoma spôsobmi:

  • Vytvoriť pomocou importu dát. Ak máte pripravený nejaký súbor s dátami, tak odporúčame túto variantu.
  • Vytvoriť ich manuálne. Pridelenie jednotlivých ukazovateľov a atribútov k dátam je dostupné pri importe. 
Info

Skupinu dát je tiež možné vytvoriť priamo importom dát.

Kam ďalej

Tutorialové video

HTML
<iframe width="560" height="315" src="https://www.youtube.com/embed/-CFhx-if1lM" frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

 

 


Sv translation
languageja

Here is an example of a security level definition.

Let's assume:

  • today's date is 11.11.2020
  • User info is set to 11


We will be using this query:

Code Block
languagesql
select MDS74.L_RESTRICTION from $mainDataset(78) PT JOIN $dataset(74) MDS74 ON (PT.L_EXTENDED=MDS74.L_ADDINFO) where (PT.L_MAIN = '$user(info)' AND PT.L_START<= '$date(now)')

This query will be used as an example of how to use JOIN or variables.


We will be applying our restriction to column L_PARTITION



From the last table where we applied our security level, the logged user will get only rows where Partition value is 1 (orange colour)

...