Dear All;
I have Form A which has the following grid
and form B which is called by form A
i want to filter form B based on status column whenever Form A record "steptype" field have different status
my code was
if (element.args().caller() && element.args().dataset() == tableNum(ADVChecksMultiPost)) { if (element.args().refField(ADVChecksMultiPost.ADVCHKStepTypeNew) == ADVCHKStepType::UnderCollection) { this.query().dataSourceTable(tableNum(ADVChecks)).addRange(fieldNum(ADVChecks, ADVCHKStepType)).value(enum2str(ADVCHKStepType::Recieve)); } }
the third line doesn't seem to be working
Thanks for providing the solution to your own question. I have marked your answer as verified to get the status of this question changed to 'Answered'.
Thanks Andre I have changed the code to
if (element.args().parmEnum(2))
it works fine now
Hi Andre;
no i want records to be changed be changer wherever i open form b based on the selected row from form B.
and what i tried is to remove the step type condition in line 3 and then the filter is applied successfully.
Hi m.saleh297,
Can you explain what you mean with 'whenever'? Do you want to change the filter when you change a record on Form A and form B is still open? Have you also used the debugger to check what is actually being executed?
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,836
Most Valuable Professional
nmaenpaa
101,156