Newbie Questions

Re: how to use owssvr.dll

Alec Pojidaev — Tue, 31 Mar 2009 18:54:39 GMT

When I was in the similar situation I've created additional column and populated it from a workflow. Workflow allows to do complex logical computations so I was able to filter by that column.

There is also posibility (which maybe even better) of creating calculated column. In the column expression you could calculate FilterField1=FieldName&FilterValue1<>Value pretty easy.

Re: how to use owssvr.dll

CraigW — Tue, 31 Mar 2009 09:12:42 GMT

Hi,

I have read the post but I don't see anything in there that allows me to select exactly what I want.

I can easily use FilterField1=FieldName&FilterValue1=Value but how do I say FilterField1=FieldName&FilterValue1<>Value to get a 'not equal to'?

From what I have seen, that can only be done by posting a CAML query, but I cannot find how to do that from infopath VSTA code.

Thanks,

Craig

Re: how to use owssvr.dll

Alec Pojidaev — Mon, 30 Mar 2009 14:05:54 GMT

Check that post out

http://www.infopathdev.com/forums/t/11076.aspx?PageIndex=1

Re: how to use owssvr.dll

CraigW — Mon, 23 Mar 2009 21:15:40 GMT

Hi Alec,

That would be ideal, but how could I do such a thing? I do not see a way from anything I have read.

Do you have an example?

Thanks,

Craig

Re: how to use owssvr.dll

Alec Pojidaev — Mon, 23 Mar 2009 16:58:42 GMT

CraigW:

I know I need to use CAML

Thats really not necessary. You could create supporting view and refer it as a parameter.

Re: how to use owssvr.dll

CraigW — Mon, 23 Mar 2009 16:15:44 GMT

Hi Anuma,

Thanks, I have it working now. My next problem is that I need to use < or > instead of = in the filter. I know I need to use CAML and a whole different approach though, on well!

Craig

Re: how to use owssvr.dll

Anuma — Mon, 23 Mar 2009 06:21:18 GMT

Hi,

Can you verify below links.

http://www.sharepoint-tips.com/2007/01/infopath-form-services-implementing.html
http://blogs.msdn.com/infopath/archive/2007/01/15/populating-form-data-from-sharepoint-list-views.aspx

http://www.synergyonline.com/blog/blog-moss/Lists/Posts/Post.aspx?ID=24
http://edgedev.blogspot.com/2008/09/bending-infopath-and-sharepoint-to-your.html

how to use owssvr.dll

CraigW — Sun, 22 Mar 2009 17:47:56 GMT

Hello all,

I have read on these forums that owssvr.dll will allow you to fetch all columns from a sharepoint list, but how do I use this in infopath? It does not understand the url as being a web service. Is there a tutorial I can follow?

Thanks,

Craig