• syntax
  • Entities and Fields
  • Comparison Operators
• relative time operators
• find in files by name/pattern
• find items (folder) some times ago by aql

[!TIP|label:references:]

• jfrog/artifactory-scripts

syntax

Entities and Fields

Comparison Operators

relative time operators

[!NOTE|label:references:]

• aqlCleanup.groovy
• Advanced Cleanup Using Artifactory Query Language (AQL)

AQL supports specifying time intervals for queries using relative time. In other words, the time interval for the query will always be relative to the time that the query is run, so you don't have to change or formulate the time period, in some other way, each time the query is run. For example, you may want to run a query over the last day, or for the time period up to two weeks ago.

Relative time is specified using the following two operators:

Time periods are specified with a number and one of the following suffixes:

find in files by name/pattern

• running via curl -d

  $ curl -s -u ${account}:${password} \
         -X POST "${RT_URL}/artifactory/api/search/aql" \
         -H 'content-type: text/plain' \
         -d 'items.find ({
              "path" : { "\$ne" : "." },
              "\$or" : [{
                "\$and" : [{
                  "repo" : "${repo}",
                  "path" : { "\$match": "${path}" } ,
                  "name" : { "\$match": "${name}" }
                }]
              },
              { "\$and" : [{
                    "repo" : "${repo}",
                    "path" : { "\$match" : "${path}/*" } ,
                    "name" : { "\$match" : "${name}"}
                }]
              }]
            }).include( "name", "repo", "path", "actual_md5", "actual_sha1", "size", "type", "property" )
         '
  

• running via curl -T

  $ cat find.aql
  tems.find ({
    "path" : { "$ne" : "." },
    "repo" : "rt-repo",
    "$or" : [{
      "$and" : [{
        "path" : { "$match": "path/to/folder" } ,
        "name" : { "$match": "name.zip" }
      }]
    },
    { "$and" : [{
          "path" : { "$match" : "path/to/folder/*" } ,
          "name" : { "$match" : "name.zip"}
      }]
    }]
  }).include( "name", "repo", "path", "actual_md5", "actual_sha1", "size", "type", "property" )
  
  $ curl -s -u "${account}":"${password}" \
            -XPOST \
            "${RT_URL}/artifactory/api/search/aql" \
            -T find.aql
  

• in same repo

  $ cat find.aql
  tems.find ({
    "path" : { "$ne" : "." },
    "repo" : "rt-repo",
    "$or" : [{
      "$and" : [{
        "path" : { "$match": "path/to/folder" } ,
        "name" : { "$match": "name.zip" }
      }]
    },
    { "$and" : [{
          "path" : { "$match" : "path/to/folder/*" } ,
          "name" : { "$match" : "name.zip"}
      }]
    }]
  }).include( "name", "repo", "path", "actual_md5", "actual_sha1", "size", "type", "property" )
  

• in different repo

  $ cat find.aql
  tems.find ({
    "path" : { "$ne" : "." },
    "$or" : [{
      "$and" : [{
        "repo" : "rt-repo-1",
        "path" : { "$match": "path/to/folder/*" } ,
        "name" : { "$match": "name.txt" }
      }]
    },
    { "$and" : [{
          "repo" : "rt-repo-2",
          "path" : { "$match" : "path/to/folder/*" } ,
          "name" : { "$match" : "name.txt"}
      }]
    }]
  }).include( "name", "repo", "path", "actual_md5", "actual_sha1", "size", "type", "property" )
  

find items (folder) some times ago by aql

• find root folder && 4 weeks ago (by using -T, --upload-file)

  [!NOTE] imarslo: write a file without indent space

  $ cat find.aql
  items.find ({
    "repo": "my-repo",
    "type" : "folder" ,
    "depth" : "1",
    "created" : {
      "$before" : "4w"
    }
  })
  
  $ curl [-s] \
         -X POST \
         -uadmin:password https://artifactory.sample.com/artifactory/api/search/aql \
         -T find.aql
  

• search by using -d, --data

  $ curl -s \
         --netrc-file ~/.marslo/.netrc \
         -X POST https://artifactory.sample.com/artifactory/api/search/aql \
         -H "Content-Type: text/plain" \
         -d """items.find ({ \"repo\": \"my-repo\", \"type\" : \"folder\" , \"depth\" : \"1\", \"created\" : { \"\$before\" : \"4mo\" } }) """
  
  $ cat ~/.marslo/.netrc
  machine artifactory.sample.com
  login admin
  password password
  

• or

  $ curl -s \
       --netrc-file ~/.marslo/.netrc \
       -X POST https://artifactory.sample.com/artifactory/api/search/aql \
       -H "Content-Type: text/plain" \
       -d """items.find ({ \
               \"repo\": \"my-repo\", \
               \"type\" : \"folder\" , \
               \"depth\" : \"1\", \
               \"created\" : { \"\$before\" : \"4mo\" } \
            })
          """ \
       | jq --raw-output .results[].name?
  

• or (with sort and limit)

  Artifactory query language (AQL). How to write a not match query with $nmatch

  $ curl -X POST \
       -k \
       -H 'Content-Type:text/plain' \
       -i \
       'https://artifactory.sample.com/artifactory/api/search/aql' \
       -d 'items.find ({
                        "repo": "proj-1-local",
                        "type" : "folder" ,
                        "depth" : "1",
                        "created" : { "$before" : "3days" }
                      }).sort({"$desc":["created"]}).limit(1)
          '
  

• or -d @<filename>

  JFrog Artifactory REST API in 5min

  $ cat builds.json
  builds.find({
  "name" : "ci - build - name",
  "created" : {
    "$before" : "10d"
  }
  })
  
  $ curl -s \
       -g \
       -d @builds.json \
       -H "Content-Type: text/plain" \
       -X POST "https://${rtURL}/api/search/aql"