Skip to main content
Question

Custom Page/View not Found in Query


Forum|alt.badge.img+3
  • Do Gooder (Partner)
  • 6 replies

Hello,

 I created a Custom Entity, Custom Projection and a Custom Page using these. 

I can see the page, add/delete items from the Client.  

However, When I try to access the data from IFS Developer Studio using a simple query; 

SELECT * FROM IFSAPP.MY_CUST_VIEW_CLV

It says that the table or view doesn’t exist. I’m using IFSDBREADONLY as my user, and it  has 

Everything is published and synchronized. 

 

Any help is appreciated. 

Thank you,

/Kalindu

 

 

3 replies

Forum|alt.badge.img+19
  • Superhero (Employee)
  • 488 replies
  • February 29, 2024

The only user I’m aware of that gets things granted to it automatically is the IFSINFO user. That is the one I normally use for investigations / tests.


Dumeesha Wanigarathna
Superhero (Partner)
Forum|alt.badge.img+16

Hi,

Can you query normal view like ifsapp.Customer_order


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Partner)
  • 6 replies
  • February 29, 2024

Hi @Dumeesha Wanigarathna,

 Yes, I can query normal views. 
And I can also query default entities with custom fields by adding _CFV to the view name.
But when I create a whole new Entity, it doesn't show up. 

 

Is there any specific permission that I need to give? 


​​​​@Tomas Ruderfelt, I dont have access to any other user other than IFSDBREADONLY. 

 

Thank you!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings