Skip to main content

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?

 

 

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


@shalikakk So there is no way to filter the list via a ‘Populate’ script?

 

 


@drooij Yes. You cannot filter the list using popular scripts.


@shalikakk that's a pity.. thanks anyway


Reply