43
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 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 .
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 ?
But my question is about how i can set condition by datasource field ..your answer is for condition by grid column .
thanks
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
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
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.
Share
Report
All responses (
Answers (
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156