[progress Communities] [progress Openedge Abl] Forum Post: Re: Formula Sql With Related...

Status
Not open for further replies.
S

Shiva Duriseati

Guest
Hi Carsten, Please use multiple queries because you cannot compare related object field against current object using single select query ,only id's can be used to compare in WHERE clause. Could you please try below code? var relatedId=rbv_api.selectValue("SELECT id FROM Lieferant WHERE Kundentyp = 'W'"); var sum=rbv_api.selectValue("SELECT SUM(Umsatz) FROM Umsatz WHERE Jahr = #YEAR(CURDATE()) - 1 AND R331557946 = "+relatedId+""); rbv_api.println(sum); Regards, Shiva

Continue reading...
 
Status
Not open for further replies.

Similar threads

D
  • Locked
[Progress News] [Progress OpenEdge ABL] The Benefits of a Data Hub for Effective Data, Analytics and AI Governance
Replies
0
Views
269
David Kaaret
D
P
  • Locked
[Stackoverflow] [Progress OpenEdge ABL] How can I force an Oracle Heterogeneous query to send the where clause to the ODBC driver?
Replies
0
Views
565
Paul Stearns
P
S
  • Locked
[Progress News] [Progress OpenEdge ABL] Mortgage Approval with Progress Corticon
Replies
0
Views
450
Seth Meldon
S
P
  • Locked
[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Memory usage on web agent increases with decrease in performance
Replies
0
Views
930
Paul Koufalis
P
N
  • Locked
[Stackoverflow] [Progress OpenEdge ABL] Limiting SQL query to 10,000 results by where clause only, by string field
Replies
0
Views
1K
Nik Weiss
N
Top