Skip to main content
Question

Custom Page/View not Found in Query

  • February 28, 2024
  • 3 replies
  • 118 views

Forum|alt.badge.img+3
  • Do Gooder (Partner)
  • 9 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+21
  • Superhero (Employee)
  • 500 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)
  • 9 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!