Finance | Project Operations, Human Resources, ...

How to remove few drop down records in ItemGroup

(0) Share

Report

Posted on by Hanisha

Hello Everyone,

While creating a new record in released products, we select itemgroup. From that drop down top two of the records need to be removed.

Sharing the screenshot for reference.

Thanks in advance.

I have the same question (0)

All responses (23)

Answers (0)

Suggested answer

GirishS 27,827 Moderator on at

Like (1)

Report

Hi Hanisha,

You can override the lookup event handler and write query to avoid the two values by using SysQuery::ValueNot("Audio").

But in UAT or Prod you need to confirm that same name exist otherwise it won't work.

Otherwise, you need to find for another workaround.

Thanks,

Girish S.

Was this reply helpful? Yes No
Martin Dráb 237,789 Most Valuable Professional on at

Like (1)

Report

You need to override the lookup and use a query that filters out the records.

Are you familiar with lookup and queries or do you have no idea at all?

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Hi, In addition to above comments, you can check the below article on how to override lookup of form field.

dynamics365musings.com/.../

Was this reply helpful? Yes No
Hanisha 5 on at

Like (0)

Report

Hello Girish,

I have used following code, but no luck.

[FormControlEventHandler(formControlStr(EcoResProductCreate, ItemGroupId), FormControlEventType::Lookup)]

public static void ItemGroupId_OnLookup(FormControl sender, FormControlEventArgs e)

{

SysQuery::valueNot("Audio");

SysQuery::valueNot("Audio Products");

}

Please suggest. Thanks

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

You need to build the query from the scratch. First you need to find out the tables related to item group and then build the query along with code you sent.

Also please refer to the mohits blog for how to build a lookup query.

Thanks,

Girish S.

Was this reply helpful? Yes No
Hanisha 5 on at

Like (0)

Report

Hello,

Its a unbounded control actually. I tried writing the below code but no luck.

class TutorialCustTable_Form_Handler

{

[FormControlEventHandler(formControlStr(EcoResProductCreate, ItemGroupId), FormControlEventType::Lookup)]

public static void ItemGroupId_OnLookup(FormControl sender, FormControlEventArgs e)

{

}

{

SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(inventItemGroup), sender);

SysQuery::valueNot("Audio");

SysQuery::valueNot("Audio Products");

// Run the lookup

sysTableLookup.performFormLookup();

FormControlCancelableSuperEventArgs cancelableSuperEventArgs = e as FormControlCancelableSuperEventArgs;

cancelableSuperEventArgs.CancelSuperCall();

}

}

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report
You still didn't understand about writing query. Please see fully the blog send by the mohit.

Your code looks something like below.

[FormControlEventHandler(formControlStr(EcoResProductCreate, ItemGroupId), FormControlEventType::Lookup)] public static void ItemGroupId_OnLookup(FormControl sender, FormControlEventArgs e) { Query query = new Query(); QueryBuildDataSource qbds; SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(inventItemGroup), sender); qbds = query.addDataSource(tablenum(InventItemGroup)); qbds.addRange(fieldnum(InventItemGroup, ItemGroupId)).value(queryvalue(SysQuery::valueNot("Audio"))); qbds.addRange(fieldnum(InventItemGroup, ItemGroupId)).value(queryvalue(SysQuery::valueNot("Audio Products"))); // Run the lookup sysTableLookup.performFormLookup(); FormControlCancelableSuperEventArgs cancelableSuperEventArgs = e as FormControlCancelableSuperEventArgs; cancelableSuperEventArgs.CancelSuperCall(); }

Thanks,

Girish S.

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report

You are not applying ranges correctly. You need to create queryBuildDataSource buffer and pass this value in addRange method.

Check this article

dynamicsaxinsight.com/.../

Was this reply helpful? Yes No
Hanisha 5 on at

Like (0)

Report

Thanks for helping but the problem is no DataSource for the form. If i add the base datasource of that records. am getting some parameter error .

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

What error you got?

Can you show us the error.

Thanks,

Girish S.

Was this reply helpful? Yes No