Ok, got it now. Estatio gave me the right directions using the ViewModel
and MementoService.
Erik
Hi,
Does anyone use database views within Isis? Right now I'm facing the
following exception:
java.lang.IllegalArgumentException: identifier
'org.datanucleus.identity.SCOID_org.datanucleus.identity.SCOID@4d6ef29a'
contains an '@' symbol
at
org.apache.isis.core.commons.ensure.Ensure.ensureThatArg(Ensure.java:75)
at
org.apache.isis.core.metamodel.adapter.oid.RootOidDefault.<init>(RootOid
The view entity signature is
@PersistenceCapable(table = "CDR.simplecdrs", identityType =
IdentityType.NONDURABLE)
@Extension(vendorName="datanucleus", key="view-definition",
value="CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL
SECURITY DEFINER VIEW `CDR`.`simplecdrs` AS select `CDR`.`cdrs`.`id`
AS `id`,`CDR`.`cdrs`.`host` AS `host`,`CDR`.`cdrs`.`calldate` AS
`calldate`,`CDR`.`srcs`.`name` AS `src`,`CDR`.`dsts`.`name` AS
`dst`,`CDR`.`cdrs`.`duration` AS `duration`,`CDR`.`cdrs`.`billsec` AS
`billsec`,`CDR`.`cdrs`.`disposition` AS
`disposition`,`CDR`.`cdrs`.`costs` AS `costs`,`CDR`.`cdrs`.`vat` AS
`vat`,`srcchannel`.`name` AS `srcchannel`,`dstchannel`.`name` AS
`dstchannel`,`CDR`.`accountcodes`.`name` AS
`accountcode`,`CDR`.`cdrs`.`factuurregel_id` AS `factuurregel_id` from
(((((`CDR`.`cdrs` join `CDR`.`srcs` on((`CDR`.`cdrs`.`src_id` =
`CDR`.`srcs`.`id`))) join `CDR`.`dsts` on((`CDR`.`cdrs`.`dst_id` =
`CDR`.`dsts`.`id`))) join `CDR`.`channels` `srcchannel`
on((`CDR`.`cdrs`.`channel_id` = `srcchannel`.`id`))) join
`CDR`.`channels` `dstchannel` on((`CDR`.`cdrs`.`dstchannel_id` =
`dstchannel`.`id`))) join `CDR`.`accountcodes`
on((`CDR`.`cdrs`.`accountcode_id` = `CDR`.`accountcodes`.`id`)))")
public class SimpleCDR //extends PortalAbstractDomainObject
{
Thanks,
Erik
<mailto:[email protected]>
