350
Hi Everybody
Please, is it possible to make the condition "<>" using Views ?
My need : Make a Form to list Transfer Orders having QtyReceived <> QtyShipped.
I don't want to use SQL or X++.
Thanks.
*This post is locked for comments
Thanks a lot Martin, your first link works like a charm ;)
Even i was obliged to use X++ for filtering the new computed column to fill my grid on with wanted data like that :
Share
Report
All responses (
Answers (
public void init()
{
super();
this.query().dataSourceTable(tableNum(MYVIEW)).addRange(fieldNum(MYVIEW,Ecart)).value('!0');
this.query().dataSourceTable(tableNum(MYVIEW)).findRange(fieldNum(MYVIEW,Ecart)).status(RangeStatus::Locked);
}
Here is documentation: Walkthrough: Add a Computed Column to a View.
I also explained it a bit in my blog post Subqueries in views.
If you want to use a view, you can create a computed column which will compare QtyReceived and QtyShipped and return 1 or 0. Then you can easily filter by this column.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156