should dataviewjs and dataview return the same values if the inputs are the same?

[htmljenn]

I track projects using atomic pages for updates and collect the data into a master document using dataview. But I noticed that my dataview table had 23 entries, while my dataviewjs generated chart has 28 entries.

The code for each is as follows:
dataview table showing the relevant parts

dataview
table 
  ---redacted---
from #writing and #work 
where words and contains(projects, [[redacted]]) 
sort dateWrote asc

dataviewjs variable to get the data for the chart
const pages = dv.pages('#writing and #work').where(b=> 'contains(b.projects, [[redacted]])').where(b=>b.words).sort(b=>b.dateWrote, "asc");

As far as I can tell, the dataviewjs version collects any project note written on the same day as one that has the redacted project in it.

Is this a bug or have I written the dataviewjs query wrong or ???

Thanks!

Edited to add:

I have found a DV query that will generate the exact same results as the Dvjs query, by adjusting the where statement:
where words and projects <= "[[redacted]]"

Question

I believe what is happening in the DVJS query is it's appending the projects keyword with every value that is found on the corresponding pages. So if a second entity added on the same day has the [[redacted]] link in it, EVERY entity written on that day will fit that category.

[AB1908]

Can you try reversing the where order for dvjs?

[htmljenn]

Yes, I've tried that. It gets the same 28 entries.

const pages = dv.pages('#writing and #work').where(b=>b.words).where(b=> 'contains(b.projects, [[redacted]])').sort(b=>b.dateWrote, "asc");

unless you mean something else.

Thanks!

[AB1908]

I'm not sure the contains part is correct. It's being treated as a string since you've enclosed it in single quotes.

[htmljenn]

When I remove the single quotes, I get the error:
Evaluation Error: ReferenceError: contains is not defined
If I replace the single quotes with double quotes, I get the error:
Evaluation Error: SyntaxError: missing ) after argument list

with single quotes is the only way I've found that gives me a chart rather than an error message:
const pages = dv.pages('#writing and #work').where(b=>'contains(b.workDone,"writing")').where(b=> 'contains(b.projects, [[redacted]])').where(b=>b.words).sort(b=>b.dateWrote, "asc");

[AB1908]

Ah there's some documentation missing for this. You actually need to use .includes. See the data array page: https://blacksmithgu.github.io/obsidian-dataview/api/data-array/.

[blacksmithgu]

You can't directly use Dataview Query expressions in DataviewJS - you need to adjust it a bit. Specifically, instead of

.where(b => 'contains(b.projects, [[redacted]])`

Use DataviewJS / JS instead:

.where(b => dv.func.contains(b.projects, dv.fileLink("redacted")))

[AB1908]

Any meaningful difference between using dv.func.contains vs DataArray.includes?

[blacksmithgu]

You can probably use DataArray#includes as well.

[htmljenn]

Hi, sorry for the delay. Unfortunately, the `dv.func.contains` version resulted in 0 results. Zero false-positives.... ;-) but also zero true-positives. haha. If you think it would help, I can pull together a set of 3 sample data files, along with the two scripts (DV and DVJS) I'm using that generate the different results. The sample files are basically around 12 lines of meta data each.

…

-- Jennifer Kyrnin HTML Jenn http://www.htmljenn.com/ ***@***.*** ***@***.***

On Mar 22, 2022, 3:58 AM -0700, AB1908 ***@***.***>, wrote: Any meaningful difference between using dv.func.contains vs DataArray.includes? — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***>

[AB1908]

Please do share some sample files and YAML.

[htmljenn]

Three sample files

file one writing 2022-02-25 1350 - this file has a completely different project listed in the projects field. I am stumped as to why it shows up at all. It was created on Feb 2nd at 13:35

---
tags: [ writing, work, 2022-02-25 ]
dateWrote: 2022-02-25
startTime: 1:35 pm
endTime: 2:14 pm
hours: 0.75
words: 772
workDone: "editing"
projects: 
- "[[WT Earth Study|Earth Study]]"
---

file two writing 2022-02-26 1652 - this file also uses a completely different project in the projects field. It was created on Feb 26th at 16:59

---
tags: [ writing, work, 2022-02-26 ]
dateWrote: 2022-02-26
startTime: 4:59 pm
endTime: 5:38 pm
hours: 0.75
words: 2081
workDone: editing
projects:
- "[[WT Earth Study|Earth Study]]"
---

file three writing 2022-02-26 0856 - this file uses the project I'm searching for "[[space story]]" (called redacted in the above notes because I don't know why...).

---
tags: [ writing, work, 2022-02-26, writing/fastdrafting,  ]
dateWrote: 2022-02-26
startTime: 8:56 am
endTime: 9:31 am
hours: 0.5
words: 872
projects: [ "[[space story]]", ]
workDone: writing
---

The three formulas, one DV the other two DVJS with dataArray and dv.func

this DV gives me exactly what I'm hoping for. using the above files, that would be just the last one where I'm working on [[space story]] and the workDone is "writing"

dataview
list
from #writing AND #work 
where contains(workDone, "writing") AND contains(projects, [[space story]])
sort dateWrote asc

This dvjs gives me 5 extra results (or 2 extra using just the above three files)

dataviewjs
const pages = dv.pages('#writing and #work').where(b=>'contains(b.workDone,"writing")').where(b=> 'contains(b.projects, [[space story]])').where(b=>b.words).sort(b=>b.dateWrote, "asc");
dv.list(pages.file.link);

The one below gives me 0 results.

dataviewjs
const pages = dv.pages('#writing and #work').where(b=>'contains(b.workDone,"writing")').where(b => dv.func.contains(b.projects, dv.fileLink("space story"))).where(b=>b.words).sort(b=>b.dateWrote, "asc");
dv.list(pages.file.link);

Thanks for any insight you can provide.
writing 2022-02-25 1350.md
writing 2022-02-26 0856.md
writing 2022-02-26 0942.md

edited to attach the three sample files

[AB1908]

Hi, sorry for not following up sooner but is this still an issue?