Dynamic usage of datasource in DCT

Hi,

I would like to know if I can fill a select, triggered by a selection from another select in the DCR. Like I select a city (city select is filled with datasource inline command, using a java class) and its towns are filled into the other select. Here I want to use a datasource again, sending the city as a parameter.
Any ideas?

Thank you...

Find more posts tagged with

Comments

Migrateduser

Yes, using FormAPI to monitor the dropdown.

IWEventRegistry.addItemHandler

and use the following to run your command

IWDatacapture.callServer

Look at the FormsPublisher: FormAPI Developer’s Guide for further information on this.

jagadesh

Hi,

I would like to know if I can fill a select, triggered by a selection from another select in the DCR. Like I select a city (city select is filled with datasource inline command, using a java class) and its towns are filled into the other select. Here I want to use a datasource again, sending the city as a parameter.
Any ideas?

Thank you...

Yes you can do it in Form API
Just have look at workflow modeler guide for the Datasource execution code for Form API
Call the datasource execution onItemChange of City item to fetch towns
Pass input parameter as city value and put on the dsParams Map in the copied code

errorLog.txt

jagadesh

As you requested I sent the code as message at the same time I put the code here as well. so it will be reference to others in future.


 function setDatasourceValueCallback(resultObj, ctxParams)
     {

        var selectItemRef;
        if(ctxParams != undefined)
        {
           selectItemRef = ctxParams.get("selectItemVpath");
        }
        var datasourceObj = new IWDatasource();

         datasourceObj.addOptionsToSelect(resultObj, selectItemRef,getItemValue(selectItemRef)); 

        top.hiddenFrameRunning = true;
        return;
     }


         function getItemValue(itemName)
         {

            var propertyItem = IWDatacapture.getItem(itemName);
            var value;
            try{
              value = propertyItem.getOptions()[propertyItem.getValue()].value;     
               return value;
            }catch(e){}
            try{
               value = propertyItem.getValue();      
               return value;
            }catch(e){}
         }
   //Execute the datasource passing the particular item
     function getValueForDatasource(item,selectedDSValue,params,sqlcode)
  {

         var itemPath=item.getName();
      var datasourceObj = new IWDatasource();
      var dsParams = new IWMap();
      var returnParams = new IWMap();
      returnParams.put("selectItemVpath",
      itemPath);      
      dsParams.put("branch",
      getBranch(IWDatacapture.getWorkarea()));
      dsParams.put("Locale",
      getLocale(IWDatacapture.getWorkarea()));
      dsParams.put("params",params);
      dsParams.put("sqlcode",
      sqlcode); //sql codes stored in xml as attribute and value and based on attribute extracted the sql query
      datasourceObj.executeDatasource("setDatasourceValueCallback", selectedDSValue, dsParams,
      returnParams);

           return;

  }    
function getTowns(item)
 {  

   var itemPath=item.getName();   
  var value=item.getOptions()[item.getValue()].value; 
  var townItem=IWDatacapture.getItem(itemPath+"/../town");  
   getValueForDatasource(townItem,<DS Name>,value,<Sql query code to fetch data from DB>);//sql queries stored in xml, sql code as attribute, queries as value for dynamic usage
           return;
 }

bturns

Thanks for posting the code. This was very helpful.

bturns

Has anyone seen an issue with Firefox limiting the number of rows returned in a datasource object? I'm experiencing that now with Firefox 3.5 and 4

http://devnet.interwoven.com/forums_vb/showthread.php?t=35327&forumid=11

Script column width from dataset value.rptdesign

jagadesh

Has anyone seen an issue with Firefox limiting the number of rows returned in a datasource object? I'm experiencing that now with Firefox 3.5 and 4

http://devnet.interwoven.com/forums_vb/showthread.php?t=35327&forumid=11

Have you checked with support Team on this?