what am I doing wrong here?

[the1gofer]

File 1:
2022-11-01 - 10:50 am - [callerID:: (415)738-2935]

File 2:

list
where callerID = "(415)738-2935"

File 2 shows now results.

[AB1908]

In file1, try table callerID where file.path = this.file.path and show us the results.

[the1gofer]

it lists file 2, but not file 1

[AB1908]

Right, I meant to say that write that query in file 1 and observe the results.

[the1gofer]

[the1gofer]

so it has the ID i'm trying to query for on the source page.

[AB1908]

Ah so you have multiple callerIDs in the same file. That gets indexed as an array. Use contains(). Please look at the docs for examples.

[blacksmithgu]

Try LIST WHERE contains(callerId, "(415)738-2935").

[the1gofer]

that did it, thank you.