Skip to main content

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

 

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

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