Exclure une liste RG

Need help
1

Hello everyone,
I hope you are well.

I’m completely stuck on a project.
Database :
Theme: Theme name (text)
Question: Question (text) + …
QuestionTheme: Theme name (Theme) + Question (Question) + OrderQuestion (number)

On a page, I display a drop-down list with all the themes, then I display all the questions in the theme (thanks to a repeating group: RG-QuestionIN), then all the questions not in the theme (in another repeating group: RG-QuestionOUT).
It’s this second repeating group that’s giving me trouble, as I can’t filter it properly.

The logical thing to do would be to make an RG-QuestionOUT on “Question”, but then I get stuck.
Could you explain how to do this?

Thank you very much!

Bonjour à tous,
J’espère que vous allez bien.

Je bloque complètement sur un projet.
Base de donnée :
Thème : Nom du thème (text)
Question : Question (text)
QuestionTheme : Nom du thème (Thème) + Question (Question) + OrdreQuestion (number)

Sur une page j’affiche une liste déroulante avec tous les thèmes, puis toutes les questions du thème (grace à un repeating group : RG-QuestionIN), puis toutes les questions qui n’y figurent pas (dans un autre repeating group "RG-QuestionOUT).
C’est ce second repeating group qui me pose problème, je n’arrive pas à le filtrer correctement.

La logique serait de faire un RG-QuestionOUT sur “Question” mais après je bloque
Pourriez-vous m’expliquer comment faire ?

Je vous remercie profondément !

2

in your “RG-QuestionOUT”, you can set the Data Source = “Do a Search for Questions minus list Do a Search for Questions where Nom du thème = Parent Group’s Thème”

This will retrieve the all the questions except the ones related to the “Thème”

3

Hello Ahmed,
Thanks for tour support but it doesnt works

IMG_2968
IMG_29682360×3260 3.58 MB

IMG_2969
IMG_29694032×3024 2.3 MB

IMG_2970
IMG_29704032×3024 1.78 MB

IMG_2971
IMG_29714032×3024 1.96 MB

4

Thanks for sharing the screenshots.
So you have your data type “QuestionTheme” to store questions related to themes.
in your “RG-QuestionOUT”, you can set the Data Source = “Do a Search for Questions Where Unique ID isn’t in Do a Search for QuestionTheme:each items’Questions’Unique ID Where ParentTheme = “Dropdown Choix de Thème’s value” "

Hope this helps !

5

Hello,
Thanks for your Help, I have a Little problem

I did the édit on the wrong group but its the same)

image
image4032×3024 2.1 MB

6

So the result is what you expected ?

7

Yes Thanks a lot !
Could you explain me where I can find how is it works ?
I dont wanna ask Help 24/24 here :slight_smile:

Thanks a lot !!!

8

This topic was automatically closed after 70 days. New replies are no longer allowed.