fetchXML i think its miles away from sql possiblities - Whats the fxml-alternative for Case When,

(0) Share

Report

Posted on by Peter Bohn

how to do this with fetchXML??

I mean the CASE WHEN THEN ...

SELECT DISTINCT 

contactid, 
fullname, 
birthdate, 
address1_line1,
address1_postalcode,
CASE WHEN contactid IN @family THEN 'true' ELSE 'false' END AS family, 
CASE WHEN contactid IN @same_address THEN 'true' ELSE 'false' END AS same_address, 
CASE WHEN contactid IN @kundeid THEN 'true' ELSE 'false' END AS contact_started_from

FROM         
FilteredContact

WHERE     
(contactid IN (@choose_contacts_to_show))

ORDER BY 
fullname

*This post is locked for comments

All responses (3)

Answers (0)

Arun Vinoth 11,613 on at

Like (0)

Report

RE: fetchXML i think its miles away from sql possiblities - Whats the fxml-alternative for Case When,

This was already discussed in forum: social.microsoft.com/.../is-it-possible-to-implement-the-switch-case-from-the-following-sql-query-through-fetchxml
Peter Bohn on at

Like (0)

Report

RE: fetchXML i think its miles away from sql possiblities - Whats the fxml-alternative for Case When,

Hi Rajat,

No I need to get this working in crm online, cause we moved to crm online and there is only fetchXML allowed. But how can I get this transformed from sql to fetchXML?
RajatSharmaRaj on at

Like (0)

Report

RE: fetchXML i think its miles away from sql possiblities - Whats the fxml-alternative for Case When,

Are you working on SSRS here? If so then you will have to add report level conditions like below -

social.msdn.microsoft.com/.../ssrs-case-statement

You can find more details about decision function for SSRS here -

docs.microsoft.com/.../expression-examples-report-builder-and-ssrs