Qdabra qRules

Re: Filter items with toggle btn

Marzipan — Thu, 17 Jun 2010 20:23:08 GMT

Found a solution:

http://office.microsoft.com/en-ca/infopath-help/show-or-hide-rows-in-a-repeating-table-by-using-conditional-formatting-HA010033885.aspx

When DisplayMode=1 and status="Completed" or status="Deferred" Hide control.

Re: Filter items with toggle btn

Marzipan — Thu, 17 Jun 2010 19:37:05 GMT

correction: Condition would be DisplayMode=1 (Open Items)

Re: Filter items with toggle btn

Marzipan — Thu, 17 Jun 2010 19:22:32 GMT

Add a rule that set the condition "status" neq "Completed"

What would the action be?

Re: Filter items with toggle btn

Patrick Halstead — Thu, 17 Jun 2010 19:08:27 GMT

Hi Marzipan,

Why not just add a rule on the repeating group node that conditionally hides based on a child field's value?

Re: Filter items with toggle btn

Marzipan — Thu, 17 Jun 2010 17:48:20 GMT

I'd rather display subsets of the items in the main data source.

Re: Filter items with toggle btn

ErnestoM — Thu, 17 Jun 2010 17:31:10 GMT

If I understand this correctly, I would configure two data connections. The results of each data connection query can be displayed in two separate sections. Then, depending on the toggle selected by the user, you can show/hide the sections.

Does this help?

Filter items with toggle btn

Marzipan — Thu, 17 Jun 2010 15:27:44 GMT

I have a form that queries items from a sp task list and allows the user the edit the status and comments.

I was filtering the query to not show item with status of "completed" or "deferred" on form load.

A request has been made to be able to toggle btw "AllItems" and "OpenItems"

I have added a button that toggles these values in a "displayMode" field.

What qRules should I create to filter the items displayed from the main data source and refresh when the button is toggled?

Someone have an example?