Finance | Project Operations, Human Resources, ...

Activity lookup based on Project

(0) Share

Report

Posted on by Maverick

182

Hi Experts,

I have a custom form with two columns Project and Activity. My requirement is to add a look up on activity field based on project selected in the project field. I am achieving this by below code

  public void lookup(FormControl _formControl, str _filterStr)
    {
        //super(_formControl, _filterStr);

        HierarchyTreeTable::lookupHierarchyTree(_formControl, ProjTable::find(ANCPettyCashProjJournalLines.ProjId));

                
    }

However this code is displaying the entire activities including closed ones related to the project. What can I do to see only active activities in the lookup?

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report

Two options:

1. Create a new method in ProjTable similar to find method possibly name it findActiveActivities and return non-closed activities from this method. Refer this method in your lookup

HierarchyTreeTable::lookupHierarchyTree(_formControl, ProjTable::findActiveActivities(ANCPettyCashProjJournalLines.ProjId));

2. Create a lookup method at table level using query and return filtered records from that method, later use table lookup method on form control.

Was this reply helpful? Yes No
Maverick 182 on at

Like (0)

Report

Hi Faisal, Thanks for your prompt response, but my query is how do I add the query filter to the below code

HierarchyTreeTable::lookupHierarchyTree(_formControl, ProjTable::findActiveActivities(ANCPettyCashProjJournalLines.ProjId));

Was this reply helpful? Yes No
Suggested answer

Faisal Fareed 10,796 User Group Leader on at

Like (0)

Report

This uses the form lookup so you need to extend the HierarchyTreeLookup form through an extension class where you can extend the run method of HierarchyTreeLookup form. If you are not a developer then get one :) as you would need one.

public client static void lookupHierarchyTree(FormStringControl _ctrl, Common _common, NoYes _showChildOnly = NoYes::No)
{
Args args;
FormRun formRun;

HierarchyIdBase hierarchyId;

hierarchyId = HierarchyLinkTable::findRefTableRecId(_common.TableId, _common.RecId).HierarchyId;

args = new Args();
args.name(formStr(HierarchyTreeLookup));
args.caller(_ctrl);

args.record(_common);
args.parm(hierarchyId);
args.parmEnum(_showChildOnly);
args.parmEnumType(enumNum(NoYes));

formRun = classfactory.formRunClass(args);
formRun.init();
_ctrl.performFormLookup(formRun);
}

Was this reply helpful? Yes No

Join the conversation

Community site session details

Activity lookup based on Project

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

Activity lookup based on Project

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