Views

Re: filter data

kevin_carter — Tue, 03 Jun 2014 20:29:50 GMT

i have a list in sharepoint containnig operation numbers ie op 20 , op 30

in infopath i have created a form (search) that displays the operations in the listbox(op_num) and a button that runs a rule

i have create a view that i want to display the reults of the query

so on the search form the user would select an operation ie op 20 then click the button the view would change to reults form displaying only op 20 data

the rules i have set up are

query the the data connection.

Action = set fields value

Field = Op_num

Value = Operation [.=Op_num]

problem is this is returning all the values

any ideas

kevin

Re: filter data

jun_barbosa — Mon, 02 Jun 2014 05:21:39 GMT

Hi Kevin, Do you mind attaching the form so i can take a look? cheers!

filter data

kevin_carter — Sat, 31 May 2014 00:42:48 GMT

Hi everyone,

i know i asked this before but i am trying it with sharepoint now instead of SQL

i am new to using infopath, but trying to get my head around it.

i have create a form the user enters data into, the form can not be completed by the creator, this means another user has to open the form to enter data into it.

what i have done is create several listboxs is name, department and request. so when department is selected it returns only the names that work in that department and when the name is selected it returns the requests made by the user.

this is working fine

What i want to do is use a button to filter a sharepoint list with the results of the selections and change to a view diplaying the results on the form.

i have tried using rules but am strugling to return the correct results (i always return the all the record on the list)

does anyone know if this can be done ? i prefer not to use code if possible

thank you for your time

Kevin