Who's On?

	Membership:
	Latest: Steve G
	Past 24 Hours: 0
	Prev. 24 Hours: 3
	Overall: 5332

	People Online:
	Visitors: 298
	Members: 0
	Total: 298

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3293
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244

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

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

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

Woozy

Veteran Member

Posts: 709

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

Demi

Veteran Member

Posts: 67

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.....