jobs
2 rows where name = "spellcheck" sorted by id descending
This data as json, CSV (advanced)
id ▲ | workflow | name | repo | runs-on | strategy | needs | if |
---|---|---|---|---|---|---|---|
27506 | Check spelling in documentation 20713 | spellcheck | sqlite-utils 140912432 | ubuntu-latest | |||
27496 | Check spelling in documentation 20704 | spellcheck | datasette 107914493 | ubuntu-latest |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [jobs] ( [id] INTEGER PRIMARY KEY, [workflow] INTEGER REFERENCES [workflows]([id]), [name] TEXT, [repo] INTEGER REFERENCES [repos]([id]), [runs-on] TEXT, [strategy] TEXT , [needs] TEXT, [if] TEXT); CREATE INDEX [idx_jobs_repo] ON [jobs] ([repo]); CREATE INDEX [idx_jobs_workflow] ON [jobs] ([workflow]);