InfoQube IM - Community

Submitted by d bartlett on 2011/12/17 17:30

Hi, howcome when I add a standard text field to a grid, like AddressBook, none of the field text data is displayed in the resulting column? version 0.9.25W3. I'm sure it's a simple answer but I've been at this for well over an hour now so it's time to ask the quesiton. thanks. Doug Bartlett

Comments

Can you reproduce the steps in a sample IQBase and report them here, as it is working when I try it.

Thanks

Pierre

Doug, You most probably know this already but.....

Are you actually adding the field "AddressBook" which already has items in it or have you created a text field for this view and named it "AddressBook" in the hopes that it would display "AddressBook" data, i.e.are you creating a new text field & naming it "addressbook"?

To populate AddressBook TLI's your view source has to be the actual / original AddressBook field which you select from the existing field list. If you do that all your items should be in the "addressbook".

You can look @ the properties of any item you think should be in the "ADDRESSBook" and see if it is assigned to that field; i.e. is it checked. If it isn't, it won't show up.

HTH

thanks. But the best I can explain it is that I am attempting to add the field "Client" which contains 91 text items to the "AddressBook" grid. When from within the AddressBook grid I execute Add/Remove Columns > Select Field To Display, and select the field "Client", I get the resulting Client column in the AddressBook grid but none of the Client field text data in the Client column. (I attempted to load an image into this post illustrating that, but every time I click the insert/edit image icon an edit box pops up and then this web page freezes - kind of a frustrating day as it turns out). BUT IF, while in AddressBook grid I select Client instead of AddressBook from the left-most filter box in the Source Bar, THEN the Client column data shows BUT the rest of the AddressBook columns go blank. (I had wanted to post an image of that too, but can't). Anyhow . . . this is after about 4 more hrs working on it. I have tried absolutely everything I can think of - in Properties and Forms and Filters - and truly don't understand what else can I can do, I don't recall having had this issue in the past, it's alway been a straightforward exercise. Unrelated, but I also notice the Forms dialogue box no longer attaches as a pop-out box to the edge of the screen the way it used to, the way HTML and Properties boxes still do, can only access it via Tools > Mangage Forms now. Anyhow . . . thanks.

Doug Bartlett

It seems to me that your items that have something in the field "Client" (which you viewed by setting the source to "Client") are not in the address book (i.e. don't have the AddressBook field checked.)

To quickly put these in the address book, simply select all of them and in the Properties Pane, check the field "AddressBook"

Concerning the Manage form, it is now a modal dialog (as opposed to the way it was before, non-modal docking style).

HTH !

Pierre, I think I attempted that on a few of the individual Client items and it produced duplicate entrys in the AddressBook, but I will try your suggestion again in the next few days and let you know how it works out. Sorry about the weekend whine, there was no need for that. Merry Christmas and a Happy New Year to you and yours.

Doug Bartlett

[quote=d bartlett]

Doug Bartlett

[/quote]

Doug -

[1] be careful with (apparent) duplicate entries - I say "apparent" because they are the same item displayed twice, they are not copies of the items - i.e. if you delete one you delete both.

It sounds like some (or all) of the items are aready sub-items of the top-level-items in the Address grid (?) - under certain settings these items show twice (maybe someone else could give a tip there about what settings to change to stop this happening - changing hierarchy view?)

[2] Re the items that already show in the Address grid - should these items have information in the Client field? (if so, is that info being displayed or not?)

Tom

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

Win 7 Pro 64bit ~ Portable IQ 0.9.25.W4

Echoing what Tom said.

- The easy way to know for sure if items are truly duplicates or not is to check their ID (what I usually do is to keep the HTML pane in hidden mode -- it's there but you only see the tab : the HTML pane's tab always shows the Iditem value)

- If you happen to find out that these seemingly duplicate items are in fact the same items but displayed twice, then you should :

a- first check out your display options (Full Hierarchy should be your best bet if you don't want items meeting the source to reappear as TLI when they are already children of other items)

b- second, if that doesn't fix the issue (there's a bug in hierarchy display, when sub-subitems also meet the source), maybe create a Boolean (Yes/No) field named NotTLI (e.g.) which you can check for those items you don't want to appear as TLIs. Then add this little query to your grid filter (in the source bar): NotTLI is null (this will filter out from the Top Level position all those items you don't want to see there).

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

Windows XP Home Edition, Service pack 3

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

Armando, Tom, Doug

Would it make any sense to have the duplicate item, i.e. a copy not the same item with different parents represented differently.

I'm thinking maybe a different font or different color font or something that would visually identify it instead of having to compare item ID's

[quote=jan_rifkinson]

Armando, Tom, Doug

Would it make any sense to have the duplicate item, i.e. a copy not the same item with different parents represented differently.

I'm thinking maybe a different font or different color font or something that would visually identify it instead of having to compare item ID's

[/quote]

One thing that would help is just to allow us to add the ItemID column - unhide ItemID column [solved].

I also think we need refactor the hierarchy, parents, children, and filters options to be clearer and less overlapping along the lines of http://www.sqlnotes.net/drupal5/index.php?q=node/1965#comment-11524. With that it would be easy to give a simple menu choice that would remove repeats, meaning everything left would be duplicates.

[quote=reesd]

One thing that would help is just to allow us to add the ItemID column - unhide ItemID column [solved].[/quote]

If you are referring to ID Item, this is currently possible. Select any item, look under item properties. If ti's there you can add the column under manage fields or add/ hide column.

However, my suggestion was to work in addition to ID Item as a visual cue

Hi Doug,

Did you fix your problem ?

[quote=d bartlett]

Doug Bartlett

[/quote]

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

Windows XP Home Edition, Service pack 3

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

[quote=d bartlett]

...

(I attempted to load an image into this post illustrating that, but every time I click the insert/edit image icon an edit box pops up and then this web page freezes - kind of a frustrating day as it turns out).

...

(I had wanted to post an image of that too, but can't).

...

[/quote]

Without the ability to share images/videos its very hard to diagnose IQ issues with filtering. I think there are things we can do in IQ to fix that (and mention link to them in the other post), but in the meantime you need to find a way to share pics videos. Some thoughts....

Just attach the image (click on file attachments across the bottom). Then you really are not dealing with the editor (which I agree can be trick, especially in certain browsers). It's not embedded, but its an easy click for folks to view.

Or even better, use Jing (http://www.techsmith.com/jing.html) which will let you do both screenshots and videos easily. It will let you select the area, then upload it to their own servers, and give you an URL you can post here. You can turn it off when you are not using it (I do).

[quote=d bartlett]

...

BUT IF, while in AddressBook grid I select Client instead of AddressBook from the left-most filter box in the Source Bar, THEN the Client column data shows BUT the rest of the AddressBook columns go blank.

...

[/quote]

I agree with others, your items with Client data are probably different from your items with AddressBook data.

Rather than checking with duplicates, just bring up the property pane and look at some of these items. You can bring up properties using F4. Then under values you can see all of an item's values including ItemID. So check if the item really has both values (if the source box is "AddressBook" and you select one of the items with a blank "Client" field is Client listed in the values)?

Note, you can change your source box to "Client OR AddressBook" to see both sets of items also.