InfoQube IM - Community

Submitted by jan_rifkinson on 2012/04/13 11:37

Examples:

If user creates a new item in IQ then <CTRL>K to add URL, link to browser is created that opens directly to the linked page
If user drag / drops URL to create a new item in IQ. When user clicks on it windows opens display asking which program to use.
If user drag / drops URL to create new item in IQ but elects "no hyperlink" the linked data opens in HTML pane
In none of the 3 situations does the following equation work.

My guess is #3 doesn't work because equation calls for link in item but I don't understand #1 & #2 where a link is created.

Finally I'm wordering if the equation can be changed to the following so any data in HTML pane will produce an icon consistently:

AM: icon=AddKeyword(Icon,"<img,HTML</img>) |

E:Icon=RemoveKeyword(Icon, "<img>link</img>">

Comments

#1,2,3 : everything you describe depends on other options.

Here's what happens here

#1 : link opens in browser (firefox in my case)

#2 : link opens in browser (firefox in my case)

#3 : link "content" doesn't appear anywhere because I haven't selected the option to show content in HTML pane. Which you probably have done (you can select that option in the dialog at the bottom right)

As for the equation not working, it depends what kind of link you're creating. If you want the "link" icon to appear in all cases, you will need to put the equation in a few fields. Probably in "FileRef", itemHTMLFile (there you,d probably want to filter out all links which aren't URLs), and even... Item. Although this isnt recommended.

If the equation/autoassign isn't working at the moment in case #1, it's probably because there's either a) a syntax error or b) it's in the wrong field.

The equation you wrote there wouldn't do anything. However the one in the screenshot should work providing something gets added in the itemHasURL field. Strangely I don't that field in my DB. It probably got added along the way...

--------------------------------------------------------------------------------

Windows XP Home Edition, Service pack 3

Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz

[quote=Armando]

Strangely I don't that field in my DB. It probably got added along the way...

[/quote]

I don't have that field either, and with an ID of 264, it isn't a system field... Jan, you added this field ? How is it filled?

If it is a calculated field, auto-assign rules are never executed for these.

I should not disable those features for calculated field (calculated or "smart" fields are actually queries in the database, so they don't / can't trigger events)

Pierre,

I know one of you very clever people helped me with this project.

I don't remember who at the moment. I've attached the as it takes up too much forum space.

Really my question is based on the notion that

If the item has a URL then a link icon would appear

If the item has data in the HTML pane and 'eye' icon appears

Some items show only one icon

Some items show both icons, of course depending on the item.

This system works 100% when clipping to IQ from another source

What puzzled me is that this icon system did not work with drag / drop even if item had URL

That was really my fundamental question.

Hope this information helps you and Armando understand my question better.

Edited 04/15/12 OK, because of Tom's post, now we know that Pierre is the smart culprit. Is it more possible to answer my question at this stage? Why can't I have an equation for ItemHasHTML to trigger one icon & the fact the URL is stored in field -- shouldn't that trigger the the 2nd icon?

Thanks.

Edited 04/18/12 Pierre, I'm wondering if you could address this for me. The reason is that I'm lacking a visual consisentency in my dB which I'd like to correct.

When I copy data via clipboard, my icons appear properly

When I drag / drop to the grid, i.e. static link, see data in HTML pane, icons don't appear.

I think the original equation relies on a URL and I'm wondering if there's a way to amend, update it to include the situation I'm describing. If I'm not being clear, let me know. Thanks.

Yes I forgot that in my explanation...

So : c) if it's a "calculated field", the auto-assign won't be triggered.

Concerning the itemHasUrl field : don't where it comes from, but from Jan's screenshot, it definitely comes from a coder understanding SQL quite a bit. :)

--------------------------------------------------------------------------------

Windows XP Home Edition, Service pack 3

Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz

from ItemHasHtml

[quote=Pierre_Admin]

Hi Jan,

You can create a DB generated field that will function the same as ItemHasHTML but for the URL field:

Create a new yes/no field
Name it ItemHasURL
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>
Click Save

[edit] The Options textbox should wordwrap, but it doesn't (it used to...). I'll fix this in the next release

[/quote]

Ah ! there you go. :)

--------------------------------------------------------------------------------

Windows XP Home Edition, Service pack 3

Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz