Questions tagged [orda]
4 questions
0
votes
2 answers
4D Database ORDA Query: Query Using Length of Related Records
Background
I'm using 4D Database (v17.5) and trying to query records. I have the following simplified schema:
Customers (table)
-CustomerID (field)
-CompanyName (field)
-City (field)
-State (field)
SalesOrders (table)
…
Kelderic
- 6,502
- 8
- 46
- 85
0
votes
2 answers
ORDA: How can I query field value against a field value?
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…
Kelderic
- 6,502
- 8
- 46
- 85
0
votes
1 answer
ORDA: How do I specify field order when using entitySelection.toCollection()?
Background
I'm converting old 4D Database code to use new ORDA concepts introduced in v17. However, I've noticed an oddity. When I have an entitySelection that I created using ds[$vtTableName].query(), and I convert that entitySelection to a…
Kelderic
- 6,502
- 8
- 46
- 85
0
votes
1 answer
How Can I Avoid Throwing Errors From Incorrect FieldNames in EntitySelection.toCollection($fieldNames)
I'm trying to convert code to ORDA. One thing that is giving me issues is Relations. Example setup:
Tables:
[CallLogs], [Employees]
Relation:
[CallLogs]EmployeeID (M)---->(O) [Employees]UniqueID
MtO Relation Name: "RelatedEmployee".
Using ORDA, I…
Kelderic
- 6,502
- 8
- 46
- 85