Adding Views to left list

[Michael Tsai]

In the object function, the system does not allow us to add views in the environment tab, which bar us from using fields from a view on the left list. I understand that we can use field expression to call a function on the selection tab to add a customized column to the left list. However, the result would be blank if we try to filter by it. Is there a way through process code to include views when the system is loading up the left list so we can use it as part of the filter criteria?

Mike

[Rui Martins de Almeida]

I don't think so...

[Regard Hulsbos]

Good day,

While not tested, you can recreate the link of W* generated code for the left list, but adding code in the BOITE label, similar to that is done for the PAY object in process code SUBPAY3. 

• Requirements would be, ensure that the view is added onto the object and assign it a table abbreviation 
• Reference the view fields in the selection grid of the object, within the expression section
• Review the WG* (*is the object abbreviation you are modifying) to determine the Link table created
• Added code in the BOITE label of the object to update the Link table expression to include the join your view.