My DAC title

My DAC description

clear

Reference

  • Allowed field are: date full_name email username organisation dataset_title dac dac_title dac_comment
  • Logical operators: and or not For example: dataset = 'EGAD00000000207' AND email='example@mail.com'
  • Equality operators: = != For example: dataset = 'EGAD00000000207'
  • Date operators: > < >= <= = For example: date >= 2020/01/01 AND date <= 2020/02/28
  • Pattern operators(case insensitive): ~ !~ For example: email ~ '*@example.com' email !~ '*example*'
  • List operators: in not in For example: dataset in ('EGAD00000000207', 'EGAD00000000208') dataset not in ('EGAD00000000040')
  • Nullity operators: is null is not null For example: dac_comment IS NULL dac_comment IS NOT NULL
    • Other considerations:
    • Use parenthesis (,) to remove ambiguity when using multiple conditions
    • Strings can only contain letters, numbers, @, ., _, # and are written in between quotes
    • Patterns are done with *i.e '*@example.com' or '*cause*'
    • Dates do not have quotes: 2020/01/01
Date Fullname Email Username Organisation Dataset Dataset Title Dac Comment
DENY GRANT
2023/11/24Demo User 1demo1@organisation.comdemo_user1

Demo Organisation

EGAD50000000116

Demo Dataset Title 116

2023/05/12: dac comment

2024/11/22Demo User 2demo2@organisation.comdemo_user2

Demo Organisation

EGAD50000000117

Demo Dataset Title 117

2023/11/20Demo User 3demo3@organisation.comdemo_user3

Demo Organisation

EGAD50000000107

Demo Dataset Title 107

2023/11/15Test Usertest@organisation.comtest_user

Demo Organisation

EGAD50000000207

Demo Dataset Title 207

2023/10/12Test User 2test2@organisation.comtest_user2

Demo Organisation

EGAD50010002513

Demo Dataset Title 2513

2023/05/12: dac comment

2023/10/09Test User 3test3@organisation.comtest_user3

Demo Organisation

EGAD50010002414

Demo Dataset Title 2414

2023/09/05Test User 3test3@organisation.comtest_user3

Demo Organisation

EGAD50010002306

Demo Dataset Title 2306

2023/09/01Test User 4test4@organisation.comtest_user4

Demo Organisation

EGAD50010002340

Demo Dataset Title 2340