• 0 Vote(s) - 0 Average
  • 5
  • 4
  • 3
  • 2
  • 1
Thread Modes

Adding EP_ORDER.ORDER_NUMBER to Service Request Filter
#1
We have a field that allows the PO to show up on a service request.  I'd like to be able to add a filter to only show Service Requests withe PO field filled is the Operations> Service Requests>Requests list.  Adding EP_ORDER.ORDER_NUMBER is not NULL doesn't seem to be the right answer.  What am i missing?
jvolltrauer, proud to be a member of EV CONNECT FORUM since Apr 2018.

#2
(10-23-2019, 10:33 AM)jvolltrauer Wrote: We have a field that allows the PO to show up on a service request.  I'd like to be able to add a filter to only show Service Requests withe PO field filled is the Operations> Service Requests>Requests list.  Adding EP_ORDER.ORDER_NUMBER is not NULL doesn't seem to be the right answer.  What am i missing?

Hello,
Sorry but ORDER_NUMBER are only on EP_ORDER and AM_ASSET tables, not in SD_REQUEST... (because one request could need 2 or more ORDER).
Please clarify "add a filter to only show Service Requests with PO field filled

P.ABBE
ABBE Philippe, proud to be a member of EV CONNECT FORUM since Nov 2015.






Users browsing this thread: 1 Guest(s)