[mshuman]

Does anyone know which view contains the Issue Record?

Also, I noticed on the Support_Incident(supportcase) view that there are many custom entity fields showing up. This seems odd to me because they are not custom crm fields. Is there a sure-fire way to know where to find custom entity, crm, etc fields that we need to report off of?

It just seems a bit confusing to me, and the documentation doesn’t seem to clear this up.

Any help would be appreciated.

Thanks!
This is a cached copy. Click here to see the original post.

[mshuman]

RE: Enterprise Reporting Views

Just a little frustrating again. I just got off the phone with support a third time regarding not being able to find the Issue Record. (I was supposed to get a call back from someone who knew what they were talking about after the last call).

We just purchased the ODBC connection. One of the main reasons we wanted it was to do reporting on our Issue records. I can’t find the Issue Record in any of the views, and the Support Reps seemed just as clueless as me. The last person I spoke in with in Support mentioned it was an Enhancement request.

Uh…isn’t everything supposed to be exposed with ODBC?

[jtannone]

RE: Enterprise Reporting Views

Support_incidents view joins to the caseissue view using the case_issue_id field. There are other case-related views such as caseorigin, casetype, case_origins, case_types, case_stage_changes, support_reps, support_territories etc that all join back to the support_incidents view.

(NS – why do we have duplicate views – ie caseorigin and case_origins; casetype and case_types??)

SELECT *

FROM support_incidents si, caseissue ci

WHERE si.case_issue_id = ci.case_issue_id

AND si.create_date = sysdate

This will show all case info and issue info for cases created today.

Thanks

John Tannone

http://www.eset.com

[mshuman]

RE: Enterprise Reporting Views

I believe the caseissue view is for the case issue list that is found in the Support Case Record. I hoping to gain access to our Issue Management Record. Any other thoughts? Will someone from NetSuite chime in please?

[mshuman]

RE: Enterprise Reporting Views

We purchased the ODBC connection on the premise that we could access the Issue record. We were told that all records were exposed.

Now that we have purchased a pricey product, it appears that the Issue record is in fact not exposed through ODBC.

I’ve been trying to get Support to get this fixed for over a month. It is still an Enhancement …pending investigation. Nothing has changed.

Will someone from Product Management please chime in. We were promised a full featured solution, but some standard records are not available.

[Author]

Posts