Composite index - ZigZag Merge

[Rajesh Gupta]

Hi, 

I have the following ofy class

class Job {

  @Id

   Long id;

  @Index

  String tenantId;

  @Index

  long partyOrgId;

  @Index

  long seqId

}

ofy.query.filter("tenantId", tenantId).filter("partyOrgId", partyOrgId).sort("-seqId").first().now();

The above query throws an composite needed index exception error

<datastore-index kind="Job" ancestor="false" source="manual">

        <property name="partyOrgId" direction="asc"/>

        <property name="tenantId" direction="asc"/>

        <property name="seqId" direction="desc"/>

</datastore-index>

I was thinking, that the query should work with the help of the zigzag merge join without the need for the composite index.

Regards,

Rajesh

www.VeersoftSolutions.com

www.GainERP.com

Accounting/Inventory/Orders/Sales/Purchase on Google Cloud Platform and Mobile

[Jordan (Cloud Platform Support)]

As Google Groups is meant for general product discussions, this type of technical question is best suited for Stack Overflow. 

As noted before on Stack Overflow, you need to make sure you have both ("partyOrgId", "seqId" direction="desc") and ("tenantId", "seqId" direction="desc") individual indexes already created for the zigzag merge join to work. 

You can read the Advanced Search documentation to find out more information about what is required for zigzag merge join. Objectify also has their own documentation explaining how zigzag works.