Finance | Project Operations, Human Resources, ...

How to set condition on datasource level for fields

(0) Share

Report

Posted on by Wajahat wasti

Dear community i am looking for answer that how i can set condition on datasource level in AX2012 .
Senario is something like this
i have 5 record lines

Example: We have three fields ID , Name, City
i want to set condition like this

if(city == 'abc')
{
SHOW NAME AND CITY COLUMN IN GRID
}
ELSE
{
SHOW ONLY ID IN GRID
}

How i can set this condition by using datasource level fields ?

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Komi Siabi 13,089 Most Valuable Professional on at

Like (0)

Report
Hello,

1.

Firstly, you need to set the auto declaration property to Yes for all the fields on the grid : Id, Name, City.

2. You might want to Hide these 3 fields on init of the form by doing this.

public void init() { super(); if(MainGrid_City.valueStr() == "Abc") { MainGrid_id.visible(false); MainGrid_name.visible(true); MainGrid_City.visible(true); } else { MainGrid_id.visible(true); MainGrid_name.visible(false); MainGrid_City.visible(false); } }

MainGrid is the name of the Grid on your form.

Was this reply helpful? Yes No
Wajahat wasti 43 on at

Like (0)

Report

Thanks Komi

your answer resolve 50% my problem to set condition but another half is

showing data from datasource with in condition

i want to show values on behalf of condition

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,089 Most Valuable Professional on at

Like (0)

Report
Did you see the if statement in my code ?

if(MainGrid_City.valueStr() == "Abc") /// Here is the condition

You should also override the modifiedField method the City field and put the logic

Was this reply helpful? Yes No
Wajahat wasti 43 on at

Like (0)

Report

But my question is about how i can set condition by datasource field ..your answer is for condition by grid column .

thanks

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,089 Most Valuable Professional on at

Like (0)

Report

the field on the datasource would have to be used on the form design if I am not mistaken?

Maybe you should explain at what point exactly you want the condition.

Is it on immediately you open the form ?

When user select data on any of the field ?

Was this reply helpful? Yes No
Wajahat wasti 43 on at

Like (0)

Report

I am working for purchase order lines grid .When we will open PO data will fetch on grid .

Basically i want to reduce process time because display methods consume more time to access data from db .. This can be possible by using query and view then drop view as form source on form drop field from datasource to grid but having problem while implementing above condition .

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to set condition on datasource level for fields

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to set condition on datasource level for fields

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates