AnsweredAssumed Answered

SQL query

Question asked by tays01s on Aug 29, 2017
Latest reply on Aug 30, 2017 by user19752

I'm not familiar with SQL. If I wanted to have a second criteria (the one in bold), how should I write it?


ExecuteSQL( "SELECT SUM(\"in_water_pc\") FROM IO_cum Summary WHERE __ID < 'IO_all_for_pt::__ID' AND

\"_PatientUUID\" = ?";"";"";Patient::__uuID )

)- (100 * Get(RecordNumber))