Home › Forums › Modern DFFS › Vlookup filter not working
- This topic has 10 replies, 3 voices, and was last updated 5 months ago by Alexander Bautz.
-
AuthorPosts
-
-
April 8, 2024 at 09:50 #37635
Hi alexander, i am facing a problem with vlookup filter!
I am using the following filter: DemandeId eq ‘[[fieldValue:_vLookupID]]’ where i created a _vLookupID column in the parent list and DemandeId column in the child list with a prefill value! DemandeId value and _VLookupID value are the same! If i click on edit without the filter all items are displaying, but when i insert the filter i am receiving the following message: There are no items matching this query.
Also to note that filter was working normally before updating DFFS version. -
April 8, 2024 at 18:10 #37636
Hi,
Can you attach (or email me) some screenshots of the vLookup configuration for the filter and the prefill, and of the parent and child items so I can verify the _vLookupID and DemandedId is the same.Also include the version of Modern DFFS you are using.
Alexander
-
April 9, 2024 at 06:50 #37637
i will send them by email since we can’t upload a zip file here and no more than 4 files allowed
- This reply was modified 8 months, 2 weeks ago by Bernard Sawma.
-
April 9, 2024 at 14:58 #37639
Hi,
I looked at the attachments and because it works in NewForm, but not in EditForm I’m wondering if there are any differences in the filter in the vLookup configuration for this vLookup in your NewForm and EditForm?Alexander
-
April 9, 2024 at 15:03 #37640
Sorry, I didn’t notice that you had sent both images already. I’ll have to do some tests to see if I can reproduce it.
Alexander
-
April 9, 2024 at 15:24 #37641
I have tested and cannot reproduce the behavior.
If you open the “Test” list item in your Parent list you should see the items from the Child list items where “DemandedId” is matching the _vLookupID in the parent item.
Which parent item is your screenshot “Edit item (filter not working).png showing?
Alexander
-
April 9, 2024 at 17:30 #37642
i didn’t get your question! can you clarify?
also to note, that when removing the filter, all items are showing normally, so the problem is with the filter! Can we schedule a call for this issue? -
April 9, 2024 at 17:45 #37643
What I meant with my question was to know which of the “parent” items you had open in the screenshot where the “There are no items matching this query” message was shown.
We can schedule a meeting for tomorrow around this time – just email me the invite.
Alexander
-
April 9, 2024 at 17:48 #37644
thank you dear! will send you an invitation link now
-
July 26, 2024 at 17:26 #37838
Hey Alexander, I didn’t want to create a new post for this, but I am also seeing an issue with the filter for vLookup.
Here’s my setup:
– Parent list with a column labeled _DFFSID
– Child list with a column labeled _vLookupProjectID
(this is also the FIN for both columns, I have verified that)
– In my parent list I am configuring the vLookup with the “select web” button to get the website and then selecting the child list in the dropdown.
– In the filter I have the following: _vLookupProjectID eq ‘[[fieldValue:_DFFSID]]’
– I save the editor and go to the actual form and it’s telling me “Column ‘_vLookupProjectID’ does not exist. It may have been deleted by another user.”
– Note that in the “build the table” and “add new item” tabs I am able to select _vLookupProjectID in dropdowns to build the table and prefill the form, so it’s a valid column
– If I change the filter to use Title instead of _vLookupProjectID then it works perfectly fine. I don’t get it.My hypothesis is that it’s related to the leading underscore being the problem. My theory lies in the fact that I created a different column that didn’t lead with the underscore, but the rest was the exact same. So it was vLookupProjectID and that one worked as well.
I have the latest version of modern DFFS installed. Take a look and tell me what you think.
-
July 26, 2024 at 18:29 #37840
If the field starts with underscore you must prefix it with OData_ like this:
OData__DFFSID OData__vLookupProjectID
Alexander
-
-
AuthorPosts
- You must be logged in to reply to this topic.