Forums

Forums / Developing Portals / Dependent Lookups

Dependent Lookups

4 posts, 1 answered
  1. Joeri Stroy
    Joeri Stroy avatar
    4 posts
    Registered:
    24 Feb 2020
    Answered
    18 Jan 2023
    Link to this post
    I'm having trouble configuring a lookup filter

    I have 2 lookups on my form, City and Street.

    I'm trying to configure it so that when you select a city, the street lookup field is filtered based on the selected city.

    In the street lookup I have configured a filter with name @cityId@ with filter type "Field Value" and selected the city field (nrq_address1cityid) as the value.

    In the fetchxml for the street lookup I've added the following filter
          <condition attribute="nrq_maincityid" operator="eq" value="@cityId@" />

    But no matter what city I select, the street lookup stays empty.

    However, if I check the network traffic, I do see that the query for the street lookup does return values.

    So it seems this is an issue with the displaying of the data, not the underlying query
    Last modified on 18 Jan 2023 10:01 by Joeri Stroy
  2. Rawdon Edghill
    Rawdon Edghill avatar
    76 posts
    Registered:
    16 Dec 2020
    18 Jan 2023
    Link to this post
    Hi Joeri,

    Thank you for your query.

    Based on the description it seems to be configured correctly.

    I suggest for you too:
    - Validate if there is any JS that could be conflicting the event. You can use the Browser console to look for errors.
    - Check if you are setting the Value and Display attribute in both lookups correctly.
    - or I can recommend to try simulating the problem in a second form/page that only has those lookups to validate behavior only of those elements.

    If you are still facing this issue, kindly email support @crmportalconnector.com for further investigation. 

    Regards,
    Rawdon
    Last modified on 18 Jan 2023 21:01 by Rawdon Edghill
  3. Joeri Stroy
    Joeri Stroy avatar
    4 posts
    Registered:
    24 Feb 2020
    19 Jan 2023 in reply to Rawdon Edghill
    Link to this post
    Hi Rawdon,

    I was able to figure out why it was failing,

    i had a top="100" attribute in the fetchxml, and apparently, this causes the rendering to fail, which i find kinda strange, but anyway, problem solved
  4. Rawdon Edghill
    Rawdon Edghill avatar
    76 posts
    Registered:
    16 Dec 2020
    19 Jan 2023
    Link to this post
    Hi Joeri,

    I am glad to hear you were able to get it solved.

    Have a great day.

    Regards,
    Rawdon
4 posts, 1 answered