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.
Okay will update!
Also convert the lookup query to string using "toString" method and paste it here.
Thanks,
Girish S.
Please share your code so we can provide input.
No luck, I tried what you suggested. Thanks.
Okay i will try this and come back. Thank you so much for the active support.
Mohit is correct. I didn't see that one. You are passing product name which is wrong. You need to pass item group ID
Thanks
Girish S.
You are setting incorrect range on Item Group with value Audio products. (Audio products is the name as per your screenshot, not an item group)
Try the suggestion given in the below thread.
community.dynamics.com/.../filtering-out-for-multiple-values-in-query-range-using-addrange
Also try adding query output to infolog using toString method of the query class and see how the query was built in.
Thanks,
Girish S.
No luck i tried...After adding the error was gone but am unable to remove those two records from lookup. Thanks
You are missing fields that needs to be shown in the lookup.
systablelookuo.addLookupField(fieldnum(InventItemGroup, ItemGroupId));
Thanks,
Girish S.
André Arnaud de Cal...
292,160
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156