Service Layer - ServiceContracts/ServiceContract_Line

[edy_simon]

Hi,
Many similar question but I could not find a satisfying solution for this.

I need to get Service Contract ID filter by CustomerCode, Current Date, and ServiceContract_Lines/ItemCode and Serial Numbers or ItemGroup.
Basically what i need is to filter by the line.

This is what I have tried:

1. ServiceContracts entity - Not able to filter by line
2. Cross Join - There is no ContractId field in ServiceContract_Lines exposed.

I know the new SQLQuery maybe able to get this.
But this should a be easier if the ServiceContract_Lines exposes the ContractId field.
Creating a SQL query just for this purpose seems to be overkill, as new object needs to be created, table OCTR and CTR1 white listed, and grant users additional authorization for just this query.

Anyone have a better way to do this?

Regards
Edy

[PierreBrothier]

Hi Eddy,

i've been facing the same kind of problem. Since there's no navigation property defined, you can't use in cross join.

So basically, you can't make filter based on child collection.

as a workaround, I use the semantic layer to expose analytical view. But yes, it is more work to do.

[edy_simon]

Hi Pierre.
Thanks for sharing your workaround.
I cannot use semantic layer as i am targeting to support both HANA and MSSQL solution.
Just wish that there is an easier solution for this.

Regards
Edy