Hello Mehdi,
Thanks for your reply and the solution provided. I think the below highlighted in red is what i'm after?
SelectStart*/select \"opportunity0\".[Name] as \"name\"\r , \"opportunity0\".[TransactionCurrencyId!id] as \"transactioncurrencyid!id\"\r ,
\"opportunity0\".[TransactionCurrencyId!logicalname] as \"transactioncurrencyid!logicalname\"\r , \"opportunity0\".[TransactionCurrencyId!name] as
\"transactioncurrencyid!name\"\r , \"opportunity0\".[EstimatedValue] as \"estimatedvalue\"\r , \"opportunity0\".[EstimatedCloseDate] as \"estimatedclosedate\"\r ,
\"opportunity0\".[CustomerId!id] as \"customerid!id\"\r , \"opportunity0\".[CustomerId!logicalname] as \"customerid!logicalname\"\r , \"opportunity0\".[CustomerId!name] as
\"customerid!name\"\r , \"opportunity0\".[CloseProbability] as \"closeprobability\"\r , \"opportunity0\".[OpportunityRatingCode] as \"opportunityratingcode\"\r ,
\"opportunity0\".[pdw_OpportunityNumber] as \"pdw_opportunitynumber\"\r , \"opportunity0\".[pdw_ActualQuoteDate] as \"pdw_actualquotedate\"\r , \"opportunity0\".[qpw_machinetype!id] as
\"qpw_machinetype!id\"\r , \"opportunity0\".[qpw_machinetype!logicalname] as \"qpw_machinetype!logicalname\"\r , \"opportunity0\".[qpw_machinetype!name] as \"qpw_machinetype!name\"\r ,
\"opportunity0\".[pdw_ProgressStage] as \"pdw_progressstage\"\r , \"opportunity0\".[pdw_ProjectProbability_optionset] as \"pdw_projectprobability_optionset\"\r ,
\"opportunity0\".[qpw_Probability_optionset] as \"qpw_probability_optionset\"\r , \"opportunity0\".[pdw_GrossMargin] as \"pdw_grossmargin\"\r , \"opportunity0\".[new_Products_Quantity] as
\"new_products_quantity\"\r , \"opportunity0\".[pdw_SalesRep!id] as \"pdw_salesrep!id\"\r , \"opportunity0\".[pdw_SalesRep!logicalname] as \"pdw_salesrep!logicalname\"\r ,
\"opportunity0\".[pdw_SalesRep!name] as \"pdw_salesrep!name\"\r , \"opportunity0\".[StepName] as \"stepname\"\r , \"opportunity0\".[OpportunityId] as \"opportunityid\"\r ,
\"opportunitycustomeridcontactcontactid\".[EMailAddress1] as \"opportunitycustomeridcontactcontactid.emailaddress1\"/*SelectEnd*/ /*FromStart*/from Opportunity as
\"opportunity0\" \t/*JoinStart*/ left outer join Contact as \"opportunitycustomeridcontactcontactid\" on (\"opportunity0\".[customerid!id] =
\"opportunitycustomeridcontactcontactid\".[ContactId])/*JoinEnd*//*FromEnd*/ /*WhereStart*/where (\"opportunity0\".[StateCode] = 0 and (\"opportunity0\".[ownerid!id] =
\"!eq-userid!\" or \"opportunity0\".[pdw_accountmanager!id] = \"!eq-userid!\" or \"opportunity0\".[pdw_areasalesmanager!id] = \"!eq-userid!\" or \"opportunity0\".[new_salesengineer!id] =
\"!eq-userid!\"))/*WhereEnd*/ /*OrderByStart*/order by \"opportunity0\".[EstimatedCloseDate] asc/*OrderByEnd*/","columnsetxml":null,"organizationtaborder":null,"_modifiedonbehalfby_value":null,
"queryappusage":null,"advancedgroupby":null,"conditionalformatting":null,"description":null,"iscustomizable":{"Value":true,"CanBeChanged":true,"ManagedPropertyLogicalName":"iscustomizableanddeletable"},
"canbedeleted":{"Value":false,"CanBeChanged":true,"ManagedPropertyLogicalName":"canbedeleted"}}]}
Kind regards,
Jeroen
