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 issueid42_9_,
this_.projectid as projectid42_9_,
this_.projectcode as projectc3_42_9_,
this_.typedesc as typedesc42_9_,
this_.prioritydesc as priority5_42_9_,
this_.severitydesc as severity6_42_9_,
this_.statusdesc as statusdesc42_9_,
this_.resdesc as resdesc42_9_,
this_.reporteddesc as reported9_42_9_,
this_.versionname as version10_42_9_,
this_.issuetypeid as issuety11_42_9_,
this_.issuepriorityid as issuepr12_42_9_,
this_.issueseverityid as issuese13_42_9_,
this_.priorityseq as priorit14_42_9_,
this_.severityseq as severit15_42_9_,
this_.issuestatusid as issuest16_42_9_,
this_.issueresolutionid as issuere17_42_9_,
this_.reportedby as reportedby42_9_,
this_.fixedinversionid as fixedin19_42_9_,
this_.summary as summary42_9_,
this_.longdesc as longdesc42_9_,
this_.created as created42_9_,
this_.revised as revised42_9_,
this_.issuekey as issuekey42_9_,
this_.versionnumber as version25_42_9_,
this_.versiondesc as version26_42_9_,
this_.versionorder as version27_42_9_,
this_.versionarchived as version28_42_9_,
this_.versionreleased as version29_42_9_,
this_.startdate as startdate42_9_,
this_.duedate as duedate42_9_,
this_.resolveddate as resolve32_42_9_,
this_.closeddate as closeddate42_9_,
this_.issuerisklevelid as issueri34_42_9_,
this_.issuevotes as issuevotes42_9_,
this_.userdata1 as userdata36_42_9_,
this_.userdata2 as userdata37_42_9_,
this_.userdata3 as userdata38_42_9_,
this_.percentcomplete as percent39_42_9_,
this_.estimatedays as estimat40_42_9_,
this_.estimatehours as estimat41_42_9_,
this_.estimateminutes as estimat42_42_9_,
this_.riskdesc as riskdesc42_9_,
this_.visibility as visibility42_9_,
this_.visibilitymembertype as visibil45_42_9_,
this_.parentissueid as parenti46_42_9_,
this_.tstamp as tstamp42_9_,
comments1_.IssueID as IssueID__11_,
comments1_.commentid as commentid11_,
comments1_.commentid as commentid43_0_,
comments1_.userid as userid43_0_,
comments1_.issueid as issueid43_0_,
comments1_.projectid as projectid43_0_,
comments1_.comment as comment43_0_,
comments1_.username as username43_0_,
comments1_.isclosing as isclosing43_0_,
comments1_.visibility as visibility43_0_,
comments1_.visibilitymembertype as visibili9_43_0_,
comments1_.created as created43_0_,
comments1_.tstamp as tstamp43_0_,
customfiel2_.IssueID as IssueID__12_,
customfiel2_.customfielddataid as customfi1_12_,
customfiel2_.customfielddataid as customfi1_29_1_,
customfiel2_.customfieldid as customfi2_29_1_, customfiel2_.userid as userid29_1_, customfiel2_.projectid as projectid29_1_,
customfiel2_.issueid as issueid29_1_, customfiel2_.fielddata as fielddata29_1_, customfiel2_.created as created29_1_, customfiel2_.tstamp as tstamp29_1_, timeentrie3_.IssueID as
IssueID__13_, timeentrie3_.entryID as entryID13_, timeentrie3_.entryID as entryID48_2_, timeentrie3_.projectid as projectid48_2_, timeentrie3_.issueid as issueid48_2_,
timeentrie3_.userid as userid48_2_, timeentrie3_.hours as hours48_2_, timeentrie3_.minutes as minutes48_2_, timeentrie3_.comment as comment48_2_, timeentrie3_.timeentrydate as
timeentr8_48_2_, timeentrie3_.created as created48_2_, timeentrie3_.tstamp as tstamp48_2_, affectedve6_.IssueID as IssueID__14_, affectedve6_.affectedversionid as affected1_14_,
affectedve6_.affectedversionid as affected1_45_3_, affectedve6_.issueid as issueid45_3_, affectedve6_.versionid as versionid45_3_, affectedve6_.created as created45_3_,
affectedve6_.tstamp as tstamp45_3_, versionen12_.versionid as versionid3_4_, versionen12_.projectid as projectid3_4_, versionen12_.versionnumber as versionn3_3_4_,
versionen12_.versionname as versionn4_3_4_, versionen12_.versiondesc as versiond5_3_4_, versionen12_.versionreleased as versionr6_3_4_, versionen12_.versionorder as
versiono7_3_4_, versionen12_.versionarchived as versiona8_3_4_, versionen12_.created as created3_4_, versionen12_.tstamp as tstamp3_4_, resources4_.issueresourceid as
issueres1_46_5_, resources4_.issueid as issueid46_5_, resources4_.userid as userid46_5_, resources4_.created as created46_5_, resources4_.tstamp as tstamp46_5_, useren14_.userid
as userid56_6_, useren14_.username as username56_6_, useren14_.firstname as firstname56_6_, useren14_.surname as surname56_6_, useren14_.pwd as pwd56_6_, useren14_.emailaddress
as emailadd6_56_6_, useren14_.roles as roles56_6_, useren14_.created as created56_6_, useren14_.lastupdated as lastupda9_56_6_, useren14_.ResetPWD as ResetPWD56_6_,
useren14_.active as active56_6_, useren14_.comment as comment56_6_, useren14_.tstamp as tstamp56_6_, useren14_.firstname + ' ' + useren14_.surname as formula15_6_,
components5_.IssueID as IssueID__15_, components5_.issuecomponentid as issuecom1_15_, components5_.issuecomponentid as issuecom1_47_7_, components5_.issueid as issueid47_7_,
components5_.componentid as componen3_47_7_, components5_.created as created47_7_, components5_.tstamp as tstamp47_7_, componente16_.componentid as componen1_8_8_,
componente16_.projectid as projectid8_8_, componente16_.componentname as componen3_8_8_, componente16_.componentdesc as componen4_8_8_, componente16_.componentreadonly as
componen5_8_8_, componente16_.userid as userid8_8_, componente16_.created as created8_8_, componente16_.tstamp as tstamp8_8_
FROM gemini_issuesview this_
left outer join
gemini_issuecomments comments1_ on this_.issueid=comments1_.IssueID
left outer join gemini_customfielddata customfiel2_ on this_.issueid=customfiel2_.IssueID
left outer join
gemini_timetracking timeentrie3_ on this_.issueid=timeentrie3_.IssueID
left outer join gemini_affectedversions affectedve6_ on this_.issueid=affectedve6_.IssueID
left outer join
gemini_versions versionen12_ on affectedve6_.versionid=versionen12_.versionid
inner join gemini_issueresources resources4_ on this_.issueid=resources4_.IssueID
left outer join
gemini_users useren14_