HQL

规则表内容查询

select t.name as "规则表名",v.bind1 as "仓库",d.creator as "创建人",d.reference1 as "查找参考项",d.value1 as "值参考项" from thorn_rule_table_detail d 
    inner join thorn_version v on v.id = d.version_id
    inner join thorn_rule_table t on t.id = v.rule_table_id
    where  t.name='R101_计费_功能对应费用表';

hql在mysql数据库中查询日期

	 and DATE_FORMAT(l.CREATED_TIME,'%Y-%m-%d')>='2017-01-01'

hql在Oracle数据库中查询日期

    select sum(f.fee) from account_detail_fee f 
    where f.company_id=200187 and f.fee_type='装货费' and f.be_adjustment='N' and f.status='ENABLED'
    and not exists(select 'X' from account_detail_fee fee where fee.source_unique_code=f.unique_code and fee.status='ALREADY_ADJUST')
    and f.bill_date< to_date('2016-10-01 00:00:00','yyyy-mm-dd hh24:mi:ss')
    and f.bill_date>=to_date('2016-09-01 00:00:00','yyyy-mm-dd hh24:mi:ss');

maintain界面–是否查看字段

(case when (select count(log.id) from TmsPositionLog log where log.leg.id=leg.id and to_char(log.positionTime,'yyyy-MM-dd')=to_char(current_date(),'yyyy-MM-dd'))!=0 then true else false end) as checkTag,

分割线

<separator id="s1" title="s1" row="7"/>

hql中的like查询

+ "AND po.trackingNumber like '%"+trackingNumberInput+"') "

查询语句

String legHql = "FROM TmsLeg leg WHERE leg.ecNo='"+code+"'";
legList = commonDao.findByQuery(legHql);