Skip to main content
Question

quick reports shows error

  • November 16, 2022
  • 2 replies
  • 74 views
A
Sidekick (Customer)
Forum|alt.badge.img+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

 

    Charana Udugama

    2 replies

    Charana Udugama
    Superhero (Employee)
    Forum|alt.badge.img+12
    • Charana Udugama
    • Superhero (Employee)
    • November 17, 2022

    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

    Reach me via LinkedIn - https://www.linkedin.com/in/charanau
    H
    A
    Sidekick (Customer)
    Forum|alt.badge.img+11
    • anushakh
    • Author
    • Sidekick (Customer)
    • November 21, 2022

    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..

     

     

    Terms & ConditionsCookie settingsAccessibility statement