CFA_DATASHEET

[McCabe, Kevin]

Hi Guys,

I'm using CFA_DATASHEET and want to be able to have a link from one of the
columns.

But the link must include two variables from the workflow.

These are LACTIVETASKS and the Workflow Object ID

How do I set up the <CFSCRIPT> settings to do this.

Below is the coded page:

<cfscript>    
    ds = Request.cfa.objectstore.dsn;
    //set parameters on the data retrived
    stFilter = structNew();
    stFilter.stRetrieval = structNew();
    stFilter.stRetrieval.typeID = "70E7DFC0-A67E-11D2-B3AC00C04FA35A23";
    
    //set the parameters for viewing the data
    stFilter.stView = structNew();
    stFilter.stView.aColumns = arrayNew(1);

    stFilter.stView.contextName = 'cn';
    stFilter.stView.aColumns[1] = structNew();
    stFilter.stView.aColumns[1].key = 'label';
    stFilter.stView.aColumns[1].label = 'Title';
    stFilter.stView.aColumns[1].width = '150';
        stFilter.stView.aColumns[1].url =
'taskwrapper.cfm?taskid=##&workflowID=##';

    stFilter.stView.aColumns[2] = structNew();
    stFilter.stView.aColumns[2].key = 'attr_datetimecreated';
    stFilter.stView.aColumns[2].label = 'Created';
    stFilter.stView.aColumns[2].width = '100'; 
    stFilter.stView.aColumns[2].length = '10'; 
    stFilter.stView.aColumns[2].formatType = 'custom';
    stFilter.stView.aColumns[2].formatString =
'dateFormat(value,"dd/mm/yyyy")';
    
    stFilter.stView.itemsPerPage = "5";
    stFilter.stView.startItem = "1";

    //default ordering
    stFilter.stView.key = "objectid";
</cfscript>

<!--- retrieve data from database --->
<!--- get total data set --->
<cfa_contentObjectGetMultiple
        dataSource = "#ds#"
        typeID = "#stFilter.stRetrieval.typeID#"
        r_stObjects = "r_stObjects">

<CFA_DUMP VAR="#r_stObjects#">
                
                
<!--- transform object structure into structure for datasheet --->    
<CFA_DATASHEETArrayGet
    dataSource = "#ds#"
    stObjects = "#r_stObjects#"
    stFilter = "#stFilter#"
    r_aRows="aRows">


<cfa_controlHandler name="ds" contextName="cn">
<cfoutput>
<table cellpadding="0" cellspacing="0" border="0">
<tr>
    <td>
</cfoutput>    
            <CFA_DATASHEET
                    dataSource="#ds#"
                    id="70E7DFB6-A67E-11D2-B3AC00C04FA35A22"
                    stView="#stFilter.stView#"
                    aDataRows="#aRows#">
<cfoutput>

    </td>
</tr>
</table>
</cfoutput>
</cfa_controlHandler>

----------------------------
Kev McCabe
Intranet Team Leader
TEL:  +44 (0) 20 7941 5502
MOB:    +44 (0) 70 9225 2813
----------------------------


**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**********************************************************************

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.