Who's On?

	Membership:
	Latest: Isabella Harris
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5218

	People Online:
	Visitors: 108
	Members: 0
	Total: 108

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

Filtering on related table

4 Replies

0 Subscribed to this topic

17 Subscribed to this forum

Sort:

Author

Messages

kwisser

Basic Member

Posts: 12

3/15/2011 11:42 AM

Is it possible to filter a DME web browser query on a related table? For example, I want to find all PO lines that have a null PO-USR-FLD-5.

https://myhr.sjhsyr.org/s...!=%00&out=csv&DELIM=|&MAX=99999

When I run the above query, it never ends. I've even let it run overnight and it doesn't finish. I don't think it has anything to do with the size of the result set because I've also tried adding a condition to the &select to pull a hardcoded PO-Number. From all my testing it seems to be directly related to the fact that my &select is referencing a related table.

Thanks

Shane Jones

Veteran Member

Posts: 460

3/15/2011 7:26 PM

"Selects" on a related table has been discussed here before (it think).... I remember having issues with this in a process flow once and had to do something else to make the DME work. (I think it is sometimes a hit or miss issue.)

You might want to rethink the DME to see if you can write it in another way - Maybe: PURCHORDER as the base table related to the POLINE???

kwisser

Basic Member

Posts: 12

3/15/2011 7:42 PM

That was the original idea, but if I use PURCHORDER as the base table, then it doesn't give me all the lines. It only gives me line #1. That's why I switched to POLINE as the base table so that I could get all the line numbers.

Shane Jones

Veteran Member

Posts: 460

3/16/2011 1:18 AM

In Process Flow I could help because we could just write an SQL query node... Not sure how to help with a custom page ...

kwisser

Basic Member

Posts: 12

9/28/2011 7:49 PM

I was wondering if queries like in the original post would also work on Lawson 8?