StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
Business Objects and Data Access (How do I?)
»
Filter BO2 "where BO2 pk not in (Select fkBO2 from BO1)"
Filter BO2 "where BO2 pk not in (Select fkBO2 from BO1)"
Post Reply
Like
0
Filter BO2 "where BO2 pk not in (Select fkBO2 from BO1)"
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Charles R Hankey
Charles R Hankey
posted 15 Years Ago
ANSWER
Topic Details
Share Topic
Group: Forum Members
Posts: 524,
Visits: 30K
I have a BO1 typed to a table which has an FK that is the PK of BO2 ( no relationship setup between the BOs )
I want to filter BO2 to exclude records where the pk is found in the FKs of BO1
Guidance as to SF best practice for this appreciated
Reply
Like
0
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
Filter BO2 "where BO2 pk not in (Select fkBO2 from BO1)"
Charles R Hankey
-
15 Years Ago
So really you just want to create a filter, correct? So the most...
Trent L. Taylor
-
15 Years Ago
A little more complex than that (perhaps)
I want to create...
Charles R Hankey
-
15 Years Ago
I reread your post, Trent, and thought I might be missing something...
Charles R Hankey
-
15 Years Ago
just to keep from confusing lurkers - to get the keystring the line...
Charles R Hankey
-
15 Years Ago
Well, you could go about this several ways. You could take the Custom...
Trent L. Taylor
-
15 Years Ago
I know the techniques you are talking about and they work very well....
Charles R Hankey
-
15 Years Ago
Post Reply
Like
0
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search