%%
date:: [[2022-10-07]], [[2023-04-24]]
%%
# [[Crowdfunding Projects Backed]]
## Pending
### Count of Unfulfilled
```dataview
table length(rows) as Number from ""
where type = "kickstarter" and
Status!= "Fulfilled"
group by type
```
### Table of Pending Projects
```dataview
TABLE system as "System", DateExpected as "Expected", ShippingAddress as "Shipped to", Link from "databases/kickstarter"
where type="kickstarter"
and Status!="Fulfilled"
sort DateExpected asc
```
## By Status
```dataviewjs
for (let group of dv.pages('"databases/kickstarter"').where(p => p.type === "kickstarter").groupBy(c => c.status)) {
dv.header(3,group.key);
dv.table(["Status","DateExpected", "Shipping Address", "Links"],
group.rows
.where(p => p.type === "kickstarter")
.sort(p => p.DateExpected)
.map(p => [p.file.link,p.DateExpected,p.ShippingAddress,p.Link]))
}
```