The NEW FSEnablers Quick Link select * from tbl_SYS_Servers where serverName =

FSE #SERVER.FSE_ENVIRONMENT# (#SERVER.FSE_IDENTITY# as #encodeforHTML(cgi.server_name)#)
FSE Test Email
FSe Web Development
1FS Schools - Development
FSe Report Ctr.
FSLibrary 2.0 (#SERVER.FSE_ENVIRONMENT# #lcase( SERVER.FSE_Datasource )#)
select c.companyId, c.companyPType, c.companyPKeyId, case when c.companyPType = 'MFR' then ( select mfr_name from tblManufacturers where mfr_id = c.companyPKeyId ) when c.companyPType = 'BRO' then ( select broker_name from tblBrokers where broker_id = c.companyPKeyId ) when c.companyPType = 'MSC' then ( select company from tbl_MSC_FSLibraryUsers where userId = c.companyPKeyId ) when c.companyPType = 'CHO' then ( select cho_name from tbl_CHO_Operators where cho_Id = c.companyPKeyId ) when c.companyPType = 'DST' then ( select dstName from tbl_DST_Distributors where dstid = c.companyPKeyId ) else 'Unknown' end companyName from tbl_LIB_Companies c where c.companyPType in ( 'MFR', 'BRO', 'MSC', 'CHO', 'DST' ) order by companyName

Init Dev Library Account

Library Account:
User Email:

internal tools

Recently Changed Files
 CMM Section ID Finder
Asset Matrix

SCRUM

Search Release Notes
SCRUM Best Practices
Production Src Files

Sales Team Portal #SERVER.FSE_ENVIRONMENT#
select stp.name, '#_protocol#://#_hostName#/fse/salesteamportal/' + stp.portal_name + '/index.cfm' as devURLBase, m.mfr_name as companyName from fsenablers..tbl_CUS_Websites stp with (nolock) inner join tblManufacturers m with (nolock) on m.mfr_id = stp.portal_ownerId where stp.portal_ownerId > 0 and stp.portal_ownerType = 'MFR' and stp.active = 'Y' order by companyName

select stp.name, '#_protocol#://#_hostName#/fse/salesteamportal/' + stp.portal_name + '/index.cfm' as devURLBase, b.broker_name as companyName from fsenablers..tbl_CUS_Websites stp with (nolock) inner join tblBrokers b with (nolock) on b.broker_id = stp.portal_ownerId where stp.portal_ownerId > 0 and stp.portal_ownerType = 'BRO' and stp.active = 'Y' order by companyName

SELECT stp.name ,'#_protocol#://#_hostName#/fse/salesteamportal/' + stp.portal_name + '/index.cfm' as devURLBase ,cho.cho_name as companyName FROM fsenablers..tbl_CUS_Websites AS stp WITH (nolock) INNER JOIN tbl_CHO_Operators AS cho WITH (nolock) on cho.cho_id = stp.portal_ownerId and cho.cho_segmentId in (54,55,56) /*Co-op or 1FS Schools Member GPO*/ and cho.cho_1fsSchoolsMember = 'Y' /*School Co-op*/ WHERE stp.portal_ownerId > 0 and stp.portal_ownerType = 'CHO' and stp.active = 'Y' ORDER BY companyName

#qmd_sysServer.serverName# Settings

#encodeForHTML( _cal.label )#: #encodeForHTML( qmd_sysServer[_cal.column][1] )#

Useful Links

FSLibrary
DevExtreme Documentation
CFML Reference
jQuery API Docs
Fusion Reactor (#SERVER.FSE_IDENTITY#)
 GitHub (SE-Development)
Jira

FSE Usage Stats

Broker Mobile App Usage
1FS Schools Usage
select stp.name, 'http://staging.fsenablers.com/fse/salesteamportal/' + stp.portal_name + '/index.cfm' as devURLBase, m.mfr_name as companyName from fsenablers..tbl_CUS_Websites stp with (nolock) inner join tblManufacturers m with (nolock) on m.mfr_id = stp.portal_ownerId where stp.portal_ownerId > 0 and stp.portal_ownerType = 'MFR' and stp.active = 'Y' and stp.portal_ownerId in ( 1, 201 ) union all select stp.name, 'http://staging.fsenablers.com/fse/salesteamportal/' + stp.portal_name + '/index.cfm' as devURLBase, b.broker_name as companyName from fsenablers..tbl_CUS_Websites stp with (nolock) inner join tblBrokers b with (nolock) on b.broker_id = stp.portal_ownerId where stp.portal_ownerId > 0 and stp.portal_ownerType = 'BRO' and stp.active = 'Y' and stp.portal_ownerId = 14 order by companyName --->

Colors

#encodeForHTML( _colorSet.title )#
#encodeforhtml( _color.name )# ###lcase( _color.hex )#

Chart / Graph Colors

#lcase( _color )#

Other Colors

#lcase( _color )#

MFR Sales Team Portals

select stp.name, 'https://' + stp.portal_name + '.salesteamportal.com' as prodURLBase, m.mfr_name as companyName from fsenablers..tbl_CUS_Websites stp with (nolock) inner join tblManufacturers m with (nolock) on m.mfr_id = stp.portal_ownerId where stp.portal_ownerId > 0 and stp.portal_ownerType = 'MFR' and stp.active = 'Y' order by companyName MFR portal activity

MFR Sites

select stp.name, 'https://' + stp.portal_name + '.salesteamportal.com' as prodURLBase, b.broker_name as companyName from fsenablers..tbl_CUS_Websites stp with (nolock) inner join tblBrokers b with (nolock) on b.broker_id = stp.portal_ownerId where stp.portal_ownerId > 0 and stp.portal_ownerType = 'BRO' and stp.active = 'Y' order by companyName

BRO Sales Team Portals

BRO Sites

SELECT stp.name ,'http://' + stp.portal_name + '.salesteamportal.com' as prodURLBase ,cho.cho_name as companyName FROM fsenablers..tbl_CUS_Websites AS stp WITH (nolock) INNER JOIN tbl_CHO_Operators AS cho WITH (nolock) on cho.cho_id = stp.portal_ownerId and cho.cho_segmentId in (54,55,56) /*Co-op or 1FS Schools Member GPO*/ and cho.cho_1fsSchoolsMember = 'Y' /*School Co-op*/ WHERE stp.portal_ownerId > 0 and stp.portal_ownerType = 'CHO' and stp.active = 'Y' ORDER BY companyName

CO-OP SALES TEAM PORTALS

--->