none
Web Part not display information with query through SelectCommand

    Question

  • Hi,

      I'm using SharePoint Designer to include a display form for my list and library on a page, then using SelectCommand query to get the information from the list and library according to the parameter send through the url (query string). It was working fine up until today (19/1/17), the web part gave me the error below:-

    

    Here is the query text: I would like to know if this impact anyone of you or if you aware of any changes on SharePoint 2013 online (Office365) affecting this?

    Even i shorten the query, it doesn't give me the info.

    <View><Query><Where><Eq><FieldRef Name="Staff_x003a_ID"/><Value Type="Text">101</Value></Eq></Where><OrderBy><FieldRef Name="Modified"Ascending="False"/></OrderBy></Query></View>

    It is working if i only view it without query on specific information.

    <View><OrderBy><FieldRef Name="Modified"Ascending="False"/></OrderBy></View>

    Please let me know if you know anything.

    Thanks.

    Thursday, January 19, 2017 5:05 AM

All replies

  • Hi RichBee,

    Have you made any changes to the fields or the list views?

    Please add query elements to ‘SelectCommand’ property one by one to see which query element causes the error.

    Best Regards,

    Linda Zhang


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Friday, January 20, 2017 8:08 AM
    Moderator