• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 651
  • Last Modified:

Filter with dataEnvironment

Is it possible to apply a filter on a child recordset using the dataEnvironment?

You can do dataEnv1.rscmdCommand1.Filter = ...

But can you do something like:


1 Solution
I'd like to say no.  The reason for having a child record is to filter the child set down according to the current record of the parent.  I see where you are going with this but the only way I have been able to do this is to apply the filter in code.  
Éric MoreauSenior .Net ConsultantCommented:
You can but you cannot filter all the children in one shot:

set rstChild = dataEnv1.rscmdCommand1.Fields("CommandChild2")
rstChild.Filter ...
jeanfrancoismelancon, coukd you get rid of this question? Like give the points to someone?

Hi jeanfrancoismelancon,
It appears that you have forgotten to close this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept emoreau's comment(s) as an answer.

jeanfrancoismelancon, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept THIS comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
DanRollins -- EE database cleanup volunteer
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now