All queries




Query lastSystemVersion

SQL query HQL query
select systemvers0_.SYSTEM_VERSION_LB as col_0_0_ from Q2_TU.SYSTEM_VERSION systemvers0_ where systemvers0_.SYSTEM_VERSION_ID=( select max(systemvers1_.SYSTEM_VERSION_ID) from Q2_TU.SYSTEM_VERSION systemvers1_ ); SELECT systemVersionLb as schemaVersion FROM SystemVersionImpl WHERE systemVersionId = (select max(systemVersionId) from SystemVersionImpl)



Query countSurveyUsingCampaign

SQL query HQL query
select count(*) as col_0_0_ from Q2_TU.SURVEY surveyimpl0_ where surveyimpl0_.CAMPAIGN_ID=?; SELECT COUNT(*) FROM SurveyImpl WHERE campaign.campaignId = :campaignId
Parameters
Name Type Description
campaignId java.lang.Integer