Submitted by jan_rifkinson on 2009/02/16 08:50
I'm assuming ItemHasHTML is hardcoded. If I create a field 'ItemHasURL' & give it the same properties it does not function the same way.
 
--
Jan Rifkinson
Ridgefield CT USA

Comments

Hi Jan,
 
You can create a DB generated field that will function the same as ItemHasHTML but for the URL field:
  1. Create a new yes/no field
  2. Name it ItemHasURL
  3. In the options panel, enter:
    <source>SELECT ¯Items.ID AS ItemID, [ItemHasURL] AS [Value], [¯qURL.ID]>0 AS ItemHasURL FROM ¯Items LEFT JOIN ¯qURL ON ¯Items.ID = ¯qURL.ItemID WHERE (((¯qURL.ID) Is Not Null));</source>
  4. Click Save
 [edit] The Options textbox should wordwrap, but it doesn't (it used to...). I'll fix this in the next release

jan_rifkinson

2009/02/16 10:02

Permalink

Glad to see you are feeling better :-) And thanks.  In a million years I wouldn't have figured out that one on my own.
 
--
Jan Rifkinson
Ridgefield CT USA
HP Blackbird Vista Ultimate SP-1

Tom

2009/03/18 16:53

Permalink

[quote=Pierre_Admin]You can create a DB generated field that will function the same as ItemHasHTML but for the URL field:
  1. Create a new yes/no field
  2. Name it ItemHasURL
  3. In the options panel, enter:
    <source>SELECT ¯Items.ID AS ItemID, [ItemHasURL] AS [Value], [¯qURL.ID]>0 AS ItemHasURL FROM ¯Items LEFT JOIN ¯qURL ON ¯Items.ID = ¯qURL.ItemID WHERE (((¯qURL.ID) Is Not Null));</source>
  4. Click Save[/quote]could you add this field to default new file?