Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Wrong "My Work"

beta

Some users not see the assigned issues in to "My Work".

This is the sql of "My Work".

The "AND this.projectid in "is the problem; must not be use.

declare @p0 int,@p1 int,@p2 int,@p3 int,@p4 int,@p5 int,@p6 int,@p7 int,@p8 int,@p9 int,@p10 int,@p11 int,@p12 int,@p13 int,@p14 int,@p15 int,@p16 int,@p17 int,@p18 int,@p19

int,@p20 int,@p21 int,@p22 int,@p23 int,@p24 int,@p25 int,@p26 int,@p27 int,@p28 int,@p29 int,@p30 int,@p31 int,@p32 int,@p33 int,@p34 int,@p35 int,@p36 int,@p37 int,@p38

int,@p39 int,@p40 int,@p41 int,@p42 int,@p43 int,@p44 int,@p45 int,@p46 int,@p47 int,@p48 int,@p49 int,@p50 int,@p51 int,@p52 int,@p53 int,@p54 int,@p55 int,@p56 int,@p57

int,@p58 int,@p59 int,@p60 int,@p61 int,@p62 int,@p63 int,@p64 int,@p65 int,@p66 int,@p67 int,@p68 int,@p69 int,@p70 int,@p71 int,@p72 int,@p73 int,@p74 int,@p75 int,@p76

int,@p77 int,@p78 int,@p79 int,@p80 int,@p81 int,@p82 int,@p83 int,@p84 int,@p85 int,@p86 int,@p87 int,@p88 int,@p89 int,@p90 int,@p91 int,@p92 int,@p93 int,@p94 int,@p95

int,@p96 int,@p97 int,@p98 int,@p99 int,@p100 int,@p101 int,@p102 int,@p103 int,@p104 int,@p105 int,@p106 int,@p107 int,@p108 int,@p109 int,@p110 int,@p111 int,@p112 int,@p113

int,@p114 int,@p115 int,@p116 int,@p117 int,@p118 int,@p119 int,@p120 int,@p121 int,@p122 int,@p123 int,@p124 int,@p125 int,@p126 int,@p127 int,@p128 int,@p129 int,@p130

int,@p131 int,@p132 int,@p133 int,@p134 int,@p135 int,@p136 int,@p137 int,@p138 int,@p139 int,@p140 int,@p141 int,@p142 int,@p143 int,@p144 int,@p145 int,@p146 int,@p147

int,@p148 int,@p149 int

set @p0 = 48

set @p1 = 48

set @p2 = 3

set @p3 = 7 set @p4 = 9 set @p5 = 10 set @p6 = 11 set @p7 = 12 set @p8 = 13 set @p9 = 14 set @p10 = 15 set @p11 = 16 set @p12 = 17 set @p13 = 18 set @p14 = 19 set @p15 = 20 set @p16 = 21 set @p17 = 22 set @p18 = 23 set @p19 = 24 set @p20 = 25 set @p21 = 26 set @p22 = 27 set @p23 = 28 set @p24 = 29 set @p25 = 30 set @p26 = 31 set @p27 = 32 set @p28 = 33 set @p29 = 34 set @p30 = 35 set @p31 = 36 set @p32 = 37 set @p33 = 508 set @p34 = 515 set @p35 = 523 set @p36 = 38 set @p37 = 39 set @p38 = 40 set @p39 = 41 set @p40 = 530 set @p41 = 42 set @p42 = 43 set @p43 = 44 set @p44 = 45 set @p45 = 46 set @p46 = 531 set @p47 = 54 set @p48 = 55 set @p49 = 57 set @p50 = 58 set @p51 = 59 set @p52 = 60 set @p53 = 61 set @p54 = 63 set @p55 = 64 set @p56 = 65 set @p57 = 66 set @p58 = 67 set @p59 = 68 set @p60 = 507 set @p61 = 69 set @p62 = 70 set @p63 = 71 set @p64 = 72 set @p65 = 73 set @p66 = 74 set @p67 = 75 set @p68 = 76 set @p69 = 77 set @p70 = 78 set @p71 = 79 set @p72 = 80 set @p73 = 81 set @p74 = 82 set @p75 = 83 set @p76 = 84 set @p77 = 85 set @p78 = 86 set @p79 = 89 set @p80 = 90 set @p81 = 92 set @p82 = 93 set @p83 = 94 set @p84 = 95 set @p85 = 96 set @p86 = 97 set @p87 = 98 set @p88 = 99 set @p89 = 105 set @p90 = 109 set @p91 = 111 set @p92 = 112 set @p93 = 113 set @p94 = 114 set @p95 = 115 set @p96 = 116 set @p97 = 117 set @p98 = 118 set @p99 = 119 set @p100 = 120 set @p101 = 121 set @p102 = 122 set @p103 = 123 set @p104 = 124 set @p105 = 125 set @p106 = 509 set @p107 = 510 set @p108 = 134 set @p109 = 136 set @p110 = 138 set @p111 = 139 set @p112 = 524 set @p113 = 140 set @p114 = 141 set @p115 = 142 set @p116 = 144 set @p117 = 145 set @p118 = 146 set @p119 = 148 set @p120 = 150 set @p121 = 153 set @p122 = 154 set @p123 = 156 set @p124 = 157 set @p125 = 158 set @p126 = 159 set @p127 = 160 set @p128 = 161 set @p129 = 162 set @p130 = 163 set @p131 = 165 set @p132 = 166 set @p133 = 167 set @p134 = 168 set @p135 = 169 set @p136 = 170 set @p137 = 171 set @p138 = 172 set @p139 = 173 set @p140 = 174 set @p141 = 175 set @p142 = 176 set @p143 = 179 set @p144 = 181 set @p145 = 182 set @p146 = 183 set @p147 = 184 set @p148 = 11 set @p149 = 48

SELECT this.issueid as issueid429,

this.projectid as projectid429,

this.projectcode as projectc3429,

this.typedesc as typedesc429,

this.prioritydesc as priority5429,

this.severitydesc as severity6429,

this.statusdesc as statusdesc429,

this.resdesc as resdesc429,

this.reporteddesc as reported9429,

this.versionname as version10429,

this.issuetypeid as issuety11429,

this.issuepriorityid as issuepr12429,

this.issueseverityid as issuese13429,

this.priorityseq as priorit14429,

this.severityseq as severit15429,

this.issuestatusid as issuest16429,

this.issueresolutionid as issuere17429,

this.reportedby as reportedby429,

this.fixedinversionid as fixedin19429,

this.summary as summary429,

this.longdesc as longdesc429,

this.created as created429,

this.revised as revised429,

this.issuekey as issuekey429,

this.versionnumber as version25429,

this.versiondesc as version26429,

this.versionorder as version27429,

this.versionarchived as version28429,

this.versionreleased as version29429,

this.startdate as startdate429,

this.duedate as duedate429,

this.resolveddate as resolve32429,

this.closeddate as closeddate429,

this.issuerisklevelid as issueri34429,

this.issuevotes as issuevotes429,

this.userdata1 as userdata36429,

this.userdata2 as userdata37429,

this.userdata3 as userdata38429,

this.percentcomplete as percent39429,

this.estimatedays as estimat40429,

this.estimatehours as estimat41429,

this.estimateminutes as estimat42429,

this.riskdesc as riskdesc429,

this.visibility as visibility429,

this.visibilitymembertype as visibil45429,

this.parentissueid as parenti46429,

this.tstamp as tstamp429,

comments1.IssueID as IssueID11,

comments1.commentid as commentid11,

comments1.commentid as commentid430,

comments1.userid as userid430,

comments1.issueid as issueid430,

comments1.projectid as projectid430,

comments1.comment as comment430,

comments1.username as username430,

comments1.isclosing as isclosing430,

comments1.visibility as visibility430,

comments1.visibilitymembertype as visibili9430,

comments1.created as created430,

comments1.tstamp as tstamp430,

customfiel2.IssueID as IssueID12,

customfiel2.customfielddataid as customfi112,

customfiel2.customfielddataid as customfi1291,

customfiel2.customfieldid as customfi2291, customfiel2.userid as userid291, customfiel2.projectid as projectid291,

customfiel2.issueid as issueid291, customfiel2.fielddata as fielddata291, customfiel2.created as created291, customfiel2.tstamp as tstamp291, timeentrie3.IssueID as

IssueID13, timeentrie3.entryID as entryID13, timeentrie3.entryID as entryID482, timeentrie3.projectid as projectid482, timeentrie3.issueid as issueid482,

timeentrie3.userid as userid482, timeentrie3.hours as hours482, timeentrie3.minutes as minutes482, timeentrie3.comment as comment482, timeentrie3.timeentrydate as

timeentr8482, timeentrie3.created as created482, timeentrie3.tstamp as tstamp482, affectedve6.IssueID as IssueID14, affectedve6.affectedversionid as affected114,

affectedve6.affectedversionid as affected1453, affectedve6.issueid as issueid453, affectedve6.versionid as versionid453, affectedve6.created as created453,

affectedve6.tstamp as tstamp453, versionen12.versionid as versionid34, versionen12.projectid as projectid34, versionen12.versionnumber as versionn334,

versionen12.versionname as versionn434, versionen12.versiondesc as versiond534, versionen12.versionreleased as versionr634, versionen12.versionorder as

versiono734, versionen12.versionarchived as versiona834, versionen12.created as created34, versionen12.tstamp as tstamp34, resources4.issueresourceid as

issueres1465, resources4.issueid as issueid465, resources4.userid as userid465, resources4.created as created465, resources4.tstamp as tstamp465, useren14.userid

as userid566, useren14.username as username566, useren14.firstname as firstname566, useren14.surname as surname566, useren14.pwd as pwd566, useren14.emailaddress

as emailadd6566, useren14.roles as roles566, useren14.created as created566, useren14.lastupdated as lastupda9566, useren14.ResetPWD as ResetPWD566,

useren14.active as active566, useren14.comment as comment566, useren14.tstamp as tstamp566, useren14.firstname + ' ' + useren14.surname as formula156,

components5.IssueID as IssueID_15, components5.issuecomponentid as issuecom115, components5.issuecomponentid as issuecom1477, components5.issueid as issueid477,

components5.componentid as componen3477, components5.created as created477, components5.tstamp as tstamp477, componente16.componentid as componen188,

componente16.projectid as projectid88, componente16.componentname as componen388, componente16.componentdesc as componen488, componente16.componentreadonly as

componen588, componente16.userid as userid88, componente16.created as created88, componente16.tstamp as tstamp88

FROM geminiissuesview this

left outer join

geminiissuecomments comments1 on this.issueid=comments1.IssueID

left outer join geminicustomfielddata customfiel2 on this.issueid=customfiel2.IssueID

left outer join

geminitimetracking timeentrie3 on this.issueid=timeentrie3.IssueID

left outer join geminiaffectedversions affectedve6 on this.issueid=affectedve6.IssueID

left outer join

geminiversions versionen12 on affectedve6.versionid=versionen12.versionid

inner join geminiissueresources resources4 on this.issueid=resources4.IssueID

left outer join

geminiusers useren14 on resources4.userid=useren14.userid

left outer join geminiissuecomponents components5 on this.issueid=components5.IssueID

left outer join geminicomponents componente16 on components5.componentid=componente16.componentid

WHERE

(

(this.visibilitymembertype=2 and @p0 in (select gg.userid from geminiglobalgroupmembership gg where gg.globalgroupid = this.visibility))

or

(this.visibilitymembertype=3 and @p1 in (select pg.userid from geminiprojectgroupmembership pg where pg.projectgroupid = this.visibility))

)

AND

this.projectid in (@p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20,

@p21, @p22, @p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49,

@p50, @p51, @p52, @p53, @p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62, @p63, @p64, @p65, @p66, @p67, @p68, @p69, @p70, @p71, @p72, @p73, @p74, @p75, @p76, @p77, @p78,

@p79, @p80, @p81, @p82, @p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, @p91, @p92, @p93, @p94, @p95, @p96, @p97, @p98, @p99, @p100, @p101, @p102, @p103, @p104, @p105, @p106,

@p107, @p108, @p109, @p110, @p111, @p112, @p113, @p114, @p115, @p116, @p117, @p118, @p119, @p120, @p121, @p122, @p123, @p124, @p125, @p126, @p127, @p128, @p129, @p130, @p131,

@p132, @p133, @p134, @p135, @p136, @p137, @p138, @p139, @p140, @p141, @p142, @p143, @p144, @p145, @p146, @p147)

and not this.issuestatusid in (@p148)

and resources4_.userid in (@p149)

lomi
· 1
lomi
Replies (9)
helpful
0
not helpful

Can the users view the missing issues?

Please make sure that security allows them to view the missing projects


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

1) yes

2) the project visibility is ok

Have you analyzed the "AND this_.projectid in" ?
In this "in" there is not a project: projid 502. But the user has visibility.

userid 48 of our db

see our db download infos from this email

From: LOMI Luigi
Sent: martedì 24 giugno 2008 14.58
To: 'CounterSoft Support'
Subject: RE: for thread: 7425

thanx


lomi
· 1
lomi
helpful
0
not helpful

IS URGENT !!!


lomi
· 1
lomi
helpful
0
not helpful

We have found the bug with this, you seem to have a lot of active proect are they all active or can some be archived?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Sorry, but all projects have to be active.

Is possible to have now a hotfix ?


lomi
· 1
lomi
helpful
0
not helpful

We are working on this as we speak and should release a fix early next week.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Have you news for me ?


lomi
· 1
lomi
helpful
0
not helpful

Not yet unfortunately. Shoud be by the end of next week.


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

FYI - 3.0.4 is out now.


Mark Wing
· 9108
Mark Wing