Inline-Query: Display number of files satisfying Contains-condition

[Gewerd-Strauss]

Hello,

Assume I have the following two normal dataview-queries:

``` dataview
list
FROM #Internship 
WHERE contains(progress,"sent (")

```

*Almost Ready* (aka they have been moved from `Potentials` to `Applications`):
```dataview
list
FROM #Internship 
WHERE contains(file.path,"Applications") AND !contains(progress,"sent (")
```

I am now trying to print the number of items above each respective list, but I cannot figure out how to structure the inline-query. I have no experiences in JS and feel pretty dumb trying this on my own.

Any help is appreciated.

Thank you,
Sincerely,
~Gw

[mnvwvnm]

I don't know how to work with includes() in JS if for a substring in an array (only works for all the value/string).
But you can use this solution (taking the function contains() from DQL:

`$=dv.pages("#Internship").where(p => dv.func.contains(p.progress, "sent (")).length`

[Gewerd-Strauss]

This works in principle for the first DV, but not the second one. I tried chaining two conditions, but I must be doing something wrong here. In the second dataview, I need to consider if a file's path contains a specific string as well, not just whether or not the string "sent (" is contained in the page's progress-field.

So In principle I would need something along the lines of

• $=dv.pages("#Internship").where(p => !dv.func.contains(p.progress, "sent (")).where(p => dv.func.contains(file.path,"Applications")).length
• $=dv.pages("#Internship").where(p => ( !dv.func.contains(p.progress,"sent(") && dv.func.contains(file.path,"Applications") )).length

Which evidently doesn't work, but (knowing shit nothing about DQL sadly) these two ideas would be how I'd attempt it. (Only that for both, I don't know how to reference the file, because file.path cannot be used apparently - or I'm just too inexperienced to do so). Also not sure if I need to use &&, & or AND for this, but that is the smallest problem.

[mnvwvnm]

For second case you need to use something like:

`$=dv.pages("#Internship").where(p => dv.func.contains(p.progress, "sent (") && !dv.func.contains(p.file.path, "Applications")).length`

Two things:

• you don't need extra parenthesis to join dv.func.contains(p.progress, "sent (") && !dv.func.contains(p.file.path, "Applications")
• in this case where is applied to the page level... because that we need to use p to access to the fields: in progress we write p.progress; in file.path we need to write p.file.path

[Gewerd-Strauss]

That worked wonderfully, thank you :)