掲示板
Service Builder
Hi
How can i go about this kind of query using service builder??
thanks and regards
Priyanka Dhingra
select
count(track.id_terminal)
, company.name as myResult
from track,detailsForTerminal, client,service,terminal, customer,customerGroup,Location,Item,company_plan,company
Where track.id_client = client.client_id
and
detailsForTerminal.id_terminal = track.id_terminal
and
detailsForTerminal.id_group = customerGroup.customerGroup_id
and
service.id_client = client.client_id
and
service.id_rm = terminal.terminal_id
and
track.id_customer = customer.customer_id
and
customerGroup.id_customer = customer.customer_id
and terminal.serial = Location.rm_serial
and
Location.id_Item = Item.Item_id
and
Item. id_plan = company_plan.companyplan_id
and company_plan.id_company = company.company_id
and customer.customer_id = 100
group by company.name
How can i go about this kind of query using service builder??
thanks and regards
Priyanka Dhingra
11年前 に Juan Gonzalez P によって更新されました。
RE: Service Builder
Liferay Legend 投稿: 3089 参加年月日: 08/10/28 最新の投稿
Did you try using custom sql? See link below:
http://www.liferay.com/community/wiki/-/wiki/Main/Custom+queries+in+Liferay
http://www.liferay.com/community/wiki/-/wiki/Main/Custom+queries+in+Liferay
11年前 に Priyanka Dhingra によって更新されました。
RE: Service Builder
Liferay Master 投稿: 501 参加年月日: 11/12/20 最新の投稿
thanks for the link...
but I have multiple tables in from clause ...so what should be the finder class and interface to refer???
Better if i could find a solution using some hibernate logic, since I have many queries like that...may be some workaround like inner join or something can help...but I do not have much knowledge on db
but I have multiple tables in from clause ...so what should be the finder class and interface to refer???
Better if i could find a solution using some hibernate logic, since I have many queries like that...may be some workaround like inner join or something can help...but I do not have much knowledge on db
11年前 に Priyanka Dhingra によって更新されました。
RE: Service Builder
Liferay Master 投稿: 501 参加年月日: 11/12/20 最新の投稿
Help!!
11年前 に Subhash Pavuskar によって更新されました。