Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escaping: Escape characters +-&|!(){}[]^"~*?:\ with \, e.g. \+
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
Answered
Hi All, I Have A Big Amount Of Experiment In A Single Project, There Is A Way To Download The Experiments As A Custom Table? To Let'S Say To A .Csv File? Thanks! Experiment Table Example:

Hi all,
I have a big amount of experiment in a single project,
there is a way to download the experiments as a custom table? to let's say to a .csv file?
Thanks!

experiment table example:
image

  
  
Posted one year ago
Votes Newest

Answers 6


Hi @<1547028131527790592:profile|PleasantOtter67> , nothing out of the box. You can however quite easily extract all that information and inject it into a csv programmatically.

I think the bigger question is how would you break it down? Each experiment has several nested properties.

  
  
Posted one year ago

Hi @<1523701070390366208:profile|CostlyOstrich36> ,
I need it the most "dry" way (only basic columns of strings, ints and floats), no fancy tags are required.

  
  
Posted one year ago

Cool! Thanks I will check it out!

  
  
Posted one year ago

OK, I ended up extracting it from the browser source code with good old copy-paste.
However, I'm definitely need to use the API next time!
Thanks!!!

  
  
Posted one year ago

Or you're thinking only of the current view as it is?

  
  
Posted one year ago

I think the call tasks.get_all should have you covered to extract all information you would need.
None
The request body should look something like this:

{
  "id": [],
  "scroll_id": "b77a32d585604b098f685b00f30ba2c2",
  "refresh_scroll": true,
  "size": 15,
  "order_by": [
    "-last_update"
  ],
  "type": [
    "__$not",
    "annotation_manual",
    "__$not",
    "annotation",
    "__$not",
    "dataset_import"
  ],
  "user": [],
  "system_tags": [
    "__$and",
    "__$not",
    "archived"
  ],
  "include_subprojects": true,
  "search_hidden": true,
  "only_fields": [
    "name",
    "status",
    "system_tags",
    "project",
    "company",
    "last_change",
    "started",
    "last_iteration",
    "tags",
    "user.name",
    "runtime.progress",
    "type",
    "project.name",
    "last_update",
    "parent.name",
    "parent.project.id",
    "parent.project.name"
  ]
}

Tip: Anything that you want to extract from the UI, you can use the API. To find the relevant call you can always open developer tools (F12) and see what returns

  
  
Posted one year ago