Dynamics Community Forum Thread Details

sql query in computed column field for data entity

Hi Experts,

I have created a string unmapped computed column to the data entity for that field i have added a method which contains sql query, i have attached the sql server query below

select  TRACKINGTYPE,* from WORKFLOWTRACKINGTABLE
 join WORKFLOWTRACKINGWORKITEM on WORKFLOWTRACKINGTABLE.RECID = WORKFLOWTRACKINGWORKITEM.WORKFLOWTRACKINGTABLE  
 join WORKFLOWWORKITEMTABLE on WORKFLOWTRACKINGWORKITEM.WORKFLOWWORKITEMTABLE = WORKFLOWWORKITEMTABLE.RECID
 where WORKFLOWWORKITEMTABLE.REFRECID = 5637339576 order by WORKFLOWTRACKINGWORKITEM.CREATEDDATETIME desc

in the above query where WORKFLOWWORKITEMTABLE.REFRECID = 5637339576 // this is recid related to sales order.

below is my method in visual studio,

public static str getWorkflowStatus()
    {                
        str sqlspt  = 'select TRACKINGTYPE from WORKFLOWTRACKINGTABLE join WORKFLOWTRACKINGWORKITEM on WORKFLOWTRACKINGTABLE.RECID = WORKFLOWTRACKINGWORKITEM.WORKFLOWTRACKINGTABLE join WORKFLOWWORKITEMTABLE on WORKFLOWTRACKINGWORKITEM.WORKFLOWWORKITEMTABLE = WORKFLOWWORKITEMTABLE.RECID where WORKFLOWWORKITEMTABLE.REFRECID = '  SysComputedColumn::returnField(tableStr(SalesOrderHeaderV2Entity), tableStr(SalesTable), fieldStr(SalesTable, RecId));
        return sqlspt;
    }

Now i need help to write the "Order by WORKFLOWTRACKINGWORKITEM.CREATEDDATETIME desc" in Visual studio method.

Can anyone help me to solve this?

Thanks,

With regards,

srihari.

Quick Links