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

[Carsten Zoll]

I'd like to expand an existing and working expression field. The working phrase is: rbv_api.selectValue("SELECT SUM(Umsatz) FROM Umsatz WHERE Jahr = #YEAR(CURDATE()) - 1 AND R331557946 = {!id}") The new Phrase is: rbv_api.selectValue("SELECT SUM(Umsatz) FROM Umsatz WHERE Jahr = #YEAR(CURDATE()) - 1 AND {!R331557946.Kundentyp} = 'W' AND R331557946 = {!id}") I get an error with the validate formular button. The field to calculate with this formula is in the object "Lieferant". Lieferant is related to the object Umsatz. Umsatz has as related field "Kundentyp". Kundentyp is a picklist.

Continue reading...