How to search inside List for a specific value

Question

I'm trying to search value inside Corda unconsumed states on a collection Field.

Following is the string field I am using -

Field uniqueAttributeName = MySchema.PersistentIOU.class.getDeclaredField("fieldname");
        CriteriaExpression uniqueAttributeEXpression = Builder.equal(uniqueAttributeName, "valueToSearch");

        QueryCriteria customCriteria = new QueryCriteria.VaultCustomQueryCriteria(uniqueAttributeEXpression);
        result = rpcOps.vaultQueryByCriteria(customCriteria, MyState.class).getStates();

The above code worked fine when fieldname is String but I have another field which is List and I'm not sure how to search inside List for a specific value. Please help.

Answer 1

You can amend your ORM wrapper such that you have a parent - child relationship between the state and the list of fields you want to have in that list. Once this is done, the JDBC connection available to you to query against the child state and then use the relationship to the parent to get the Corda state.

Hope this helps :)