Replicating DQL "contains" in dataviewJS, where queried metadata contains [[links]]

[flatlines]

Hello,

I would like to use dataviewJS to track:

1. how many of a particular storage box I have
2. how many there are left unused

Background

Below an example of a storage box note (name and YAML) as well as a set of object notes that use it.

Storage box

filename: box-1

---
fits:
  boxes_available: 4
---

Where boxes_available describes the total number of boxes I have purchased.

object being stored

Let's say I have two of these objects (notes), with the following metadata:

filename: shoes

---
tags: stuff
stored_in: "[[box-1]]"
---

filename: clothes

---
tags: stuff
stored_in: 
---

If I run the following DQL query,

list from #stuff"
where contains(stored_in,[[box-1]])

It (correctly) returns the list:

• shoes

Because "clothes" is empty.

However, if I now try to write the following in box-1:

Spaces available: =boxes_available = 4, Remaining: boxes_available - boxes in use = 3

I run into issues with the "Remaining" code.

Things I have tried

Basic dataviewJS variant:
$= dv.current().this_boxes_available - dv.pages('#stuff').where(p => p.stored_in == "box-1").length

This returns 4 (from current() = 4 and dv.pages = null).

Using includes see example here by scholarintraining. Code runs but returns null.

tryQuery variant adapted from holroy's response to nmag.

dv.pages(await dv.tryQuery(`
LIST
FROM #stuff
WHERE contains(stored_in,[[box-1]])
`)).length

Which should return 1 but instead fails with Evaluation Error: Error: Failed to parse query in 'pagePaths'.

I have also tried (credit to holroy):

$=dv.pages('#stuff').where(p => {return dv.func.contains(p.stored_in, "box-1")}).length

Which returns 0.

Question

I feel (perhaps erroneously) that tryQuery offers the best path forward. However, I am not sure why it's failing.

I am new to JS. Is there a simple formatting issue that I am missing?

[flatlines]

Got this working based on @blacksmithgu's response to this thread in 2022. It turns out I had made a few errors:

• dv.func does not need to be wrapped inside a {return} for this purpose
• there is a separate call, dv.fileLink that checks for file names in metadata

With these changes, the following query returns 1:

$=dv.pages('#stuff').where(p => dv.func.contains(p.stored_in, dv.fileLink("box-1"))).length

And the final query:

$=dv.current().this_boxes_available - dv.pages('#stuff').where(p => dv.func.contains(p.stored_in, dv.fileLink("box-1"))).length

Correctly returns 3.

[pubdigital]

Hi @flatlines , i follow this thread and don't understood why you use this_boxes_available. I found the correct query will be

$=dv.current().boxes_available - dv.pages('#stuff').where(p => dv.func.contains(p.stored_in, dv.fileLink("box-1"))).length

I think there is not need for the this_ and add to the string produce an error. I am wrong?

Thanks, in advance.