Filter data in a datasheet view from URL

Hi.

Is there any way to filter data from datasheet view directly with url?
Something like is made with dispform.aspx that we have dispform.aspx?ID=1.

I want to make something similar but I need the datasheet view because of
custom formatting, but I would also need filtering with ?ID or some other
field.

Thanks.
Boris
B4Contact

Boris
Fri Sep 24 03:05:41 CDT 2004

Hi. Sorry for the disturbance. Found it!

http://support.microsoft.com/?id=831093

Works like a charm!

Boris
B4Contact
www.b4contact.com

"Boris Gomiunik" <kitara(remove)man(again)@hotmail(dot)com> je napisal v
sporoèilo news:O2Y5oggoEHA.132@TK2MSFTNGP14.phx.gbl ...
> Hi.
>
> Is there any way to filter data from datasheet view directly with url?
> Something like is made with dispform.aspx that we have dispform.aspx?ID=1.
>
> I want to make something similar but I need the datasheet view because of
> custom formatting, but I would also need filtering with ?ID or some other
> field.
>
> Thanks.
> Boris
> B4Contact
>

Bob
Fri Sep 24 03:17:31 CDT 2004

Boris,

I believe I have seen it done with java script but don't recall where I saw
it. If I come across it in the next couple of days, I will post it here.

Since I am not a java script guru, I found that writing a custom Web Part
that reads the query string and provides the parameters as connection data
worked well. I then connected the Web Part to a Data View Web Part and
filtered it against my custom Web Part. Your custom Web Part doesn't have
to display anything, that way no one even knows it exists on the page.

The following articles describe how to write a connectable Web Part.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/spptsdk/html/smpxTopicWebPartConnect.asp
http://www.15seconds.com/issue/040825.htm


--
--------------------------
Bob Mixon

http://www.sharepointblogs.com/bmixon
Do You Collaborate?

SharePoint University Assistant Dean
http://www.sharepointu.com
===============================


"Boris Gomiunik" <kitara(remove)man(again)@hotmail(dot)com> wrote in message
news:O2Y5oggoEHA.132@TK2MSFTNGP14.phx.gbl...
> Hi.
>
> Is there any way to filter data from datasheet view directly with url?
> Something like is made with dispform.aspx that we have dispform.aspx?ID=1.
>
> I want to make something similar but I need the datasheet view because of
> custom formatting, but I would also need filtering with ?ID or some other
> field.
>
> Thanks.
> Boris
> B4Contact
>
>

Bob
Fri Sep 24 03:18:52 CDT 2004

Very cool -- now I also learned something new tonight!
Thank you very much. :)

--
--------------------------
Bob Mixon

http://www.sharepointblogs.com/bmixon
Do You Collaborate?

SharePoint University Assistant Dean
http://www.sharepointu.com
===============================


"Boris Gomiunik" <kitara(remove)man(again)@hotmail(dot)com> wrote in message
news:OBBCp1goEHA.1992@TK2MSFTNGP09.phx.gbl...
> Hi. Sorry for the disturbance. Found it!
>
> http://support.microsoft.com/?id=831093
>
> Works like a charm!
>
> Boris
> B4Contact
> www.b4contact.com
>
> "Boris Gomiunik" <kitara(remove)man(again)@hotmail(dot)com> je napisal v
> sporoèilo news:O2Y5oggoEHA.132@TK2MSFTNGP14.phx.gbl ...
> > Hi.
> >
> > Is there any way to filter data from datasheet view directly with url?
> > Something like is made with dispform.aspx that we have
dispform.aspx?ID=1.
> >
> > I want to make something similar but I need the datasheet view because
of
> > custom formatting, but I would also need filtering with ?ID or some
other
> > field.
> >
> > Thanks.
> > Boris
> > B4Contact
> >
>
>

Mike
Fri Sep 24 04:24:30 CDT 2004

It's been listed in the WSS FAQ since the third of March and if you had
searched the WSS FAQ with "filter" it would have been your fifth hit (and
thus on page one)

Search the KB article section alone and it's the second hit of three.

[Just for future reference]

Mike Walsh, Helsinki, Finland
WSS FAQ at http://wss.collutions.com
Please post questions to the newsgroup only.


"Boris Gomiunik" <kitara(remove)man(again)@hotmail(dot)com> wrote in message
news:OBBCp1goEHA.1992@TK2MSFTNGP09.phx.gbl...
> Hi. Sorry for the disturbance. Found it!
>
> http://support.microsoft.com/?id=831093
>
> Works like a charm!
>
> Boris
> B4Contact
> www.b4contact.com
>
> "Boris Gomiunik" <kitara(remove)man(again)@hotmail(dot)com> je napisal v
> sporoèilo news:O2Y5oggoEHA.132@TK2MSFTNGP14.phx.gbl ...
> > Hi.
> >
> > Is there any way to filter data from datasheet view directly with url?
> > Something like is made with dispform.aspx that we have
dispform.aspx?ID=1.
> >
> > I want to make something similar but I need the datasheet view because
of
> > custom formatting, but I would also need filtering with ?ID or some
other
> > field.
> >
> > Thanks.
> > Boris
> > B4Contact
> >
>
>

Ian
Fri Sep 24 06:20:53 CDT 2004

That's how I do my redirect page at http://www.wssdemo.com/redir.aspx?url=
The url value is the ID of a Links list and the DVWP filters on this.

Regards,
Ian
"Bob Mixon" <rmixon1@socal.rr.com> wrote in message
news:ub0Ki8goEHA.1576@TK2MSFTNGP12.phx.gbl...
> Very cool -- now I also learned something new tonight!
> Thank you very much. :)
>
> --
> --------------------------
> Bob Mixon
>
> http://www.sharepointblogs.com/bmixon
> Do You Collaborate?
>
> SharePoint University Assistant Dean
> http://www.sharepointu.com
> ===============================
>
>
> "Boris Gomiunik" <kitara(remove)man(again)@hotmail(dot)com> wrote in
> message
> news:OBBCp1goEHA.1992@TK2MSFTNGP09.phx.gbl...
>> Hi. Sorry for the disturbance. Found it!
>>
>> http://support.microsoft.com/?id=831093
>>
>> Works like a charm!
>>
>> Boris
>> B4Contact
>> www.b4contact.com
>>
>> "Boris Gomiunik" <kitara(remove)man(again)@hotmail(dot)com> je napisal v
>> sporoèilo news:O2Y5oggoEHA.132@TK2MSFTNGP14.phx.gbl ...
>> > Hi.
>> >
>> > Is there any way to filter data from datasheet view directly with url?
>> > Something like is made with dispform.aspx that we have
> dispform.aspx?ID=1.
>> >
>> > I want to make something similar but I need the datasheet view because
> of
>> > custom formatting, but I would also need filtering with ?ID or some
> other
>> > field.
>> >
>> > Thanks.
>> > Boris
>> > B4Contact
>> >
>>
>>
>
>