Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Silver Contributor
Posts: 835
Registered: ‎03-24-2009

WEB 7.5.3 Opp Group/Listview column always appears on the far right.

Anyone have a clue on this? The ACCOUNTMANAGERID field always appears as the far right column in the Group, no matter which column you 'move to'. Maybe it's cached, but we can replicate it on different machines......  maybe deleting the column, saving the group, then adding the column back in.....

 

 

 

Here's the query:

 

SELECT A1.OPPORTUNITYID, A2.ACCOUNT A2_ACCOUNT, A1.ACCOUNTMANAGERID, A1.STATUS, A3.NAME A3_NAME, A1.TYPE, A1.ESTIMATEDCLOSE, A1.CREATEDATE, A1.ACTUALCLOSE, A4.LASTACTIVITY A4_LASTACTIVITY, A4._01_DAYS_AT_INITIAL_CONTACT A4__01_DAYS_AT_INITIAL_CONTACT, A4._02_DAYS_AT_NAM A4__02_DAYS_AT_NAM, A4._03_DAYS_AT_LOU A4__03_DAYS_AT_LOU, A4._04_DAYS_AT_VP A4__04_DAYS_AT_VP, A4._05_DAYS_AT_PROPOSAL A4__05_DAYS_AT_PROPOSAL, A4._06_DAYS_AT_SIGNED A4__06_DAYS_AT_SIGNED, A4._08_DAYS_TO_DECISION_LOST A4__08_DAYS_TO_DECISION_LOST, A4._09_DAYS_TO_DECISION_WON A4__09_DAYS_TO_DECISION_WON, A4._10_DAYS_TO_DECISION A4__10_DAYS_TO_DECISION FROM OPPORTUNITY A1 INNER JOIN CHART_OPPORTUNITY_STAGE_HISTORY A4 ON (A1.OPPORTUNITYID=A4.OPPORTUNITYID) INNER JOIN ACCOUNT A2 ON (A1.ACCOUNTID=A2.ACCOUNTID) LEFT OUTER JOIN SALESPROCESSES A3 ON (A1.OPPORTUNITYID=A3.ENTITYID) WHERE (A3.NAME IS NOT NULL AND A3.NAME <> '') AND (A1.ACCOUNTMANAGERID IN ('U6UJ9A00002O', 'U6UJ9A000033', 'U6UJ9A00003D', 'U6UJ9A00003U', 'U6UJ9A000045', 'U6UJ9A00003X', 'U6UJ9A00003N', 'U6UJ9A00003A', 'U6UJ9A00003I', 'U6UJ9A00003K', 'U6UJ9A00003J', 'U6UJ9A00003P')) AND (A1.STATUS<>'Inactive')

RJ Samp