Qdabra qRules

Re: QueryDB is not retrieving new field values in "existing" forms after form template was modified

Doreen — Mon, 23 Dec 2013 22:08:26 GMT

Solution to my problem was to remove a condition in finishedLoading rules that fired off only when a form was new. I removed the condition entirely, and now the new fields are happy. Thank you Ernesto for pointing that out and for the tip on finishedLoading best practices!

Re: QueryDB is not retrieving new field values in "existing" forms after form template was modified

Doreen — Mon, 23 Dec 2013 19:55:04 GMT

Yes and please. I will email it to you.

Re: QueryDB is not retrieving new field values in "existing" forms after form template was modified

ErnestoM — Mon, 23 Dec 2013 19:47:20 GMT

From what you're describing, it *should* be working. Do you want us to take a look at the form?

QueryDB is not retrieving new field values in "existing" forms after form template was modified

Doreen — Mon, 23 Dec 2013 18:51:30 GMT

A client, Infopath 2007 form uses QueryDB (qRules version 5.1) to retrieve data from existing SQL database to pre-populate the form on page load.

I added a new field to the pre-existing data fields of the form and the SQL database, then attached the modified template to DAT tool, saved, then reshredded all documents with success. The problem is existing forms (forms that are already submitted to SharePoint library via DBXL) do not retrieve the new column value and insert into the new field of form. New forms do retrieve the new column value and insert into new field of form . This behavior was happening in Design Preview mode but I’d hoped it would fix itself after reshredding the existing documents. Not so.

I did not add the new field to the DAT tool SharePoint mapping because it is not necessary to promote the new field to the SharePoint library.

Form Options Versioning is set to Automatically upgrade existing forms on version upgrade.

In QueryDB data connection, I updated GetColumnXMLStrQuery with the new column.

Is there another data connection or rule I need to update to get existing forms to update with the new column/field value when they are re-opened?