Question

Custom Page/View not Found in Query

  • 28 February 2024
  • 3 replies
  • 44 views
K
Rank
Badge +2

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

T
Rank
Userlevel 7
Badge +19

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
Rank
Userlevel 7
Badge +16

Hi,

Can you query normal view like ifsapp.Customer_order

- Dumeesha -
K
Rank
Badge +2

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


Terms & ConditionsCookie settings