ORDA: How can I query field value against a field value?

Question

Background

I'm converting old 4D code from class queries to ORDA queries. One thing I can't figure out is how to query with a field vs a field, rather than a field vs a value.

Edit: I'm using 4D v17.4.

Example

Classic:

Query([Customers];[Customers]State="IN")

ORDA:

ds.Customers.query("State = 'IN'")

Goal

I want to be able to query a table for results where I'm comparing a field value vs another field value. I can do it in classic querying via the following:

Query([Customers];[Customers]State#[Customers]AdministrativeRegion)

What I Tried

ds.Customers.query("State # AdministrativeRegion") // DOESN'T WORK

Question

Is this possible?

You might also want to take a look at https://discuss.4d.com/ — kirkBrooks, Aug 06 '20 at 16:07

score 1 · Accepted Answer · answered Aug 02 '20 at 15:59

You didn't mention which version of 4D you are using. 4D is changing very rapidly these days and the difference between them can really matter, though in this case not as much.

Using placeholders in your query string is the first step.

Instead of ds.Customers.query("State # AdministrativeRegion")

do

ds.Customers.query("State # :1 ";"some value")

Each placeholder is referenced by the :n syntax starting at 1. This is a big benefit because 4D will manage converting the comparison value data type. This is also the key to referencing a value in an entity, object, formula, etc.

$entity_selection:=ds.Customers.query("State # :1";$entity.State)

where $entity is the one you want to compare to.

Awesome, I'll test this out here in a bit. – Kelderic Aug 05 '20 at 15:59 — Kelderic, Aug 05 '20 at 15:59

score 0 · Answer 2 · answered Aug 17 '22 at 13:13

0

I would rather use ds.Customers.query(":1";Formula(This.State#This.AdministrativeRegion))

answered Aug 17 '22 at 13:13

Yohanmaker

11
1

Formula doesn't work in v17, which was what I was on at the time. But for more recent versions, this would work as well, yes. – Kelderic Aug 17 '22 at 14:58