Sql to FetchXML issue RRS feed

  • Question

  • We're in the process of converting our SQL queries into fetchxml, and I ran into a snag that i'm not quite sure how to get around. This is a part of a complex query:

    SELECT FilteredContact.emailaddress1, FilteredContact.firstname, FilteredContact.lastname, FilteredContact.telephone1, FilteredContact.jobtitle, 'a' as order1
    FROM    FilteredAccount AS FA

    Our problem is we're unsure of a way to have the above result go into 'order1', as it does not exist. Only for the report.

    Is there some type of equivalent in fetchXML to have a 'results column' ?

    Wednesday, September 24, 2014 6:43 PM


  • Hi Matt,
    If this is for a report, you could remove the column from the fetch xml and add the order field as a computed field on the dataset.
    Let me know if you need further explanation.
    • Marked as answer by MattFSI Thursday, September 25, 2014 3:27 AM
    Wednesday, September 24, 2014 8:59 PM