Answered

Liquid code for getting record from a filtered list

(0) Share

Report

Posted on by KBe

Hi all, I am trying to find or make some Liquid code for fetching a record from a filtered list. I have 2 related tables with countries (parent) and cities (child), and 2 web pages with a list (countries on one page and cities on the second page). The page with the cities (child) is then filtered by the selected parent record on the countries page (some javascript code filtering child list based on ID of parent record).

At the top of the cities page I am trying to add some dynamic text using Liquid (and fetchxml?), saying something like "This list shows all cities in <name of the selected parent record>".

Or would jQuery or JavaScript or anything else be a better solution?

Would highly appreciate any good tip or code snippet that I can use 🙂

Categories:

Customize & extend

I have the same question (0)

All responses (3)

Answers (1)

Hugo Bernier Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @KBe ,

If I understand the question right, it looks like the best solution would be to use client-side filtering using the techniques shown in this documentation.

As far as writing FetchXML, I personally use XRM Toolbox to help me write my queries.

I hope this helps?!

Was this reply helpful? Yes No
Christian Leverenz 1,214 on at

Like (1)

Report
Copy link

Link copied!

Hi @KBe ,

if i am not wrong this is an oob feature. On the form you created in the dataverse you could say, this lookup shows only values which are related to the other lookup. When both lookups are on the form, the filtering should be done automatically.

May be you give it a try.

Have fun,

Christian

Was this reply helpful? Yes No
Verified answer

oliver.rodrigues 9,425 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Your solution here should be based on the following components:

List (pointing to the county table)

Basic Form (pointing to the country table, containing the name of the country and a subgrid to cities)

You shouldn't have any JS filter on the cities page

Via Liquid or JS you can manipulate how you display the Country name field

is this how your solution is looking like?

Was this reply helpful? Yes No