Cross Site Lookup - Filter null values error

rss

Posted by Jaydius - Apr 13 ’16 at 10:05

Im trying to filter a field (WOID), but im running in to a 'Loading Failed' error whenever I enter a value to search for.  The field does have some blank/null values in the database.  Im wondering if that could be the cause?  If so, is there a way to stop the filter query from producing the error?

Im using the following filter code:

filter=substringof('" + encodeURIComponent(term) + "', {LookupField})

  • rostislav
    rostislav
    Moderator
    Member for: 7 years 8 months 25 days
    #1 by rostislav Apr 14 ’16 at 06:40

    What is the exact error the REST API gives? When filtering open up the console (F12) and check the error message you get in it. It will be an error code with a link, follow the link in your browser. We'll need to see the full link as it appears in the address bar and the actual message that you get at that address.

    Also, what is WOID's field type exactly?

    link flag
  • Jaydius
    Member
    Member for: 7 years 2 months 19 days
    #2 by Jaydius Apr 19 ’16 at 03:46

    [#1]: <m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">

    <m:code>-2146232060, Microsoft.SharePoint.SPException</m:code> <m:message xml:lang="en-US">Exception from HRESULT: 0x80131904</m:message> </m:error> The WOID field is a number field.  Wanting to be able to use the real time search filtering on the cross site lookup field, e.g. type 2 and see all numbers starting with 2...
    link flag
  • rostislav
    rostislav
    Moderator
    Member for: 7 years 8 months 25 days
    #3 by rostislav Apr 20 ’16 at 04:17

    [#2]:

    You should use the startswith operator:

    ...filter=startswith(number, '" + encodeURIComponent(term) + "')...

    where number is the internal name of the number column

    link flag
  • seoexpert
    Member
    Member for: 4 months 8 days
    #4 by seoexpert Jan 17 ’23 at 11:10

    This was incredibly an exquisite implementation of your ideas colgate packing job work from home

    link flag
  • seoexpert
    Member
    Member for: 4 months 8 days
    #5 by seoexpert Jan 18 ’23 at 05:08

    this is really nice to read..informative post is very good to read..thanks a lot! ITC Franchise

    link flag
  • seoexpert
    Member
    Member for: 4 months 8 days
    #6 by seoexpert Jan 18 ’23 at 06:17

    Hey, great blog, but I don’t understand how to add your site in my rss reader. Can you Help me please? safety deposit boxes for sale

    link flag
  • seoexpert
    Member
    Member for: 4 months 8 days
    #7 by seoexpert Jan 25 ’23 at 05:55

    registration on website also consumes a lot of time due to whichpeople do not visit such websites. Now with the introduction of https://www.signnow.com/ask/detailed-guide-on-how-to-sign-a-pdf-online-in-signnow it has allowed customers to use this website. This saves time and is highly recommended.

    link flag
  • seoexpert
    Member
    Member for: 4 months 8 days
    #8 by seoexpert Jan 26 ’23 at 11:34

    very interesting post.this is my first time visit here.i found so many interesting stuff in your blog especially its discussion..thanks for the post! best vpn for privacy

    link flag
  • seoexpert
    Member
    Member for: 4 months 8 days
    #9 by seoexpert Jan 27 ’23 at 05:22

    Hey, great blog, but I don’t understand how to add your site in my rss reader. Can you Help me please? Self Help Book Publisher

    link flag
Displaying 1 to 9 of 9 messages

Related threads