Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Filtering a grid based on a stringEdit value

Posted on by 304

Hi,

I have a gird has a datasource1, I have a lot of columns in that grid but only one column (assume it's C1) it's from another table.. but it works fine and the records are linked correctly

now I have a stringEdit filed outside the gird, I choose a value for this stringEdit and it's suppose to filter the gird down by this value because it's same as C1

0486.png

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: Filtering a grid based on a stringEdit value

    Hi CBNestor,

    Sorry,I didn't notice that you have released a new thread:

    community.dynamics.com/.../filter-jobregistration-grid-with-prodnumber-lookup-field-ax-2012-r3

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: Filtering a grid based on a stringEdit value

    Hi CBNestor,

    You need to set your control Auto Declaration = Yes,  Or you need to declare it.

  • CBNestor Profile Picture
    CBNestor 529 on at
    RE: Filtering a grid based on a stringEdit value

    Hi Sergei, (Sorry Wrong Thread. I asked again on the original)

    I almost Got it. I Named the my Lookup stringEdit as NC_ProdId

    when I call this object in the ExcecuteQuery() function is says the : Variable NC_ProdId has not been declared.

    what am I missing?

    pastedimage1585056801245v1.png

  • Suggested answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,089 on at
    RE: Filtering a grid based on a stringEdit value

    Hi KareemTaima,

    What kind of issues do you have?

    You can check also:

    www.tech.alirazazaidi.com/.../

    MS docs docs.microsoft.com/.../how-to-add-filter-controls-to-a-simple-list-form

  • KareemTaima Profile Picture
    KareemTaima 304 on at
    RE: Filtering a grid based on a stringEdit value

    Hi, Sergei

    for sorry I couldn't benefit from this example, any another way to help? or another example?

  • Suggested answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,089 on at
    RE: Filtering a grid based on a stringEdit value

    Hi KareemTaima,

    You can find many examples in standard how to implement this feature, for example in CustTrans there is "ShowOpen" checkbox (in string input you need to use modified method instead of clicked) and you can take a look at how it was done there.

    Please, note that field outside the grid should be not bounded to any field on data source.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans