Microsoft Azure Cloud Analytics

Monday, March 28, 2016

Dynamically Create HTML table in Dashboard in MS CRM 2015/16

<html><head>
<title>Test</title>
<meta><meta><meta><meta><meta><meta><meta></head>
<body style="word-wrap: break-word;">
<script src="ClientGlobalContext.js.aspx" type="text/javascript"></script>
<script src="../WebResources/aac_sdk_jquery_1.9.1.min" type="text/javascript"></script>
<script src="../WebResources/aac_SDK_REST" type="text/javascript"></script>
<script src="../WebResources/aac_JavaScriptRESTDataOperations" type="text/javascript"></script>
<script type="text/javascript">
function getphonecall()
{
var currentUserID = Xrm.Page.context.getUserId();

if(currentUserID != null)
{

var serverUrl = Xrm.Page.context.getClientUrl();
//alert(serverUrl);

var oDataEndpointUrl = serverUrl +"/XrmServices/2011/OrganizationData.svc/";

oDataEndpointUrl+="PhoneCallSet?$select=StateCode,ActivityTypeCode,CreatedBy,Description,DirectionCode,ScheduledEnd,OwnerId,PhoneNumber,PriorityCode,RegardingObjectId,Subject";

var service = new ActiveXObject("MSXML2.XMLHTTP.3.0");

if(service != null)
{
service.open("Get",oDataEndpointUrl,false);
service.setRequestHeader("X-Requested-Width","XMLHttpRequest");
service.SetRequestHeader("Accept","application/json,text/javascript, */*");
service.send(null);
var requestResults = eval('('+service.responseText +')').d.results;
var tableData = "";
if(requestResults != null && requestResults.length >= 1)
{
for(var i = 0;i<requestResults.length;i++)
{
//var accountEntity = requestResults[i];
//alert(accountEntity.Subject);
var service = requestResults[i].Subject;
if (service != null) {
//dynamically add table data with Service Names
tableData = tableData + "<tr><td>" + service + "</td></tr>";

}
}
var table = "<table style='font-family:Segoe UI;font-weight:normal;font-size:13px;'><tr style='height:20px'><td style='text-decoration:underline;'><b>Subject</b></td></tr>" + tableData + "</table>";
//show table data on the Account form
//window.document.writeln(table);
$("#dashboardContainer").append(table);
}
}
}
}

</script>
<style>
h5 {
font-family: Segoe UI,Tahoma,Arial;
font-weight: bold;
font-variant: normal;
color: #000080;
text-decoration: underline;
}
p {
font-family: Segoe UI,Tahoma,Arial;
font-size: 13px;
}
</style>
<table>
<tbody>
<tr><td><p id="Phone call"></p><br></td></tr>
<tr><td> <br></td></tr><tr>
<td><button onclick="getphonecall()">Click here</button></td></tr>
</tbody></table>
<span id="refreshSpan">  </span>
<br>
<span id="clientDropdown"></span>
<br>
<div id="dashboardContainer" style="width: 100%; white-space: nowrap;">
</div>
</body></html>

Hope this help!!

Monday, March 21, 2016

Adding fields to Quick Global Search Result in MS CRM 2015/16

With the Release of CRM 2015, one of the most exciting feature is Quick Find Search/Global Search/Universal Search. There are many blogs already existing to explore this functionality.

What I am going to tell you today is, how to change what you want to see in the search results? Yes, its true; you can change it as per your requirement. Following is a screenshot wise step by step process to achieve the same:

On the top navigation, locate to quick search and type text>>click enter (I am searching an account named ‘Movida’)

Currently, what you can see is Account Name, Account No. & Primary Contact

If you wish you to change it to Account Name, Account No. & Address 1:City; Go to settings>>Customization

Click on customize the system

Expand Entity & Go to Account>>View

Locate-Quick Find Active Accounts under views

Double click on Quick find view to modify it; the first three columns here are the fields which you see in the results of Global/Universal Search

So, if i wish to add Address 1: City. I will need to click on ‘Add view columns’and add my desired field here and with the help arrow keys visibl, i will bring it to either of 1st three positions.

Now, click ‘Save & Close’ and Publish customizations; you will now see the results you wanted.

Hope you find it helpful !

Transporting System Settings with Solutions

When you export a solution you are given the option to include various system settings to be transported with your solution and take effect in the target environment. This post provides some insights into what these system settings are and provides a list of the settings that are transported with the solution.

Upon solution export you are presented with the following dialog for exporting organization system settings:

However, the list above does not correspond exactly to the tabs of the system settings dialog:

So for example, if you want to transport the Date format with your solution, which of the above settings should you include in the solution? Is it even possible to transport all system settings with the solution? The following screenshots of all the system settings specify which system settings are included in which section of the solution export settings, and which ones are not transported at all. Here are the possible settings you can include and I’m using a color code to identify them later on:

Note that the red rectangle means that those system settings cannot be transported with a solution. So here are all the different sections of the system settings mapped according to the color codes above:

Hope it help!!

Sunday, March 13, 2016

Workflow Activity Input and Output Parameters and Data Types in MS CRM 2013/15/16

Microsoft Dynamics CRM supports two types of parameters for a workflow activity.

Input Parameters
Output Parameters

Input Parameters

The input parameter is annotated with the .NET attribute "Input".

DefaultAttribute

DefaultAttribute class can be used to specify a default value (using "Default" attribute) for an input parameter.

Bool

[Input("Bool input")]

[Output("Bool output")]

[Default("True")]

public InOutArgument<bool> Bool { get; set; }

DateTime

[Input("DateTime input")]

[Output("DateTime output")]

[Default("2013-07-09T02:54:00Z")]

public InOutArgument<DateTime> DateTime { get; set; }

Decimal

[Input("Decimal input")]

[Output("Decimal output")]

[Default("20.75")]

public InOutArgument<decimal> Decimal { get; set; }

Double

[Input("Double input")]

[Output("Double output")]

[Default("200.2")]

public InOutArgument<double> Double { get; set; }

Integer

[Input("Int input")]

[Output("Int output")]

[Default("2322")]

public InOutArgument<int> Int { get; set; }

Money (Currency)

[Input("Money input")]

[Output("Money output")]

[Default("232.3")]

public InOutArgument<Money> Money { get; set; }

OptionSetValue

[Input("OptionSetValue input")]

[Output("OptionSetValue output")]

[AttributeTarget("account", "industrycode")]

[Default("3")]

public InOutArgument<OptionSetValue> OptionSetValue { get; set; }

Attribute Target must specify the entity and attribute being referenced.

String

[Input("String input")]

[Output("String output")]

[Default("string default")]

public InOutArgument<string> String { get; set; }

Entity Reference

[Input("EntityReference input")]

[Output("EntityReference output")]

[ReferenceTarget("account")]

[Default("3B036E3E-94F9-DE11-B508-00155DBA2902", "account")]

public InOutArgument<EntityReference> AccountReference { get; set; }

Reference Target attribute must specify the type of entity being referenced.

Required Argument Attribute

System.Activities.RequiredArgumentAttribute class can be used to specify that the input parameter is required.

[RequiredArgument]

[Input("Update next Anniversary date for")]

[ReferenceTarget("contact")]

public InArgument<EntityReference> Contact { get; set; }

Output Parameters

The output parameter is annotated with the .NET attribute "Output"

//this is the name of the parameter that will be returned back to the workflow

[Output("Credit Score")]

//this line identifies the specific attribute which will be passed back to the workflow

[AttributeTarget(CustomEntity, "new_creditscore")]

//this line declares the output parameter and declares the proper data type of the parameter being passed back.

public OutArgument<int> CreditScore {get;set;}

Refer to Microsoft documentation for more details

http://technet.microsoft.com/en-us/library/gg328515.aspx

http://technet.microsoft.com/en-us/library/gg327842.aspx

Option Set:

[Input("OptionSetValue input")]

[Output("OptionSetValue output")]

[AttributeTarget("account", "industrycode")]

[Default("3")]

public OutArgument<OptionSetValue> OptionSetValue { get; set; }

Output only:

[Output("OptionSetValue output")]

[AttributeTarget("account", "industrycode")]

public OutArgument<OptionSetValue> OptionSetVal { get; set; }

To set:

this.OptionSetVal .Set(context, new OptionSetValue(intVar)); //change intVar var to yours

DateTime:

[Input("DateTime input")]

[Output("DateTime output")]

[Default("2004-07-09T02:54:00Z")]

public OutArgument<DateTime> DateTimeVal { get; set; }

Output only:

[Output("DateTime output")]

public OutArgument<DateTime> DateTimeVal{ get; set; }

To set:

this.DateTimeVal.Set(context, myDateTimeValue); //change myDateTimeValue var to yours

Money:

[Output("Money output")]

public OutArgument<Money> MoneyVal { get; set; }

To set:

decimal decimalVar = 200.15; //change to your value

this.MoneyVal .Set(context, new Money(decimalVar)); //change decimalvar to yours

Lookup or Entity Reference:

[Output("EntityReference output")]
[ReferenceTarget("account")] //change this to your Entity, for example if you want to lookup to entity Account
public OutArgument<EntityReference> EntityReferenceVal { get; set; }

To set:

Guid accountId = new Guid("6fd72744-3676-41d4-8003-ae4cde9ac282"); //change to your value

this.EntityReferenceVal.Set(context, new EntityReference("account", accountId)); //change the "account" and accountId to your variables (entity name and entity record id of the lookup)

Btw, we also can set default value like this:

[Output("Money output")]

[Default("232.3")]

public InOutArgument<Money> MoneyParameter { get; set; }

Hope it helps!

Thank you.

Saturday, March 12, 2016

Hide Posts From Social Pane in CRM 2013/2015/2016

In CRM 2013/15/16 Microsoft introduced the Social Pane, also known as Record Wall. Recently in our project we had a requirement to disable posts for a particular security role. To do that the first thing we did is to remove the Post Privileges for the security role. Please refer to the screenshot below.

As you can see, remove all the privileges for the POST entity from the security role.

However after this change is made, when the user logs into the application, this is how it looks to the user.

However what we needed to do is to hide the Posts tab altogether for this security role. A little bit of searching and found the below link. This gave us exactly what we needed.

https://community.dynamics.com/crm/b/crmsoftwareblog/archive/2013/10/26/hide-post-tab-in-social-pane-microsoft-crm-2013.aspx

All you need to do is call the method HidePosts() as mentioned in the link in the onload of the form and check for the currently logged in users security roles. And then hide the post tab if the security role matches the condition.

Hope this helps!

Thursday, February 25, 2016

Change Display text of Currency lookup field with Currency Code in Dynamics CRM 2015/16 using JavaScript

Call the Below Function onLoad & On-change Event.

// JScript source code
function ChangeCurrencyLookUpDisplayValue() {
debugger;
var lookupData = new Array();
var lookupItem = new Object();
var lookup = Xrm.Page.data.entity.attributes.get("transactioncurrencyid");

if (lookup != null) {
var displayvalue = '';
var xmlText = '';

xmlText += "<s:Envelope xmlns:s=\"http://schemas.xmlsoap.org/soap/envelope/\">"; xmlText += "<s:Body>";
xmlText += "<Retrieve xmlns=\"http://schemas.microsoft.com/xrm/2011/Contracts/Services\" xmlns:i=\"http://www.w3.org/2001/XMLSchema-instance">";
xmlText += "<entityName>transactioncurrency</entityName>";
xmlText += "<id>" + lookup.getValue()[0].id + "</id>";
xmlText += "<columnSet xmlns:a=\"http://schemas.microsoft.com/xrm/2011/Contracts\">";
xmlText += "<a:AllColumns>false</a:AllColumns>";
xmlText += "<a:Columns xmlns:b=\"http://schemas.microsoft.com/2003/10/Serialization/Arrays\">";
xmlText += "<b:string>isocurrencycode</b:string>";
xmlText += "</a:Columns>";
xmlText += "</columnSet>";
xmlText += "</Retrieve>";
xmlText += "</s:Body>";
xmlText += "</s:Envelope>";
var xHReq = new XMLHttpRequest();

var url = Xrm.Page.context.getClientUrl() + "/XRMServices/2011/Organization.svc/web";
xHReq.open("POST", url, false);
xHReq.setRequestHeader("SOAPAction", "http://schemas.microsoft.com/xrm/2011/Contracts/Services/IOrganizationService/Retrieve");
xHReq.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xHReq.setRequestHeader("Accept", "application/xml,text/xml,*/*");
xHReq.send(xmlText);

//Capture the result.
var resultXml = xHReq.responseXML;
var varray = new Array();

//Check forerrors.

var result = resultXml.getElementsByTagName("a:KeyValuePairOfstringanyType");
if (result.length > 0) {
displayvalue = result[0].childNodes[1].lastChild.data;
}
if (displayvalue != '') {
lookupItem.name = displayvalue;
lookupData[0] = lookupItem;
lookup.DataValue = lookupData;
Xrm.Page.getAttribute("transactioncurrencyid").
setValue([{
id: lookup.getValue()[0].id,
name: displayvalue, entityType: "transactioncurrency"
}]);
}

}
}

Friday, February 19, 2016

Fetch XML Condition to SQL WHERE

Advanced Find Operator	Fetch XML Operator	FetchXML Filter	SQL Where condition
Equal	eq	<condition attribute="firstname" value="John" operator="eq"/>	WHERE firstname = 'John'
Not Equal	ne	<condition attribute="firstname" value="John" operator="ne"/>	WHERE firstname != 'John'
Contains	like	<condition attribute="firstname" value="John" operator="like"/>	WHERE firstname LIKE '%John%'
Does Not Contains	not-like	<condition attribute="firstname" value="John" operator="not like"/>	WHERE firstname NOT LIKE '%John%'
Begins with	like	<condition attribute="firstname" value="John%" operator="like"/>	WHERE firstname LIKE 'John%'
Does Not Begins with	not-like	<condition attribute="firstname" value="John%" operator="not like"/>	WHERE firstname NOT LIKE 'John%'
Ends with	like	<condition attribute="firstname" value="%John" operator="like"/>	WHERE firstname LIKE '%John'
Does Not End with	not-like	<condition attribute="firstname" value="%John" operator="not like"/>	WHERE firstname NOT LIKE '%John'
Contains Data	not-null	<condition attribute="firstname" operator="not-null"/>	WHERE firstname IS NOT NULL
Does Not Contains Data	null	<condition attribute="firstname"operator="null"/>	WHERE firstname IS NULL
Is Greater than	gt	<condition attribute="annualincome" value="123" operator="gt"/>	WHERE AnnualIncome >123
Is Greater than or Equal To	ge	<condition attribute="annualincome" value="123" operator="ge"/>	WHERE AnnualIncome >=123
Is Less than	lt	<condition attribute="annualincome" value="123" operator="lt"/>	WHERE AnnualIncome <123 span="">
Is less than or Equal To	le	<condition attribute="annualincome" value="123" operator="le"/>	WHERE AnnualIncome <=123
Equals Current User	eq-userid	<condition attribute="createdby" operator="eq-userid"/>	WHERE CreatedBy ='7BC449A8-5A8F-E311-A63C-0050568C6D7D'
Does Not Equal Current user	ne-userid	<condition attribute="createdby" operator="ne-userid"/>	WHERE CreatedBy !='7BC449A8-5A8F-E311-A63C-0050568C6D7D'
Equals Current User' Teams	eq-userteams	<condition attribute="ownerid" operator="eq-userteams"/>	WHERE OwnerId IN ('7BC449A8-5A8F-E311-A63C-0050568C6D7D')
Equals Current user Or User's Teams	eq-useroruserteams	<condition attribute="ownerid" operator="eq-useroruserteams"/>	WHERE OwnerId IN('7BC449A8-5A8F-E311-A63C-0050568C6D7D',' 09C5427D-88B7-E411-8BFB-0050568C6D7D')
On	on	<condition attribute="createdon" value="2015-04-01" operator="on"/>	WHERE CreatedOn >= '2015-04-01 05:00:00' AND CreatedOn < '2015-04-02 05:00:00'
On or After	on-or-after	<condition attribute="createdon" value="2015-04-01" operator="on-or-after"/>	WHERE CreatedOn >= '2015-04-01 05:00:00'
On or Before	on-or-before	<condition attribute="createdon" value="2015-04-01" operator="on-or-before"/>	WHERE CreatedOn < '2015-04-02 05:00:00'
Yesterday	yesterday	<condition attribute="createdon"operator="yesterday"/>	WHERE CreatedOn >= '2015-04-01 05:00:00' AND CreatedOn < '2015-04-02 05:00:00'
Today	today	<condition attribute="createdon"operator="today"/>	WHERE CreatedOn >= '2015-04-02 05:00:00' AND CreatedOn < '2015-04-03 05:00:00'
Tomorrow	tomorrow	<condition attribute="createdon"operator="tomorrow"/>	WHERE CreatedOn >= '2015-04-03 05:00:00' AND CreatedOn < '2015-04-04 05:00:00'
Next 7 Days	next-seven-days	<condition attribute="createdon"operator="next-seven-days"/>	WHERE CreatedOn >= '2015-04-02 21:25:41.110' AND CreatedOn <'2015-04-10 05:00:00'
Last 7 Days	last-seven-days	<condition attribute="createdon"operator="last-seven-days"/>	WHERE CreatedOn >= '2015-03-26 05:00:00' AND CreatedOn <= '2015-04-02 21:25:41.110'
Next Week	next-week	<condition attribute="createdon"operator="next-week"/>	WHERE CreatedOn >= '2015-04-05 05:00:00' AND CreatedOn < '2015-04-12 05:00:00'
Last Week	last-week	<condition attribute="createdon"operator="last-week"/>	WHERE CreatedOn >= '2015-03-22 05:00:00' AND CreatedOn < '2015-03-29 05:00:00'
This Week	this-week	<condition attribute="createdon"operator="this-week"/>	WHERE CreatedOn >= '2015-03-29 05:00:00' AND CreatedOn < '2015-04-05 05:00:00'
Next Month	next-month	<condition attribute="createdon"operator="next-month"/>	WHERE CreatedOn >= '2015-05-01 05:00:00' AND CreatedOn < '2015-06-01 05:00:00'
Last Month	last-month	<condition attribute="createdon"operator="last-month"/>	WHERE CreatedOn >= '2015-03-01 06:00:00' AND CreatedOn < '2015-04-01 05:00:00'
This Month	this-month	<condition attribute="createdon"operator="this-month"/>	WHERE CreatedOn >= '2015-04-01 05:00:00' AND CreatedOn < '2015-05-01 05:00:00'
Next Year	next-year	<condition attribute="createdon"operator="next-year"/>	WHERE CreatedOn >= '2016-01-01 06:00:00' AND CreatedOn < '2017-01-01 06:00:00'
Last Year	last-year	<condition attribute="createdon"operator="last-year"/>	WHERE CreatedOn >= '2014-01-01 06:00:00' AND CreatedOn < '2015-01-01 06:00:00'
This Year	this-year	<condition attribute="createdon"operator="this-year"/>	WHERE CreatedOn >= '2015-01-01 06:00:00' AND CreatedOn < '2016-01-01 06:00:00'
Last X Hours	last-x-hours	<condition attribute="createdon" value="1" operator="last-x-hours"/>	WHERE CreatedOn >= '2015-04-02 20:00:00' AND CreatedOn <= '2015-04-02 21:53:49.933'
Next X Hours	next-x-hours	<condition attribute="createdon" value="1" operator="next-x-hours"/>	WHERE CreatedOn >= '2015-04-02 21:53:49.933' AND CreatedOn <'2015-04-02 23:00:00'
Last X Days	last-x-days	<condition attribute="createdon" value="1" operator="last-x-days"/>	WHERE CreatedOn >= '2015-04-01 05:00:00' AND CreatedOn <= '2015-04-02 21:53:49.933'
Next X Days	next-x-days	<condition attribute="createdon" value="1" operator="next-x-days"/>	WHERE CreatedOn >= '2015-04-03 19:48:07.257' AND CreatedOn <'2015-04-05 05:00:00'
Last X Weeks	last-x-weeks	<condition attribute="createdon" value="1" operator="last-x-weeks"/>	WHERE CreatedOn >= '2015-03-27 05:00:00' AND CreatedOn <= '2015-04-03 19:48:07.260'
Next X Weeks	next-x-weeks	<condition attribute="createdon" value="1" operator="next-x-weeks"/>	WHERE CreatedOn >= '2015-04-03 19:48:07.260' AND CreatedOn <'2015-04-11 05:00:00'
last X Months	last-x-months	<condition attribute="createdon" value="1" operator="last-x-months"/>	WHERE CreatedOn >= '2015-03-03 06:00:00' AND CreatedOn <= '2015-04-03 19:48:07.260'
Next X months	next-x-months	<condition attribute="createdon" value="1" operator="next-x-months"/>	WHERE CreatedOn >= '2015-04-03 19:48:07.260' AND CreatedOn <'2015-05-04 05:00:00'
Last X Years	last-x-years	<condition attribute="createdon" value="1" operator="last-x-years"/>	WHERE CreatedOn >= '2014-04-03 05:00:00' AND CreatedOn <= '2015-04-03 19:48:07.260'
Next X Years	next-x-years	<condition attribute="createdon" value="1" operator="next-x-years"/>	WHERE CreatedOn >= '2015-04-03 19:48:07.260' AND CreatedOn <'2016-04-04 05:00:00'
Any Time	not-null	<condition attribute="createdon" operator="not-null"/>	WHERE CreatedOn IS NOT NULL
Older than x months	olderthan-x-months	<condition attribute="createdon" value="1" operator="olderthan-x-months"/>	WHERE CreatedOn < '2015-03-03 06:00:00'
In Fiscal Year	in-fiscal-year	<condition attribute="createdon" value="2015" operator="in-fiscal-year"/>	WHERE CreatedOn >= '2015-01-01 06:00:00' AND CreatedOn < '2016-01-01 06:00:00'
In Fiscal Period	in-fiscal-period	<condition attribute="createdon" value="1" operator="in-fiscal-period"/>	WHEREdbo.fn_GetFiscalPeriod('2014-01-01 00:00:00', 4, CreatedOn, '20') = 1
In Fiscal Period and Year	in-fiscal-period-and-year	<condition attribute="createdon=" operator="in-fiscal-period-and-year="> <value>01</value> <value>2015</value> </condition>	WHERE CreatedOn >= '2015-01-01 06:00:00' AND CreatedOn < '2015-04-01 05:00:00'
In or After Fiscal Period	in-or-after-fiscal-period-and-year	<condition attribute="createdon" operator="in-or-after-fiscal-period-and-year"> <value>01</value> <value>2015</value> </condition>	WHERE CreatedOn >= '2015-01-01 06:00:00'
In or Before Fiscal Period	in-or-before-fiscal-period-and-year	<condition attribute="createdon" operator="in-or-before-fiscal-period-and-year"> <value>01</value> <value>2015</value> </condition>	WHERE CreatedOn < '2015-04-01 05:00:00'
Last Fiscal Year	last-fiscal-year	<condition attribute="createdon"operator="last-fiscal-year"/>	WHERE CreatedOn >= '2014-01-01 06:00:00' AND CreatedOn < '2015-01-01 06:00:00'
This Fiscal Year	this-fiscal-year	<condition attribute="createdon"operator="this-fiscal-year"/>	WHERE CreatedOn >= '2015-01-01 06:00:00' AND CreatedOn < '2016-01-01 06:00:00'
Next Fiscal Year	next-fiscal-year	<condition attribute="createdon"operator="next-fiscal-year"/>	WHERE CreatedOn >= '2016-01-01 06:00:00' AND CreatedOn < '2017-01-01 06:00:00'
Last X Fiscal Year	last-x-fiscal-years	<condition attribute="createdon" value="1" operator="last-x-fiscal-years"/>	WHERE CreatedOn >= '2014-01-01 06:00:00' AND CreatedOn < '2015-01-01 06:00:00'
Next X Fiscal Year	next-x-fiscal-years	<condition attribute="createdon" value="1" operator="next-x-fiscal-years"/>	WHERE CreatedOn >= '2016-01-01 06:00:00' AND CreatedOn < '2017-01-01 06:00:00'
Last Fiscal Period	last-fiscal-period	<condition attribute="createdon"operator="last-fiscal-period"/>	WHERE CreatedOn >= '2015-01-01 06:00:00' AND CreatedOn < '2015-04-01 05:00:00'
This Fiscal Period	this-fiscal-period	<condition attribute="createdon"operator="this-fiscal-period"/>	WHERE CreatedOn >= '2015-04-01 05:00:00' AND CreatedOn < '2015-07-01 05:00:00'
Next Fiscal Period	next-fiscal-period	<condition attribute="createdon"operator="next-fiscal-period"/>	WHERE CreatedOn >= '2015-07-01 05:00:00' AND CreatedOn < '2015-10-01 05:00:00'
Last X Fiscal Period	last-x-fiscal-periods	<condition attribute="createdon" value="1" operator="last-x-fiscal-periods"/>	WHERE CreatedOn >= '2015-01-01 06:00:00' AND CreatedOn < '2015-04-01 05:00:00'
Next X Fiscal Period	next-x-fiscal-periods	<condition attribute="createdon" value="1" operator="next-x-fiscal-periods"/>	WHERE CreatedOn >= '2015-07-01 05:00:00' AND CreatedOn < '2015-10-01 05:00:00'