Passing DataList Filters to an EditDataForm

Ernest Noa

Is it possible to pass filters applied to a DataList to an EditDataForm?


I have an edit form with two nested collections, this allows bulk entry of data rapidly. It roughly mirrors the presentation of a DataList on the previous \\ parent page. This is working pretty well.


I have been asked to try and pass the filters applied to the corresponding data list on the a parent page to my EditDataForm with nested collections.


Suggestions? Anywhere I can read up on this if it is possible.


Many thanks,


Ernie

Joseph Styons

Hi Ernest,

Just select the parameters as hidden columns in the datalist itself, then pass those fields into the edit form as a parameter.

If you have lots of parameters, you might consider lumping them all into a single block of XML (again, hidden from the end user) and using that as your parameter.

Keep in mind that although forms usually accept guids as their parameter, that doesn't have to be the case.

You can define your @ID parameter as an nvarchar(max) and stuff whatever you want in there.


Hope this helps!

Joseph Styons

https://www.styonssoftware.com

Ernest Noa

Thanks. I'll give this a shot.


Ernie

Ernest Noa

I think I understand what you are saying, bundle or package all my parameters together (perhaps as XML) in a single hidden field, and then pass that into my form as the parameter, unpack it and go.


Unfortunately, I have not gotten too far with trying this. I assumed I was looking at a datalist as the jumping-off point, but it appears to be a query view and view data form. I'm not sure how to access the built-in filtering in this query view to put it somewhere. Perhaps I can't apply the same plan with a query view. I have spent the day re-reading documentation on queryviews and have not found anything helpful yet.


Thanks again for taking the time to offer a possible solution. For now, I will keep reading and researching.


Sincerely,


Ernie

Ernest Noa

So, in my mind, step one is to find out if I can get the settings for the filters applied to a query view as highlighted in the image above and do something with them, ultimately pass them to an edit data form. If I can't programmatically access this and put it somewhere I think this is a non-starter.


Based on this, it sounds like I should be able to influence filters using a UI Widget, maybe? Not sure.

https://www.blackbaud.com/files/support/guides/infinitydevguide/infsdk-developer-help.htm#../Subsystems/infquery-developer-help/Content/InfinityQuery/coParameterSectionSample.htm?TocPath=Query|Code%20Samples%20for%20Infinity%20Query|_____3


https://www.blackbaud.com/files/support/guides/infinitydevguide/Subsystems/infquery-developer-help/Content/InfinityQuery/coListBuilderElementParameterSectionElement.htm


Just trying to figure it out. If this were a straight C# or VB app, no problem, but I'm a bit stuck here.


Thanks,


Ernie