Jump to content


Hornbill Users
  • Content Count

  • Joined

  • Last visited

Community Reputation

2 Neutral

About Joyce

  • Rank
    Senior Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi @Victor, the field that I need are: h_itsm_requests.h_pk_reference h_itsm_requests.h_fk_user_name h_itsm_requests.h_dateresolved h_sys_accounts. h_email h_itsm_requests.h_custom_c h_itsm_requests.h_catalog h_cmdb_assets_computer.h_model h_itsm_requests.h_custom_c h_cmdb_assets_computer.h_name Filter by h_itsm_questions-> FormID = "Order" And h_itsm_questions-> Question Value = "Docking Station" AND h_itsm_questions-> QuestionID = "field_4" Thanks Joyce
  2. the table join seems to eliminate some data. I have try to review, and I can't figure out why
  3. Hi @Victor With the above settings, I seems to be missing some of the data. I have check the request, they all have similar field. The report definition for the two are: Test request for Victor- Missing rows.txt Test report for Victor- Correct.txt
  4. Hi, I need to link table 4 tables: h_itsm_requests, h_itsm_questions, h_cmdb_links, and h_cmdb_assets_computer. The field h_itsm_requests.h_pk_reference is equals to "h_itsm_questions.reference" , h_cmdb_links.h_fk_id_l is like "h_itsm_requests.h_pk_reference" and h_cmdb_links.h_fk_id_r is like "h_cmdb_assets_computer.h_pk_asset_id" How can I correctly join them in the report ? currently have them as per below, and I am getting an error, also the last join, seems to pick up the middle join
  5. Joyce

    What table stores PCF form fields

    yes I think i have a problem. All the values i am after have been recorded in the same form, so has same form ID and are all as answers. so it is difficult to filter ( i am ending up with 4 rows on the same request) I guess, i was wondering if there is some kind of 'form' table where the field ID and Answers are recorded as different columns/fields So i get report as
  6. Hi, I am trying to get a report, with details added through a progressive capture, using the form node. These details are in field_13, field_21, etc, in which table are these values store?
  7. Joyce

    Using SQL queries on report platform

    haha thanks Victor. will amend my query.
  8. Joyce

    Using SQL queries on report platform

    Hi Steve, I have try your query above, but I am getting an error. SELECT h_itsm_request_team_assignment.h_request_id As Reference, h_itsm_requests.h_summary AS Summary , COUNT(h_itsm_request_team_assignment.h_request_id) AS Assignments from h_itsm_request_team_assignment inner Join h_itsm_requests on h_request_id=h_pk_reference and h_itsm_request_team_assignment.h_previous_team_id !='No Previous Team' and h_itsm_request_team_assignment.h_previous_user_id !='No previous owner' Group by h_request_id HAVING COUNT(h_request_id) > 2 order by Assignments desc Limit 10 Not sure what I am missing. Regards, Joyce
  9. Joyce

    Using SQL queries on report platform

    Hi Steve, I created this report months ago, I think at a time the no previous owner was to eliminate the first count ( when ticket is logged, and assigned to a team, then another assignment is when an analyst within the same team takes the ticket). So the logic is, Its should have a Previous team, and have a previous Owner...so manly start counting the ticket when it move to the third assignment? does this make sense? I take it the above query can be used in Widgets and not possible on Report? Thanks. Regards, JOyce
  10. Joyce

    Using SQL queries on report platform

    Thanks Victor. I have a measure for it with query: h_requesttype ='Service Request' AND h_pk_reference IN(SELECT h_request_id FROM h_itsm_request_team_assignment WHERE h_previous_team_id != 'No previous team' AND h_previous_user_id !='No previous owner' GROUP BY h_request_id HAVING COUNT(h_request_id) > 2) I just want to have a data list of these tickets. Thanks. Regards, Joyce
  11. Hi, How can I use Sql query to build a report, instead of selecting fields? Is there a place to put a queary? I am looking to create a report, to select tickets which have been re-assigned between team twice or more. I have done this in a measure to get a count per month, but I want a list so we can identify the tickets and review them. Is there any other way? Thanks. Regards, Joyce
  12. Joyce

    Scheduling report to run weekly

    Thanks Trevor
  13. Joyce

    Scheduling report to run weekly

    Yes, similar issue. I have send you a report definition:
  14. Joyce

    Scheduling report to run weekly

    Thanks @Steven Boardman. That is what i have set, but it seems to run randomly, also multiple time in a day. I will reset again and check next week.