Prev
Next
Forums Integration / Customization IPA/ProcessFlow

IPD LMK Transaction Queries using multi criteria

 3 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Demi
Veteran Member
Posts: 67
Veteran Member
6/12/2014 5:16 PM
    I am new to IPA (10.0.6), but familiar with PFI.  I'm trying to create a landmark transaction query against the PfiWorkunit table that is using the ByFlowDefinition set. I want to select all the records for two (or three) different flows. Can anyone please tell me how to accomplish this?  I've tried using ors, ands and double-pipes and double-ampthesands; with and without quotes and backward slashes; both in the key field selection and also with using the filterString attribute with multiple status codes. If there is documentation available on how to do this, or even an example - I'ld appreciate knowing where to find it, I feel like I've just been through Washington, D.C.'s Library of Congress and came out the side door without a book.
    Woozy
    Veteran Member
    Posts: 709
    Veteran Member
    6/12/2014 9:31 PM
      Hi Demichener,

      This is really ugly. You can't do multiple values in the direct key mapping, so you have to use the filter field. I've submitted an enhancement request to improve the filter options by offering a wizard or something. It sounds like you've already started down the trial-by-fire route, and that's what it takes. It's been a while since I've done it, but it seems to me that you have to wrap the whole filter string in quotes, and then back-slash things like quotes and use "and" and "or" rather than "||" and "&&".

      I think you'd do something like this in the filter field (including the wrapping quotes): "PfiFlowDefinition=\"Flow1\" or PfiFlowDefinition=\"Flow2\"". If I remember correctly, once you click "OK" then some of the quotes will disappear and it will work, but I can't remember for sure. Just keep trying different flavors until it works.

      All of my experience has been with the IPA v9, so hopefully the v10 is different - I just haven't messed with this yet in there.

      Good Luck!

      Kelly
      Kelly Meade
      J. R. Simplot Company
      Boise, ID
      Woozy
      Veteran Member
      Posts: 709
      Veteran Member
      6/12/2014 9:32 PM
        Of course, the other (much simpler) option is to do a SQL query instead - but you have to have an account with rights to that table.

        Kelly
        Kelly Meade
        J. R. Simplot Company
        Boise, ID
        Demi
        Veteran Member
        Posts: 67
        Veteran Member
        6/17/2014 2:39 PM
          Thanks Woozy, your format worked perfectly in the builder. And you were partly correct when said 'once you click "OK" then some of the quotes will disappear and it will work'. In our case the backward slashes disappeared and all the quotes stayed. When I ran it in the designer with the wrapping quotes - it gave me an error (Remote call failed: Unable to create grid execution container); but if I removed the wrapping quotes, it ran fine. I've followed your lead and also submitted an enhancement request to improve the filter options (and the documentation). I thought about using the SQL query, but I'm writing a flow that will delete the closed and cancelled WU's. I discovered that if I use the Delete option against the PfiWorkunit, the table hierarchy comes into play and the related tables appear to be automatically updated. Next Phase, cleaning up the associated 'ClassicWorkunit' that is stuck in a status of 25 - Triggered in LPS. Going to need another connection in the configurations.....