quick question … can I filter datoms based on transaction data? I guess yes but is that via a standard query or do I have to write code?

in my use case, I have two transactions on the same data but would sometimes like to show the data back to the user based on the source system (tracked in the transaction)

@raymcdermott: the transaction entities are perfectly queryable from normal queries

ok cool - that’s what I hoped but I cannot see any examples

you just join against them via the part of the datom that is the transaction id

ah - ok so I wouldn’t need to use the history view? Or maybe I would combine that?

I see the example

[:db/add #db/id[:db.part/tx] :data/src "http://example.com/catalog-2_29_2012.xml"]

so (just to nail it) I can just add :data/src to the query?

you'd need to join against txid, but yeah

ah, ok and how would that work with pull?

@raymcdermott: I believe It depends if the data you’re interested in is in the current db or not.

(d/q '[:find ?src :where [_ :user/email _ ?tx] [?tx :data/src ?src]] …)

with pull - I wouldn't be too surprised if it didn't work with transaction entities, or if they did. If they do, you'd probably just use the txid as the entity id

(I'd have to try it at a repl, but I can't right now easily)

ok let me try and play over the weekend and I’ll come back here

thanks for the great guidance so far1

s/1/!/