Submitted by LeftEccoForIQ on 2022/04/10 04:48

I'm considering filtering my main IQ file for items with large values for ItemTextSize, i. e. items with lots of item text, to move anything but a 'heading' or the first sentence to the HTML 'field'. Two questions:

1. Will this be worth my while from a performance / data security / stability point of view?

2. If yes, what would be a sensible value to shoot for as a maximum for item text size?

Many thanks!

Comments

Hi Left,

  1. No, item text can be any length. IIRC however, the grid does have issues when displaying more than 2000 characters per item though (wordwrap ON)
  2. 500-1000 would be a good upper (elastic) limit

Some follow-up points:

  • I've implemented a conditional formatting rule to highlight items with text size > 1000. Will try to weed them out / move content to HTML, will report interesting findings, if any.
  • I've also created a rule that highlights items that have the ItemHasHTML field checked. Strangely, this also highlights some items whose HTML box comes up completely empty in the item editor. Is there a more direct / reliable way to view their associated HTML to spot anything that might by 'hidden' from the editor?
  • By the way, as I never used to use Forms, I totally couldn't figure out how to use Column Sets. It seemed that the "Save Grid with this column set..." menu item was always grayed out, no matter what I did and I only ever got the "Native Column Set" option. Took me a while to realize that the only (?) way to create a custom column set is to first create a form, i. e. there is no direct option to create Column Sets. Maybe that could be stated more explicitly in the documentation on columns / sets.

 

Have come up against another snag:

I have an item with the Item Text "Reminder Dienst / Schule >".

Its size-related fields show the following values:

  • ItemTextSize: 6682
  • ItemHTMLSize: 7597
  • ItemHTMLTextSize: 6629

Its TextSize should really only be 26 as that's the length of the actual Item Text, right? And the number shown is the result of a bug?

Out of curiosity, as for the difference between the other two values, is the latter just the former with all HTML tags removed from the count?

Many thanks!

Okay, I get it now that ItemTextSize is probably meant to be the sum of the length of the Item Text plus ItemHTMLTextSize. So to get at the length of the Item Text when an item has HTML, I'd have to subtract ItemHTMLTextSize from ItemTextSize, right? However, that does not compute in the example above.

How do I ?