How can i create materilized view on IFS Developer Studio or i shouldn’t?
Best answer by Himasha Abeywickrama 2 December 2019, 14:23
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.
Hi @Himasha Kapugeekiyanage ,
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.
A accidently choose the best answer and i couldnt remove it.
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
Hi - I’ve removed it for you. Just mark the best answer again when you’re ready.
I decided to use IAL objects.It works for my intention.
Thank you for your helpfull responses.
Ask the community for help!
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.