Hi,
How can i create materilized view on IFS Developer Studio or i shouldn’t?
Thank you.
Answer
Materialized View On IFS
Best answer by Himasha Abeywickrama
Hi
You can include the materialized view in either core or Extension/Localization or Customization views file and the code generator will produce database deployable apv file which include the materialized view. For more information, you can refer the Code Generation section in Foundation1 documentation.
IFS Development Guide/Core Server/Base Server Development/Development Concepts/Code Generation
Himasha
+18Hi
A materialized view in Oracle is a database object that contains the results of a query. They are local copies of data located remotely, or are used to create summary tables based on aggregations of a table's data. You can create a materialized view in IFS Developer Studio by opening an empty PLSQL file by clicking on File → New File → Select PLSQL on the left side window → Select Empty PLSQL file on the right side window.
You can write the logic on the file and deploy directly to the database from there. I’ll attach a sample materialized view to get an idea.
Himasha
https://www.linkedin.com/in/himashaabeywickrama
Hi
First of all thank you for the answer.
But i wonder that is there a syntax to generate apv file for the materialized view in the file
with .views extension.
+18Hi
You can include the materialized view in either core or Extension/Localization or Customization views file and the code generator will produce database deployable apv file which include the materialized view. For more information, you can refer the Code Generation section in Foundation1 documentation.
IFS Development Guide/Core Server/Base Server Development/Development Concepts/Code Generation
Himasha
https://www.linkedin.com/in/himashaabeywickrama
+18Sorry,
A accidently choose the best answer and i couldnt remove it.
Hi - I’ve removed it for you. Just mark the best answer again when you’re ready.
Hi
I decided to use IAL objects.It works for my intention.
Thank you for your helpfull responses.
ridvan.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.