Chart

[bhatsunita]

Hello,

Can anyone confirm is  "ORDER BY" clause works in the query for the Chart?

I do not get error but the preview of chart goes blank.

Version: RSA IG&L 7.2

[CraigRamsay]

Does the preview disappear in the Edit screens and also at the definition screen where you can click in to Edit the Chart?

If the query you are using returns results when running it directly against the DB then this may be worth raising a case with CS.

This happens sometimes in my v7.1 lab and rectifies itself when I switch the X and Y axis around, not really sure why but it does.

[bhatsunita]

Hello Craig,

Here is my query running on 7.2Patch 1

(
  select 
    dr.start_time, 
    sdata.RUN_ID, 
    sdata.cus_attr_user_cas_14, 
    count(EMAIL_ADDRESS) as usr_count 
  from 
    avuser.v_DC_SOURCEDATA_USER sdata, 
    avuser.pv_identity_collection dr 
  WHERE 
    sdata.JOB_STATUS not like 'Terminated' 
    and sdata.run_id = dr.run_id 
    and sdata.CUS_ATTR_USER_CAS_14 = 'Outsourced Service Contractor' 
    and dr.name = 'Enterprise Directory-IDC' 
    and dr.STATUS = 'Completed' 
  GROUP BY 
    sdata.run_id, 
    sdata.cus_attr_user_cas_14, 
    dr.start_time 
  ORDER BY 
    dr.start_time
)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I am attaching the screenshots WithOut the "Order By" clause and with it.

[JamiePryer]

Hey,

try this:

(
  select 
    * 
  from 
    (
      select 
        dr.start_time, 
        sdata.RUN_ID, 
        sdata.cus_attr_user_cas_14, 
        count(EMAIL_ADDRESS) as usr_count 
      from 
        avuser.v_DC_SOURCEDATA_USER sdata, 
        avuser.pv_identity_collection dr 
      WHERE 
        sdata.JOB_STATUS not like 'Terminated' 
        and sdata.run_id = dr.run_id 
        and sdata.CUS_ATTR_USER_CAS_14 = 'Outsourced Service Contractor' 
        and dr.name = 'Enterprise Directory-IDC' 
        and dr.STATUS = 'Completed' 
      GROUP BY 
        sdata.run_id, 
        sdata.cus_attr_user_cas_14, 
        dr.start_time
    ) 
  ORDER BY 
    start_time
)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[bhatsunita]

No luck. The query preview returns data but the display attributes has no chart created. Tested on 7.1 and 7.2P1.