Hi i need to get data from two tables, im using hibernate criteria. My scenario is,
Two tables AssetDetails and AssetManage
asset_details contains
asset_id, asset_name, asset_reference, status, condition, asset_type, vendor, manufacturer, asset_location
asset_manage contains
manage_id, asset_id, owner, checked_status, description
etc.,
now im working on tracking details of an asset from asset_details table using hibernate criteria. my code looks like,
Code:
session = HibernateSessionFactory.getSession();
Criteria criteria = session.createCriteria(AssetDetails.class);
criteria.add(Expression.in("assetId", action.getSearchAssetIds()));
criteria.add(Expression.in("assetTypes.typeId", action.getSearchAssetTypes()));
criteria.add(Expression.in("assetName", action.getSearchAssetNames()));
criteria.add(Expression.in("selectValueByStatus.selectValueId", action.getSearchAssetStatus()));
criteria.add(Expression.in("selectValueByCondition.selectValueId", action.getSearchAssetCondition()));
assetsList = criteria.list();
all these are fine as they are present in asset_details table, now i want some thing like,
Code:
SELECT * FROM asset_details asd, asset_manage asm where asd.asset_id=asm.asset_id and asm.checked_status='ACTIVE';
asset_manage table contains asset_details as foreign key, but vice-versa is not there. so its becoming problem for me.
Any help appreciated...
Login
FAQ
Search