Page 1 of 1

Related Items Not Filtering Correctly

Posted: 09 Nov 2018
by YumaIT
Hi,

I followed the instructions on the following page to add a related items table to my form.

https://spform.com/documentation/relate ... gular-mode

I did this on both the Edit Form and the Display Form of the same list. The filtering is working on the Edit Form
Edit.PNG
Edit.PNG (123.91 KiB) Viewed 2360 times

However, the filtering is not working on the Display Form
DisplayCapture.PNG
DisplayCapture.PNG (117.9 KiB) Viewed 2360 times

One other issue. I noticed on the Edit Form that the related items is in Quick Edit Mode. I set the property to "None". Do you know why this may be happening?
RelatedItemsProperties.PNG
RelatedItemsProperties.PNG (46.41 KiB) Viewed 2360 times

Thank you.

Re: Related Items Not Filtering Correctly

Posted: 12 Nov 2018
by AlexZver
Hi!

1) Check your Display Form settings, the Data Source of the related items should be configured just like on Edit Form. Do not forget, that forms can be saved separately
Screenshot_97.png
Screenshot_97.png (15.35 KiB) Viewed 2355 times
2) Have you saved your form after changing Quick Edit property? Please save your forms again, wait 5-7 seconds until success message appears and try again.

Re: Related Items Not Filtering Correctly

Posted: 23 Dec 2018
by YumaIT
Hi,

I checked my Data Source properties and they are identical. See below.

Display Form Data Source Properties
DataSourceDisplayProperties.PNG
DataSourceDisplayProperties.PNG (47.05 KiB) Viewed 2325 times
Edit Form Data Source Properties
DataSourceEditProperties.PNG
DataSourceEditProperties.PNG (47.36 KiB) Viewed 2325 times

From a Javascript perspective I double-checked the code to make sure that the relevant code is identical as well. However, there are differences in the overall code base due to the functionality of the HelpDesk Application. I'm not sure if that makes a difference but I pasted it below. Can you please advise on what I can look at next or if you have something else for me to try.

Here is the relevant code.

Display Form Javascript
fd.populateFieldsInGrid($('.related-items'), {
Ticket: '{CurrentItem}',
});

SP.SOD.executeOrDelayUntilScriptLoaded(function() {
var ticketDisplayForm = new Plumsail.HelpDesk.Forms.Tickets.DisplayForm({
rootElement: document.getElementById('fd_form'),
ticketId: GetUrlKeyValue('ID'),
});
}, "plumsail.helpdesk.js");

Edit Form Javascript
fd.populateFieldsInGrid($('.related-items'), {
Ticket: '{CurrentItem}',
});

fd.conflictResolutionMethod(Plumsail.FD.ConflictResolutionMethods.override);
SP.SOD.executeOrDelayUntilScriptLoaded(function() {
var editForm = new Plumsail.HelpDesk.Forms.Tickets.EditForm({
rootElement: document.getElementById('fd_form'),
ticketId: GetUrlKeyValue('ID'),
formsDesigner: fd,
validateAssignTo: true,
requesterField: fd.field('Requester').control()._el().parent(),
debug: true
});

Plumsail.HelpDesk.FileAttachValidation.start();
}, "plumsail.helpdesk.js");

Re: Related Items Not Filtering Correctly

Posted: 27 Dec 2018
by AlexZver
Hi!

I'm sorry for a late reply.

I've done some research and I couldn't reproduce your issue. Could you please try to add this related items control on a brand new list? Does the issue still exist?