Browser Forms

Re: qRule Repeating Table..

tyty4u2 — Thu, 07 Feb 2013 03:25:49 GMT

I hate to hijack this thread but I see it is pretty old but relates to what I am trying to do. The sample.xsn you uploaded Hilary is what I am trying to do EXCEPT, I am trying to set the values in a repeating table. I don't care if one button copies all the values to a repeating table, or if there is a button in each row I have to click to populate that patricular row.

My original post is: http://www.infopathdev.com/forums/p/25053/86819.aspx#86819

Thank you!

Re: qRule Repeating Table..

Hilary Stoupa — Tue, 14 Dec 2010 16:17:06 GMT

Hey, Chris -- what did I miss in your previous post? There are a lot of questions in this thread, but some of them it seems you have resolved on your own prior to someone being able to respond. Can you let me know what your outstanding questions are and I can try to address them? Thanks!

Re: qRule Repeating Table..

cnorris — Tue, 14 Dec 2010 15:33:05 GMT

Can someone address the previous post please?

Re: qRule Repeating Table..

Hilary Stoupa — Fri, 10 Dec 2010 20:08:05 GMT

Hi, Chris:

What logic would you base your selection off of? Would the user click a button next to that row? If you had a "copy" button in your repeating table, you could just have the user click it to set values in your main data source, no qRules required for that. I'm attaching a simple sample form. To use the sample, right click the link in the header. Save the file locally. Right click the file that you saved locally, and select "Design" to open in design mode. You can then preview the form.

As to question #3, I think what you are saying is that you want to submit back to your original SharePoint list? If so, qRules has the "SubmitToSharePointList" command that can do this.

Re: qRule Repeating Table..

cnorris — Fri, 10 Dec 2010 19:12:30 GMT

Because of the success of this search setup , i just purchased the qRules 2.4.....

I do have a few questions based on this scenario........ the text field is setup and I am using the FilterOwwsvr filter (secondary) as my repeating table. Person types in search and the repeating table returns values...... with that said:

1.) Do the qRules provide for a way to select one of the Repeating table rows? Meaning if i type in a number and it returns 3 rows of items and I want to select maybe row 2, does qRules have a way of "selecting" that row item?

2.) If #1 can be done, is it possible to then complete additional fields based on this row item selection? Additional fields would be:

Principal Investigator
Audit Phase
Audit Location
Comments

How would this be done?

3.) After completing step two, i would like to submit this to basically create a new row/column......... Is this possible? How?

Re: qRule Repeating Table..

Hilary Stoupa — Thu, 09 Dec 2010 19:36:47 GMT

I think you can do that using simple rules. I get a bit confused about which data source you talking about sometimes, but if you want to take values from the dataset returned by your owssvr.dll data connection and populate fields in your main data source, you can use rules. You'll need to use a filter to get the correct value from your owssvr.dll data source when you select the field that has the value you want.

If you are trying to populate repeating main data source fields (that is, you have 4 rows in your main data source, and you want to populate the 3rd row), you may need to use the SetValue command from qRules.

Re: qRule Repeating Table..

cnorris — Thu, 09 Dec 2010 19:25:23 GMT

Okay, I have played around with the FilterOwssvr today with basically dragging over the repeating table and doing a search to populate it...... Basically it seems to work well....... i think.

Do you recommend the pdf I describe in the last post OR do you suggest another one? Based on the search and the return of a set of data to the repeating table, I would like to select one of the rows of data from the repeating table and complete the other text fields associated with WILL be associated with row item which would be

Audit Location, Comments, date and time planned, ........

Is this possible?

Re: qRule Repeating Table..

cnorris — Wed, 08 Dec 2010 20:50:06 GMT

AWESOME. i redid everything (except I had data in the table this time FIRST) and fields did show up!. My question is i noticed that not all the fields showed up.... is that because it only (FilterOswwsv) shows fields with actual data in them? Lets say if i the next entry someone makes, and they complete more information, will the extra fields show up then?

Okay, for the filling of the repeating table, i take i need to now follow the "Copy Sharepoint List Values To Infopath Repeating Section Fields" pdf?

1.) with the first section, since i have my main data source, do i need to setup fields and groups similiar to what they describe on page 2

2.) Do I use the FilterOwssvr filter (secondary) for creating the repeating table and delete the columns i dont need? If not how is this done?

Re: qRule Repeating Table..

Hilary Stoupa — Wed, 08 Dec 2010 19:46:03 GMT

I can't see your screenshot. Can you just attach as an file under Options in a reply? What happens if your click that link you posted that shows the filtered URL -- are the results in IE what you expected?

It almost sounds as if when you first created your owssvr.dll data you didn't have any data in your list... since your schema sounds from your description not to have the fields from the list.

Re: qRule Repeating Table..

cnorris — Wed, 08 Dec 2010 19:41:14 GMT

okay....... i think we are just about there........kinda.

fixed the the command statement to what you stated.

The rule is setup on the button. I go to the main datasource and select the Protocol Title field and drag it to this view 4. I previewed form by typing "13445" in the text box and clicked the button. Nothing in the Protocol Title....... Soooooo.......

1.) I go to the FilterOwssvr (secondary) data source and notice that it does not list the fields as described in the pdf. ( i did drag the FilterOwssvr to the form and all it gave was a data text box) see image:

if you cant see the image, it is rs:data and does not list the other fields....XML tree, sub sSchema (id), sub Element Type (name, content, rsCommandTimeout), sub AttributeType (name, rs:name, rs:number.......), rs:data

dropped the error node from the QRules as requested and previewed and it did not list any errors.... played around with the other QRules - added Result to the page and it listed:

http://wssdas.intranet.dow.com/rsga/qau/_vti_bin/owssvr.dll?Cmd=Display&List={D547833E-6E44-442E-99DC-1D2A3F5C5AF4}&XMLDATA=TRUE&FilterField1=Protocol_x0020_Numbers&FilterValue1=13445

this is correct i believe because it is the same info from the Preparation setup with the "13445" i added from submitting the form previous for test data to filter on..... Also added the QRules Success and after running the search on 13445, it checked..........

so as i stated, i must be close, but i missed something......

Re: qRule Repeating Table..

Hilary Stoupa — Wed, 08 Dec 2010 18:16:08 GMT

The command would actually be:

concat("FilterOwssvr /dsname=FilterOwssvr /filter=Protocol_x0020_Numbers /value=", Study Number)

Yes, you will need to select the Study Number field using "Insert Field or Group". Put your FilterOwssvr data source on the form and preview. Enter text for the study number and click your button and see if you get results. Be sure to add the error node from the Qdabra Rules data source onto your form too, so you can see if you are getting errors on your command.

As to your error in your other post about parameterized queries -- isn't that just an informational message in the design checker?

Re: qRule Repeating Table..

cnorris — Wed, 08 Dec 2010 17:54:24 GMT

what exactly does this error mean:

The following data connections contain queries with parameters: QdabraRulesValidation........

Re: qRule Repeating Table..

cnorris — Wed, 08 Dec 2010 16:50:28 GMT

here is a screenshot of the XML: (if this image does not come out right, the line of code is

- <s:AttributeType name="ows_Protocol_x0020_Numbers" rs:name="Protocol Numbers" rs:number="57">

<s:datatype dt:type="string" dt:maxLength="512" />

For this command statement, since i am trying to apply it to the button, now looks like this:

concat("FilterOwssvr /dsname=FilterOwssvr /filter=Protocol Numbers /value=", Study Number)

I am thinking that because i am moving this rule to the button instead of the original search text field, the "." at the end, will change. I will have to do an insert field/group and select now Study Number field correct???

concat("FilterOwssvr /dsname=FilterOwssvr /filter=Protocol Numbers /value=", Study Number).

So in Summary, I have:

1.) View 4 - created a text field called "Study Number" and a button next to it called Find

2.) Applied steps 5 - 10 of the pdf including the Preparation part of the pdf to get the column name from the XML.

** i maintained the basic text fields as you stated I could do for View 1 which is using the submit data type connection (primary NOT secondary).

so now for the next step, i have created a repeating group and the returning data fields based on exact match from the above study number field are:

tmpStudyTitle, tmpDirectorName, tmpPhoneNumber, tmpProjectNumber

again, based on the exact match, i was hoping to return data to these fields. I did it this way because as i stated, in View 1, i used basic text fields for one entry.

Now inorder for me to actually see if the above steps i did, worked, i would have to publish this form first correct? Or what are your recommendations for next steps... I would like to purchase this software soon.

Re: qRule Repeating Table..

Hilary Stoupa — Tue, 07 Dec 2010 22:08:59 GMT

There is no point in running the FilterOwssvr command if the field you are searching on is blank. That is why the rule has a condition.

Yes, if you want users to use a button, the rule would go on the button.

You are going to need to find out the correct name for your column. Did you try step C on Page 2 of the PDF? Can you post a screenshot of the results so that I can help you with your column name?

Re: qRule Repeating Table..

cnorris — Tue, 07 Dec 2010 21:24:14 GMT

okay this helps out a lot but i have some questions stilll... So what we or I hope to do is do this in pieces because as you said, it is kind of overwhelming what described. Also, I keep my format the same of using basic text fields in View 1 (NOT USING REPEATING FIELDS HERE).

1.) okay i have followed the instructions of the pdf. since i am NOT using a dropdown box and a regular text box for entering data, i:

Did not do steps 1 - 4 because I am not using dropdown field.
the instructions mention creating a command dynamically. So I completed the next steps from the Preparation section of the pdf. I named this FilterOwssvr per instructions. command statement now looks like this: concat("FilterOwssvr /dsname=FilterOwssvr /filter=Protocol_Numbers /value=", .) I am a little concerned about the Protocol_Numbers. In sharepoint the column name is Protocol Numbers. I did not know whether to do a insert field or group or just type it in as I did here.
I setup the condition that field "is not blank" as instructed in the instructions. Not sure i understand this step though......
Since the user is typing in the search info, i created a button next to the field called "Find". Does the above rule need to go here and NOT on the search field itself?

lets get through this part first please.

chris