How to Filter Multiple Grid Columns using a single String Edit Field

(0) Share

Report

Posted on by Community Member

Hi All ,

Please let me know how to filter multiple grid columns using a single string edit control .

For EX :

If My grid is having Four Columns lets say ( Employee_Name,Employee_Salary,Employee_Status) and one String Edit Control.

And When I enter data lets say Employee_Name into the StringEdit Field the entire grid should get filtered respectively.

is it possible ?.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Community Member on at

Like (0)

Report

RE: How to Filter Multiple Grid Columns using a single String Edit Field

And I want to hide the Fields contents not the field itself.

For EX :

if my table field lets say an enum field named (AStatus) is having two values YES,NO . Now I want to hide just YES based on some condition . How could i do this by means of code

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to Filter Multiple Grid Columns using a single String Edit Field

I am very new to ax . Could please give me some sample . I am really very confused.

Please do the needful

Was this reply helpful? Yes No
Suggested answer

reachnaidu 890 on at

Like (0)

Report

RE: How to Filter Multiple Grid Columns using a single String Edit Field

You can hide the fields of the table on Form_Init() or DataSource active method based on your conditions .. You have to set the Tab visible for the entire tab or field visible property based on your checks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to Filter Multiple Grid Columns using a single String Edit Field

Hi Can you Please let me know like how to hide fields of a table dynamically.

I want to do this in a table.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to Filter Multiple Grid Columns using a single String Edit Field

Hi Can you please let me know.

How to hide table fields values dynamically ?

Was this reply helpful? Yes No
Verified answer

Dick Wenning 8,705 Moderator on at

Like (0)

Report

RE: How to Filter Multiple Grid Columns using a single String Edit Field

community.dynamics.com/.../197081

but just add more filters with your typed value

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to Filter Multiple Grid Columns using a single String Edit Field

Why do you not just use the standard grid filter and enter the value in the appropriate filter field?

As long as you don't know which of the fields should be filtered after entering the value it's not easy to do this since you can't just filter all 4 of them. You would have to create another field (or a entire new tmp table) that contains the values of all the other fields combined in one string and then you can apply your filter on this new field with a like clause.

Was this reply helpful? Yes No