Introduction:
There can be a business requirement to fetch data from different tables from database and use it for further processing. For example - In Inventory console, we need to search and display data from extended attributes of yfs_item.
We can either write a custom logic to fetch the data from required tables and then do post processing to return the output in desired format. There is also a possibility to join required tables in a View. Latter one also requires customization but can be better performing.
Views can be created for out-of-the-tables and/or custom tables. Let's see how we can create custom views in IBM Sterling OMS.