Hi all,
I’m trying to filter the Part Usage List, but no luck so far.
There is no Where Script option (it’s a baseline screen) to use.
I’m now trying to filter via the Populate script. But function like ‘deleteRow’ isn’t supported in mobile.
Also no luck so far with creating a empty list and then add a line via ‘setRowOnListData’
Any suggestions?
+6
Hi drooij,
Part Usage List screen is coded screen.you can’t add where clause to this screen. you can create new list type screen to show part usage list.
The following query is used to display data on the part usage screen.(6.27 baseline)
select distinct part_usage.pu_id, part_usage.metrix_row_id, part_usage.part_id, part.part_id, part.internal_descriptn, part_usage.quantity, part_usage.work_dt, part_line_code1.description from part_usage left outer join part on part_usage.part_id = part.part_id left outer join part_line_code part_line_code1 on part_usage.part_line_code = part_line_code1.part_line_code where part_usage.task_id = 4265 limit 1000
Thank you,
Shalika
+6
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
