DVT problems in Jdeveloper 12.1.3

Hi,

In 12.1.3 when you drag and drop a view object as a graph, the bindings created are not a type graph anymore, they are a normal tree, which raises the following question; how do you access again the wizard for the graph in case you want to change something on it or even further; how would you now implement a drill down graph? I wrote a post for the previous release which seems to be not applicable for this new realease. Am I missing something?

Regards.

  • The fact that the new Charts now use a standard tree binding instead of a custom Graph binding allows for more flexible tag structure and usage of stamping.
    For example, to achieve the feature where each bar is colored differently even though they all belong to the first series, we recommend to use attribute groups to specify that the bars should be colored by group.
    To to this, you would insert the following code into the <dvt:chartDataItem> tag, instead of swapping the series and group bindings:
    <dvt:attributeGroups value=[your group binding] id="ag1"type="color"/>
                                                                         
    I believe that in your example it would be the following:
    <dvt:chartDataItem group=#{row.EarningStatus} .....>
    <dvt:attributeGroups value=#{row.EarningStatus} id="ag1"type="color"/>
    </dvt:chartDataItem>
    If you use this new feature, then the bars would still be nicely spaced and display the labels below as in the original Chart, but would be colored differently as desired.
    This feature and other new Chart formatting features are described in this video:

    Hope this helps,
    Katia
    • 5. Re: DVT Visualization Graphs in 12.1.3
      Katarina Obradovic-Sarkic-OracleExplorer
      Katarina Obradovic-Sarkic-Oracle Aug 25, 2014 1:25 PM (in response to Katarina Obradovic-Sarkic-Oracle)
      Hi Alejandro,

      Regarding the drilling capabilities - since the new Charts are using standard rowset binding, you could use them for master-detail scenarios. For example, if your Chart is displaying orders by customer, and you have a master-detail data control set up for Customers and OrdersForCustomer, you could display OrdersForCustomer in an ADF Table. You can add two simple attributes on the Chart to enable row selection and then when you click on a bar in the Chart to select a customer, the table would update to display only the orders for the selected customer.
      The attributes to set on the Chart are:
      dataSelection="single"
      selectionListener="#{bindings.Customers.collectionModel.makeCurrent}" where bindings.Customers.collectionModel is the model for the Chart.

      Hope this helps,
      Katia

    http://download.oracle.com/otn_hosted_doc/jdeveloper/12cdemos/DVTChartsFormatting/DVTChartsFormatting.html

    https://community.oracle.com/thread/3597261?start=0&tstart=0

    Comments

    Post a Comment

    Popular posts from this blog

    Another user has changed the row with primary key oracle.jbo.Key[12 ].

    Image
    Try these solutions:  make sure that you check "refresh after insert" and refresh after update" for the primary key column in you entity object. in the application module tab Click the Properties tab and select jbo.locking.mode. Double click the “pessimistic”value next to the property to open the field editor and type “optimistic” over the value.Press enter. if error still exist then you must set "refresh after insert" and refresh after update" as true for all attributes in the entity object another way is to execute the View Object after the commit operation to bring back updated data to ViewObject. For this we need to override the  afterCommit()  of ViewObject class as follows:                  public void afterCommit(TransactionEvent){                         executeQuery();                       }              5- another way to solve this error is to overide the lock() method of the EntityImpl class       public void lock() {    
    Read more

    Working With File Throgh WebUtill

    -------------------------------------------------- Required Configuraion : By default the file transfer is disabled in webutil for a security measure. So, you have to enable File transfer configuration in webutil.cfg file. The webutil.cfg file is located in  forms\server. Open The webuil.cfg file and edit the following parameters : transfer.database.enabled=FALSE   Change To TRUE transfer.appsrv.enabled=FALSE       Change to TRUE WebUtil_File contains APIs to manipulate files and directories on the client. These Functions Or APIs are: Copy_File :  Copies a file Returns a Boolean to indicate success.  Syntax :   Webutil_File.Copy_File(SourceFileName in Varchar2 , Destination In Varchar2) Return Boolean  Example   Declare  vCopied Boolean;  Begin   vCopied :=  Webutil_File.Copy_File('C:\temp\mypic.jpg','X:\destination_folder');  If vCopied = true Then    Message('File copied Successfully');  Else   Message('Error in Copying File');  End if; Delete_File:
    Read more

    Reading From File

    -------------------------------------------------- Declare   vfilename varchar2(500);   in_file   Client_Text_IO.File_Type;   linebuf   VARCHAR2(1800);  BEGIN     vfilename := client_get_file_name('c:/temp/', File_Filter=>'Comma Dialimeted Files (*.csv)|*.csv|');      in_file := client_Text_IO.Fopen(vfilename, 'r');       GO_BLOCK('Emp');      FIRST_RECORD;     LOOP     Client_Text_IO.Get_Line(in_file, linebuf);      p_output_line(linebuf);     Client_Text_IO.New_Line;      Next_record;    END LOOP;     FIRST_RECORD; EXCEPTION   WHEN no_data_found THEN     Client_Text_IO.Put_Line('Closing the file...');     Client_Text_IO.Fclose(in_file); END; ------------------------------------------------------- PROCEDURE p_output_line(p_line varchar2) IS  vLINE VARCHAR2(4000); vVALUE VARCHAR2(1000);  vCOMMA_COUNT NUMBER; vREPORT_DATE DATE; BEGIN                      vLINE := p_line;  vCOMMA_COUNT := LENGTH(vLINE)- LENGTH(REPLACE(vLINE,',',''
    Read more