[progress Communities] [progress Openedge Abl] Forum Post: Re: Count Of Related Records

  • Thread starter Thread starter Shiva Duriseati
  • Start date Start date
Status
Not open for further replies.
S

Shiva Duriseati

Guest
Hi Paul, "createdAt" is stored as "Date/Time" field in MySql database in the format "2016-03-15 15:47:36". This format has to be matched with variable YEAR. You can also use rbv_api.selectValue API as follows: var count=rbv_api.selectValue("SELECT COUNT(1) FROM Cases WHERE createdAt LIKE '2016%' AND naam='india'"); rbv_api.println(count); Please let me know if you find any issue. Regards, Shiva

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