Caching on BizForm results

Mark Elliott asked on February 9, 2017 20:58

When we review and approve an item submitted through a biz form the new item does not appear on the site until the cache is expired\cleared. Is caching different for BizForm items? Because when regular content is approved and published it instantly appears on the site.

biz form cache

Correct Answer

Brenden Kehren answered on February 10, 2017 17:05

Then in the custom query repeater properties in the Performance section, set the Partial Cache Minutes to 0 otherwise it will cache with the rest of the site. Unfortunately, from a performance standpoint this stinks because it will run the query each time the page loads, but if this is what you need then this will do that.

0 votesVote for this answer Unmark Correct answer

Recent Answers

Brenden Kehren answered on February 9, 2017 22:32

Sounds as if you may be doing something a bit different with the bizform data than what comes out of the box is that a correct statement? By default, the bizform results aren't meant to be displayed on the live site.

0 votesVote for this answer Mark as a Correct answer

Mark Elliott answered on February 9, 2017 22:57

Yes I have a query against the table where the bizform results are stored to display the data on the site.

0 votesVote for this answer Mark as a Correct answer

Peter Mogilnitski answered on February 10, 2017 00:50 (last edited on February 10, 2017 00:59)

Do you see the results in Forms > YourFormName > RecordedData or when you query your form table directly in SQL?

I assume you use some sort API classes from CMS.FormEngine namespace. You might need to use some cache clearing methods like FormHelper.Clear()

0 votesVote for this answer Mark as a Correct answer

Roman Hutnyk answered on February 10, 2017 07:22

Mark, have you specified cache dependency for the web part that presents data on a page?

0 votesVote for this answer Mark as a Correct answer

Mark Elliott answered on February 10, 2017 16:11

Yes, the results appear immediatly in the RecordedData grid.

No I haven't specified any cache dependencies on the repeater that displays the data. Should I add a partial cache on customtableitem?

0 votesVote for this answer Mark as a Correct answer

Mark Elliott answered on February 10, 2017 22:32

Thanks Brenden, setting the partial cache to 0 on the repeater works! Yeah there will be a hit from running the query each time but the result set is small so it shouldn't be too bad.

0 votesVote for this answer Mark as a Correct answer