http://www.componentone.com/SuperProducts/ChartSilverlight/#charttypes

----------------------------------------------------------------------------------------------------------

Attention : Never put SELECT * in the <SQL> tag it will replace it with % and give error.

----------------------------------------------------------------------------------------------------------

(a.Private=False OR a.UserIDs LIKE [LoggedInUser]) AND 

[12:16:10 AM] cbizsoftKris: SingleLoggedInUser

Use this for Exelare Reports:

'[{SingleLoggedInUser}]'

In Other places use 
'[[SingleLoggedInUser]]'

Note: To cheat program use below dummy code then only it will replace '[[SingleLoggedInUser]]'
/* (Private=False OR UserIDs LIKE [LoggedInUser]) */

----------------------------------------------------------------------------------------------------------

EXEC dbo.CBO_UserPipeLineCountsReport '[{Requirements.CreateDate.1}]','[{Requirements.CreateDate.2}]','[{Requirements.UserIDs}]'

----------------------------------------------------------------------------------------------------------

DefaultValue="&lt;All&gt;"

----------------------------------------------------------------------------------------------------------

                 <GridView.Filters>
                   <Filter FieldName="Requirements.UserIDs" Caption="Select Users" LookupType="Users" DefaultValue="&lt;Self&gt;" />
                   <Filter FieldName="Requirements.JobTitle" Caption="Select Job Titles" LookupType="Lookup" LookupField="Requirements.JobTitle" />
                   <Filter FieldName="Contacts.CompanyName" Caption="Select Companies" LookupType="Entity" LookupEntityID="Companies" />
                   <Filter FieldName="Requirements.PrimarySkills" Caption="Select Primary Skills" IsGroupable="True" LookupType="Lookup" LookupField="Consultants.PrimarySkills" />
                   <Filter FieldName="Requirements.Archived" Caption="Archived" LookupType="MultiSelectList" Values="True|False" />
                   <Filter FieldName="Requirements.CreateDate" Caption="Select CreateDate" LookupType="Date" DefaultValue="&lt;All&gt;" />
                   <Filter FieldName="Requirements.Location" Caption="Select Location" LookupType="CSV" DefaultValue="&lt;All&gt;" />
                 </GridView.Filters>


AND '%' IN ('1/1/1900','1/1/1900','Vishnu','<All>','<All>',  
   '<All>','<All>','1/1/1900')


----------------------------------------------------------------------------------------------------------
-- UsersAndGroups

<Filter FieldName="Requirements.UserIDsAndGroups" FieldCaption="UsersAndGroups" Caption="Select Users and Groups" LookupType="UsersAndGroups" ExtraValues="&lt;All&gt;|&lt;Self&gt;" DefaultValue="&lt;Self&gt;" IsOverridable="False"/>
----------------------------------------------------------------------------------------------------------

                 <GridView.HiddenColumns>
                    <HiddenColumn ColumnName="TeamType"/>
                    <HiddenColumn ColumnName="TeamGroup"/>
                    <HiddenColumn ColumnName="UserID"/>
                    <HiddenColumn ColumnName="GoalValue"/>
                    <HiddenColumn ColumnName="TeamGroupOrder"/>
                    <HiddenColumn ColumnName="ColumnOrder"/>
                 </GridView.HiddenColumns>

----------------------------------------------------------------------------------------------------------
We Cache the Dynamic/Static view schema AND Edit Form schema (i.e. which fields are present in the view/edit form) at CompanyLevel (i.e.it is not stored per user, but for all users in the company).  It will get cleared only after all the users are logged out PLUS 2 hours.

I implemented a mechanism for our support to clear the cache.  Do the following
1) Make sure you turn on the debug mode (in login screen)
2) Use "ClearCache" as the password, then try to login
You will get a message saying "Cleared the Cache",  Now try to login using the correct password.

----------------------------------------------------------------------------------------------------------
This is NOT Working - Some Reason
<Filter FieldName="Reminders.ApptSubType" FieldCaption="Type" Caption="Select Type" LookupType="Lookup" LookupField="Reminders.ApptSubType,Appointment,Interview" ExtraValues="&lt;All&gt;" DefaultValue="&lt;All&gt;" IsOverridable="True"/>

This is Workign
<Filter FieldName="Temp.Subtype" FieldCaption="Sub Type" Caption="Select SubType" LookupType="Lookup" LookupField="Reminders.ApptSubType,Appointment,Interview" ExtraValues="&lt;All&gt;" DefaultValue="&lt;All&gt;" IsOverridable="True"/>
	
----------------------------------------------------------------------------------------------------------

You can change from production to test and vice versa by chaning settings.xml file
Its in C:\Program Files (x86)\cBiz\ExelareWPF

----------------------------------------------------------------------------------------------------------

[9:03:18 PM] Konstantin: Point EFW shortcut to ExelareAutoUpdater.exe Then updates will get effected.
Path: "C:\Program Files (x86)\cBiz\ExelareWPF\ExelareAutoUpdater.exe"
----------------------------------------------------------------------------------------------------------
<GridView.Filters>
<Filter FieldName="Consultants.UserIDsAndGroups" FieldCaption="Owners" Caption="Select Owners" LookupType="UsersAndGroups" ExtraValues="&lt;All&gt;|&lt;Self&gt;" DefaultValue="&lt;Self&gt;" />
<Filter FieldName="Requirements.UserIDsAndGroups" FieldCaption="UserIDs" Caption="Select Users" LookupType="UsersAndGroups" ExtraValues="&lt;All&gt;|&lt;Self&gt;" DefaultValue="&lt;All&gt;" />
</GridView.Filters>

<Fake__FilterMapping>
<Map FilterFieldName="Requirements.UserIDsAndGroups" To="Requirements.UserIDs" />
<Map FilterFieldName="Consultants.UserIDsAndGroups" To="Temp.JobOwners" />
</Fake__FilterMapping>

Note: UserIDsAndGroups and UsersAndGroups are Mandatory.
----------------------------------------------------------------------------------------------------------
Coloring Rows Example

  <StyleRules EntityID='xxx' Which='View|DView|SView|Tab' [WhichID='xxx']
      <Style DatabaseColumnName="Contacts.DisplayName"|DatabaseColumnName="HomePhone"|FieldName="JobTitle" Oper=">|<|<>|=|Like",etc" FieldValue="hello" ApplyTo="Row|Cell">
                    <Background>
                        <SolidColorBrush>Green</SolidColorBrush>
                    </Background>
                    <Foreground>
                        <SolidColorBrush>Yellow|#RRGGBB</SolidColorBrush>
                    </Foreground>
                    <Bold/>
                    <Italic/>
      </Style>
      <Style...
  </StyleRules>

Note:Now Kris is appling the Coloring at view level 
<StyleRules EntityID="Consultants" Which="DView" WhichID="Active">

Means rule apply only to Active View. 

<StyleRules EntityID="Consultants" Which="DView" WhichID="">

Means rule apply to all the Views.

----------------------------------------------------------------------------------------------------------
-- Vishnu, UsersUsage services are released to test server.  
-- If Srini asks you to implement for any client, do the following.
-- 1) Create the UsersUsage table for the client's DB (I already created in cBiz_Test2)
-- 2) If the client has a custom "MiscSettings" file, then you need to add to the custom file the following tag as the child of root tag.  
-- I already added to the default file.
-- <UsersUsage IdleLimitMins="15" UpdateMins="15" />

/****** Object:  Table [dbo].[UsersUsage]    Script Date: 5/30/2018 9:22:34 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[UsersUsage](
	[UsageID] [int] IDENTITY(1,1) NOT NULL,
	[UsageDate] [datetime] NOT NULL,
	[UserID] [nvarchar](80) NOT NULL,
	[Device] [nvarchar](40) NOT NULL,
	[UsageMins] [int] NOT NULL CONSTRAINT [DF_UsersUsage_UsageMins]  DEFAULT ((0)),
	[Notes] [ntext] NULL,
 CONSTRAINT [PK_UsersUsage] PRIMARY KEY CLUSTERED 
(
	[UsageID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
----------------------------------------------------------------------------------------------------------





----------------------------------------------------------------------------------------------------------




----------------------------------------------------------------------------------------------------------