You are talking about view forms : Please check documentation and create view form in developer studio.
Yes Ganesh, the approach would be to use the view form, apart form that do we have any other option?
Also, I am trying to access the data from the View created for the external DB table. The View for that table also resides on the external DB itself. So is it possible to access the data via view form using the DB link for a View created on the external table.
first create db view in remedy database which will point to external database table and access that DB view while creating the view form. [You may need to create DB link to access remote database table from the remedy database. once It is done, Create DB view using that DBLink].
But the team here which works on external database has provided a table view and not the exact table. So Remedy has to fetch data from that external DB view using the DB link. I didnt get your recent response.
Ok. Lets make it simple.
Are you able to view data of external table FROM your remedy database?
If yes, It means there is a already DB link created and you just need to create DB view using that DB link.
If no, You need to first create DB link so that you can access external data FROM remedy database.
Lets break it
But the team here which works on external database has provided a table view and not the exact table.---> So you have a view on external Table lets say V_ET .
Is this View V_ET accessible from Remedy DB?
Connect to SQL prompt and fire- Select * from V_ET --if results are coming then View V_ET is created with external DB using DB link.