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

I have the same question (0)

All responses (3)

Answers (0)

Sort by

RajatSharmaRaj on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Peter Bohn on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Arun Vinoth 11,615 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No