Posted on

Changing default Navigation Model in Webcenter portal

Requirement- In your webcenter Portal application , if you dont want to use seeded navigation model and you create your own navigation model and you want to make your navigation model
as default navigation model.

Implementation – When you create an Webcenter portal application using create new application and selection Webenter Portal application then seeded navigation model, default-navigation-model.xml, is set as the application’s default navigation model. Now if create your own navigation model to use for the main navigation path through your application, rather than having to explicitly reference this navigation model whenever you want to use it, you can set it as the default.
You can set the default navigation model for a Portal Framework application by editing the oracle.webcenter.portalapp.navigation.model preference in the adf-config.xml file.

-> Open the adf-config.xml file

-> Click the Source tab.Locate the ADF preference with the following id:

      oracle.webcenter.portalapp.navigation.model

-> Set the value attribute to the path of the navigation model that you want to use as the default for the application, for example:

value=”/oracle/webcenter/portalapp/navigations/techartifactNavigationModel.xml”

Below is adf-config.xml will look like

<preference id="oracle.webcenter.portalapp.navigation.model"
            desc="Default Navigation Model"
            value="/oracle/webcenter/portalapp/navigations/techartifactNavigationModel.xml"
            resourceType="navigation" display="true"/>

-> Save the adf-config.xml file.

Happy learning with Vinay Kumar in techartifact

Posted on

Change metadata in MDS/ Metadata command for weblogic

In Weblogic for exporting metadat we use various command like

-> importMetaData – Imports metadata for an application.

-> exportMetaData – Exports metadata for an application.

-> deleteMetaData – Deletes the metadata in the application repository.

-> purgeMetaData – Purge metadata.

-> deleteMetadata – Deletes the selected documents from the application repository. When this command is run against repositories that support versioning (that is, database-based repositories), delete is logical and marks the tip version (the latest version) of the selected documents as “deleted” in the MDS repository partition.

example – wls:/weblogic/serverConfig> deleteMetadata(application=’mdsapp’,server=’server1′, docs=’/mypackage/*’)

-> exportMetadata -Exports application metadata. Use this command and the importMetadata command to transfer application metadata from one server location (for example, testing) to another server location (for example, production).

example – wls:/weblogic/serverConfig> exportMetadata(application=’mdsapp’,server=’server1′,toLocation=’/tmp/myrepos’,docs=’/**’)

-> importMetadata– Imports application metadata. Use the exportMetadata command and this command to transfer application metadata from one server location (for example, testing) to another server location (for example, production).

example – wls:/weblogic/serverConfig> importMetadata(application=’mdsapp’, server=’server1′,fromLocation=’/tmp/myrepos’,docs=”/**”)

-> purgeMetadata– Purges the older (non-tip) versions of unlabeled documents from the application’s repository. All unlabeled documents will be purged if they are expired, based on Time-To-Live (the olderThan argument). This command is applicable only for repositories that support versioning, that is, database-based repositories.

example – wls:/weblogic/serverConfig> purgeMetadata(‘mdsapp’, ‘server1’, 10)

update metadata in webcenter-config.xml –

Now Lets take an example of changing an metadata for webcenter application. So first we export in some temprary location then we make some changes.Then again we import from temp location to specified location.

-> Go to Middleware home/WebCenter Installation directory/common/bin and run wlst.sh (unix) or wlst.cmd(windows)

-> connect(‘weblogic’,’weblogic1′,’locahost:7001′) or give secure files path connect(userConfigFile=’/oracle/config.secure’, userKeyFile=’/oracle/key.secure’, url=’localhost:7001′)
see how to generate secure file

Then export the current configuration by running the following command in WLST command line. Set the toLocation to some “temporary location”.
->exportMetadata (application=’webcenter’, server=’WC_Spaces’, toLocation=’/tmp/Metadata’, docs=’/oracle/webcenter/webcenterapp/metadata/webcenter-config.xml’)

-> Change XXX parameter to XX MB in /oracle/webcenter/webcenterapp/metadata/webcenter-config.xml file.

-> Then import the file back to WebCenter Spaces server following the below mentioned command line.

importMetadata(application=’webcenter’, server=’WC_SpacesXXX’, fromLocation=’/tmp/Metadata’, docs=’/oracle/webcenter/webcenterapp/metadata/webcenter-config.xml’)

-> exit();

Happy Learning with Vinay Kumar in techartifact…

Posted on

Dynamically changing query in view object in Oracle ADF

I have also written in my past post that how can you change the query my old post to change query . Here is another way.

Sometime requirements can be dynamically change SQL query where clause in View Object. I found on internet .so for the reference, i am sharing.

To use this functionality, you need to override buildWhereClause(StringBuffer sqlBuffer, int noBindVars) method in view object implementation. You use sqlBuffer parameter in this method (which contains SQL query where in StringBuffer) to change SQL in correlation to you needs. Just replace, remove, add string in this parameter. Just remember to use same bind variables names which will be use in VO SQL call (generic bind variables names are named like :vc_temp_1, :vc_temp_2,…).

    @Override  
        protected boolean buildWhereClause(StringBuffer sqlBuffer, int noBindVars) {  
      
            //call super and see if there is where clause.  
            boolean hasWhereClause = super.buildWhereClause(sqlBuffer, noBindVars);  
      
            if (hasWhereClause) {   
                //modify existing where query.  
            }  
            else {   
                //or if you add where clause then return true;  
                hasWhereClause = false;   
      
            }  
      
            return hasWhereClause;  
        }