2
1
0

Hi,

Is there a way to search by keyword within data extracts when using TxnQuery, similar to what is allowed with several of the SubmissionDao get methods?  My use case is to find saved submissions that have a specific date of birth, which is in the data extracts.

Thanks

    CommentAdd your comment...

    1 answer

    1.  
      2
      1
      0

      Hi Jamie,

      Currently the TxnQuery class does not support this type of search. 

      Thinking about how we could implement this and the API design, are you just searching for one particular data extract value. e.g

      new TxnQuery()
      .setFormStatus(Txn.FORM_SAVED)
      .setDataExtract("Date of Birth", "1970-01-01")
      .listValues()

      regards Malcolm

      1. Jamie Kunkel

        Hi Malcolm,

        Yes, that is how I would like to use it.  My current solution is using the WorkspaceDao class and it's search criteria with a non-fluent service.

        With that it's just keyword search within extracts, so no opportunity to indicate that search is for 'Date of Birth" but rather just all data extracts - but it works.  The granularity that you are proposing above would be an improvement.

        You could also consider a version of setDataExtract() that takes a Map<String,String> so that more than one extract name/value pair could be submitted.

        Thanks,

        Jamie

        Sorry for the late reply - I didn't have alerts set on these replies!

      CommentAdd your comment...