Question

quick reports shows error

  • 16 November 2022
  • 2 replies
  • 56 views
A
Rank
Userlevel 3
Badge +11

I connected to the sandbox environment db & got to know few tables/queries that fetch me data for service requests/customer info etc. I assume table names will be same in all environments. In another environment, where I have test data, I am trying to fetch quick reports from those tables. It seems like it finds the table & column names but does not bring the data & shows error. Can anyone guide? BTW, I have permissions to run reports as I am able to create & view some other reports. SS below

The query I used to fetch service requests data is below

One working report snapshot

 

2 replies

Charana Udugama
Rank
Userlevel 7
Badge +11

Hi @anushakh, 

There is no table in the core named ‘SRV_REQUEST_TAB’. Assuming you need to retrieve the Service Requests, try using ‘Service_Request_Uiv’. It worked for me in the core environment. 

Best Regards,
Charana

https://lk.linkedin.com/in/charanau
A
Rank
Userlevel 3
Badge +11

Hi Charana

I don’t think this table contains any requests, the columns I can see in this are below. But from debug console on service requests page, I got the table name, thank you..

 

 

Reply


Terms & ConditionsCookie settings