# How to select specific records when dynamic sitemap is activated on the page?

**URL:** <https://forum.bubble.io/t/how-to-select-specific-records-when-dynamic-sitemap-is-activated-on-the-page/208940>\
**Category:** Database\
**Created:** [May 30, 2022, 11:57am UTC](https://forum.bubble.io/t/how-to-select-specific-records-when-dynamic-sitemap-is-activated-on-the-page/208940 "2022-05-30T11:57:24Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bobome](https://avatars.discourse-cdn.com/v4/letter/b/a183cd/32.png) [@Bobome](https://forum.bubble.io/u/Bobome)\
**Post date:** [May 30, 2022, 11:57am UTC](https://forum.bubble.io/t/how-to-select-specific-records-when-dynamic-sitemap-is-activated-on-the-page/208940/1 "2022-05-30T11:57:24Z")

</div>

Hi Bubble community,

When the dynamic sitemap is activated on a specific page (“Type of content” not empty), how do you choose the records that should appear in the sitemap and those that shouldn’t appear (while still be accessible to users in both case)?

Currently:

- All the records appear in the sitemap
- Privacy rules help remove records from the sitemap BUT these records also become inaccessible to users

The objective: have a kind of “Do a search for” with joins, for choosing specific records that would appear in the sitemap.

The reasons:

- For architecture purpose (1 table collecting data from several tables)
- For SEO purpose (non canonical links shouldn’t appear in the sitemap)

The only way would be to import a custom sitemap but it makes the maintenance quite difficult.

If you have any ideas, let me know 😊. @NigelG @andrewgassen and @all

Thanks

---

<div class="post-metadata">

**Author:** ![NigelG](https://avatars.discourse-cdn.com/v4/letter/n/ea5d25/32.png) [@NigelG](https://forum.bubble.io/u/NigelG)\
**Post date:** [May 30, 2022, 2:02pm UTC](https://forum.bubble.io/t/how-to-select-specific-records-when-dynamic-sitemap-is-activated-on-the-page/208940/2 "2022-05-30T14:02:18Z")

</div>

> [@Bobome](#):
>
> Privacy rules help remove records from the sitemap BUT these records also become inaccessible to users

Remove “find in searches” from non-logged in users.

---

<div class="post-metadata">

**Author:** ![Bobome](https://avatars.discourse-cdn.com/v4/letter/b/a183cd/32.png) [@Bobome](https://forum.bubble.io/u/Bobome)\
**Post date:** [May 30, 2022, 3:53pm UTC](https://forum.bubble.io/t/how-to-select-specific-records-when-dynamic-sitemap-is-activated-on-the-page/208940/3 "2022-05-30T15:53:39Z")

</div>

Thanks @NigelG. The matching records are removed from the sitemap based on the privacy condition but then we bump into the issue described in my post: the content of the matching records can’t be displayed properly because “Find in searches” is unchecked.

I’m wondering if there is a better way to manage what’s on the sitemap, especially on the dynamic sub-sitemap, without having to upload a custom sitemap file (complex to maintain manually because of many dynamic sub-sitemaps used).

---

<div class="post-metadata">

**Author:** ![NigelG](https://avatars.discourse-cdn.com/v4/letter/n/ea5d25/32.png) [@NigelG](https://forum.bubble.io/u/NigelG)\
**Post date:** [May 31, 2022, 9:07am UTC](https://forum.bubble.io/t/how-to-select-specific-records-when-dynamic-sitemap-is-activated-on-the-page/208940/4 "2022-05-31T09:07:14Z")

</div>

> [@Bobome](#):
>
> the content of the matching records can’t be displayed properly because “Find in searches” is unchecked.

Can you put a rule in so that it is checked when the User is logged on?

Or are you users not logged-on?

---

<div class="post-metadata">

**Author:** ![Bobome](https://avatars.discourse-cdn.com/v4/letter/b/a183cd/32.png) [@Bobome](https://forum.bubble.io/u/Bobome)\
**Post date:** [May 31, 2022, 3:52pm UTC](https://forum.bubble.io/t/how-to-select-specific-records-when-dynamic-sitemap-is-activated-on-the-page/208940/5 "2022-05-31T15:52:42Z")

</div>

Unfortunately there is no private user page on my site. Information are accessible to everyone 🙂

---

<div class="post-metadata">

**Author:** ![NigelG](https://avatars.discourse-cdn.com/v4/letter/n/ea5d25/32.png) [@NigelG](https://forum.bubble.io/u/NigelG)\
**Post date:** [May 31, 2022, 4:24pm UTC](https://forum.bubble.io/t/how-to-select-specific-records-when-dynamic-sitemap-is-activated-on-the-page/208940/6 "2022-05-31T16:24:58Z")

</div>

Ahhh, tricky then.

I wonder if there is a way to differentiate a User on a Browser from a Google bot?

---

<div class="post-metadata">

**Author:** ![Bobome](https://avatars.discourse-cdn.com/v4/letter/b/a183cd/32.png) [@Bobome](https://forum.bubble.io/u/Bobome)\
**Post date:** [June 2, 2022, 8:44am UTC](https://forum.bubble.io/t/how-to-select-specific-records-when-dynamic-sitemap-is-activated-on-the-page/208940/7 "2022-06-02T08:44:14Z")

</div>

Thank you for your thoughts. I believe I will have to load a custom sitemap on a very regular basis 😅
