target list with more than 10 entries only shows first 10

[kdbict]

Hi
Versions
sugar 6.0.2 (Build 4217)
SQL 2008
IIS 7
PHP php-5.3.3-Win32-VC9-x86.msi
windows SBS 2008
New install.

I have a target list with more than 10 target entries in it (12 in all). I can see that it has a second page (1 -10 of 12) but when you click on the arrow for more entries the list is empty.
If I sort the target list in reverse alphabet I can see the missing entries - BUT cant see the first two entries....
If I look at the target entries I can see all the targets (i.e. not in target lists view but in the targets screen).

any help much appreciated.
thanks
Kelvin

[robertbmirth]

Target lists currently have a 'bug' where you can relate them to a record but if you set up the relationship wrong the records won't display. You can relate a target list to either a target, lead, or contact, but internally sugarcrm stores all these relationships in one table called prospect_lists_prospects. This is slightly different than how normal relationships work - generally there is a different table for every relationship. This difference can sometimes create errors if you make relationships with a module type and define it as another module type. This commonly occurs in SOAP as you can only relate a target list to a target (or, a prospect list to a prospect, same thing). You also might be able to set up a relationship to a deleted entry, which would have the same result, but I'm not sure, so don't quote me on that.

This could be what's happening.

To check you'll have to find the two records in your database that aren't showing up and determine if their relationship is set correctly.

[kdbict]

Hi
thanks very much for your reply.
I may be misunderstanding your post - or I am not clear in mine so;
when I create the target in the target list the number of targets in the target list increments. However when I show the "next page" of targets I get a "no data" responce.

Now the targets seem to be related to the target list ok - if I sort the target list differently (say reverse alphabetically) I do see the targets in the first page - but now the targets at the other end of the list dont show on page two.

Is the behaviour above the same as you mean in n your post?

Hmm still not sure I'm explaining corretly - so here is an example;
target list named "audit"
targets;
alpha
bravo
charlie
delta
echo
foxtrot
golf
hotel
india
juliet

on the target list page I can see targets alpha to hotel and can see that I have 2 more targets on page two.
I click on page 2 of my list and I get "no data"

If I now sort the target list - targets window by reverse alphbet order I can see Juliet to charlie and can see that there are two more targets on page 2.
I click on page 2 and get "no data"

so the targets seem to be realted to the target list fine - it is just the displaying of them in the target list screen thats an issue.

Other windows with multiple pages display pages past page 1 fine - it is just in targetlists.

bit of a noob - so if you did answer my question and I just didnt get it then I apologise...... if it is a bug I guess it will be fixedx in a later version?
cheers
Kelvin

[kdbict]

Hi
has anyone else had this? it is creating havoc with my lists and would really appreciate any answers.
thanks
Kelvin

[kdbict]

Hi - any one? I still have this issue and cannot find a way forward on it.
please help!

[kdbict]

Wow no one watches these then? or am I the only one with the issue? it still wont go away..... guess we will have to live with it - bugger - was going to use this as part of our product stack for SMB's but with this level of support it seems dodgy (I know I could pay - but thought the community would help with issues so was having a crack at the free version).

hmmmmmm