[Export(typeof(IAdHocExtension))]publicclassAdHocExtensionSample:DefaultAdHocExtension{publicoverrideList<string>OnPreLoadFilterData(ReportFilterSettingfilterSetting,outboolhandled){handled=false;List<String>result=null;if(filterSetting.FilterFields.Count==1&&filterSetting.FilterFields.Any(x=>x.SourceDataObjectName.Equals("OrdersByRegion")&&x.SourceFieldName.Equals("CountryRegionName"))){handled=true;result=newList<string>(){"Europe","North America","South America"};}returnresult;}}

[Export(typeof(IAdHocExtension))]publicclassAdHocExtensionSample:DefaultAdHocExtension{publicoverrideList<string>OnPostLoadFilterData(ReportFilterFieldfilterField,List<string>data){// override dropdown value based on user role for filter on view "OrderDetailsByRegion" and field "CountryRegionName"if(filterField.SourceDataObjectName=="OrderDetailsByRegion"&&filterField.SourceFieldName=="CountryRegionName"&&HttpContext.Current.User.IsInRole("Employee")){varindexEU=data.IndexOf("Europe");if(indexEU!=-1)data[indexEU]="EU";}returnbase.OnPostLoadFilterData(filterField,data);}}

[Export(typeof(IAdHocExtension))]publicclassAdHocExtensionSample:DefaultAdHocExtension{publicoverrideReportDefinitionOnPreExecute(ReportDefinitionreport){if(report.ReportPart.Any(x=>x.ReportPartContent.Type==ReportPartContentType.Map)){varfilteredReportPart=report.ReportPart.Where(x=>x.ReportPartContent.Type!=ReportPartContentType.Map).ToList();report.ReportPart=filteredReportPart;}returnreport;}}

[Export(typeof(IAdHocExtension))]publicclassAdHocExtensionSample:DefaultAdHocExtension{publicoverrideQueryTreeOnExecuting(QueryTreequeryTree){varnodeVisitor=newQueryTreePathAnalyzeVisitor(newExtensibilityFactory(),queryTree.ContextData);nodeVisitor.ContextData=queryTree.ContextData;queryTree.Root.Accept(nodeVisitor);varresultLimitOperator=newResultLimitOperator(){ChildOperand=newOperand(){QuerySource=newQuerySource()}};try{nodeVisitor.Visit(resultLimitOperator);}catch(Exception){Console.WriteLine("LOG: Query with no limit");}returnqueryTree;}}

[Export(typeof(IAdHocExtension))]publicclassAdHocExtensionSample:DefaultAdHocExtension{publicoverrideList<IDictionary<string,object>>OnPostExecute(QueryTreeexecutedQueryTree,List<IDictionary<string,object>>result){returnresult.Take(1000).ToList();}}

[Export(typeof(IAdHocExtension))]
						public override ReportFilterSetting SetHiddenFilters(SetHiddenFilterParam param)
						{
						var filterFieldName = "ShipRegion";
						Func<ReportFilterSetting, int, QuerySource, QuerySourceField, Guid, Relationship, int> addHiddenFilters = (result, filterPosition, querySource, field, equalOperator, rel) =>
						{
						var firstFilter = new ReportFilterField
						{
						Alias = $"ShipRegion{filterPosition}",
						QuerySourceId = querySource.Id,
						SourceDataObjectName = querySource.Name,
						QuerySourceType = querySource.Type,
						QuerySourceFieldId = field.Id,
						SourceFieldName = field.Name,
						DataType = field.IzendaDataType,
						Position = ++filterPosition,
						OperatorId = equalOperator,
						Value = "WA",
						RelationshipId = rel?.Id,
						IsParameter = false,
						ReportFieldAlias = null
						};
						var secondFilter = new ReportFilterField
						{
						Alias = $"ShipRegion{filterPosition}",
						QuerySourceId = querySource.Id,
						SourceDataObjectName = querySource.Name,
						QuerySourceType = querySource.Type,
						QuerySourceFieldId = field.Id,
						SourceFieldName = field.Name,
						DataType = field.IzendaDataType,
						Position = ++filterPosition,
						OperatorId = equalOperator,
						Value = "[Blank]",
						RelationshipId = rel?.Id,
						IsParameter = false,
						ReportFieldAlias = null
						};
						result.FilterFields.Add(firstFilter);
						result.FilterFields.Add(secondFilter);
						var logic = $"({filterPosition - 1} OR {filterPosition})";
						if (string.IsNullOrEmpty(result.Logic))
						{
						result.Logic = logic;
						}
						return filterPosition;
						};
						var filterSetting = new ReportFilterSetting()
						{
						FilterFields = new List<ReportFilterField>()
						};
						var position = 0;
						var ds = param.ReportDefinition.ReportDataSource;
						// Build the hidden filters for ship country fields
						foreach (var querySource in param.QuerySources // Scan thru the query sources that are involved in the report
						.Where(x => x.QuerySourceFields.Any(y => y.Name.Equals(filterFieldName, StringComparison.OrdinalIgnoreCase)))) // Take only query sources that have filter field name
						{
						// Pick the relationships that joins the query source as primary source
						// Setting the join ensure the proper table is assigned when using join alias in the UI
						var rels = param.ReportDefinition.ReportRelationship.
						Where(x => x.JoinQuerySourceId == querySource.Id)
						.ToList();
						// Count the relationships that the filter query source is foreign query source
						var foreignRelCounts = param.ReportDefinition.ReportRelationship
						.Where(x => x.ForeignQuerySourceId == querySource.Id)
						.Count();
						// Find actual filter field in query source
						var field = querySource.QuerySourceFields.FirstOrDefault(x => x.Name.Equals(filterFieldName, StringComparison.OrdinalIgnoreCase));
						// Pick the equal operator
						var equalOperator = Izenda.BI.Framework.Enums.FilterOperator.FilterOperator.EqualsManualEntry.GetUid();
						// In case there is no relationship that the query source is joined as primary
						if (rels.Count() == 0)
						{
						// Just add hidden filter with null relationship
						position = addHiddenFilters(filterSetting, position, querySource, field, equalOperator, null);
						}
						else
						{
						// Add another hidden filter for query source that appears in both alias primary and foreign query source of relationships.
						// This step is mandatory because when aliasing a primary query source, it becomes another instance of query source in the query.
						// So if we only add filter for alias, the original query source instance will not be impacted by the filter. That's why we need
						// to add another filter for original instance when it appears in both side of alias and foreign.
						// For example:
						//          [Order] LEFT JOIN [Employee]
						//      [Aliased Employee] LEFT JOIN [Department]
						// If the system needs to add a hidden filter to [Employee], for example: [CompanyId] = 'ALKA'
						// It needs to add
						//          [Employee].[CompanyId] = 'ALKA' AND [Aliased Employee].[CompanyId] = 'ALKA'
						// By this way, it ensures all [Employee] instances are filtered by ALKA company id.
						if (foreignRelCounts > 0)
						{
						position = addHiddenFilters(filterSetting, position, querySource, field, equalOperator, null);
						}
						foreach (var rel in rels)
						{
						// Loop thru all relationships that the query source is joined as primary and add the hidden field associated with each relationship
						position = addHiddenFilters(filterSetting, position, querySource, field, equalOperator, rel);
						}
						}
						}
						return filterSetting;
						}
					

if(String.Compare(currentUserName,"userName")==0){result.Logic="(1 or 2 or 3)";//The logic, something like "1 AND 2 OR 3"//Equal operatorvarequalOperator=param.FilterOperatorGroups.First(x=>x.Name.Equals("Equivalence")).FilterOperators.First(x=>x.Name.Equals("Equals (Selection)"));//Filter Order.ShipContry = USAstring[]valArray={"USA","Argentina","Germany"};varquerySouce=param.QuerySources.First(x=>x.Name.Equals("Orders"));varfield=querySouce.QuerySourceFields.First(x=>x.Name.Equals("ShipCountry"));for(inti=0;i<valArray.Length;i++){varreportFilterField=newReportFilterField{QuerySourceId=querySouce.Id,SourceDataObjectName=querySouce.Name,QuerySourceType=querySouce.Type,QuerySourceFieldId=field.Id,SourceFieldName=field.Name,DataType=field.DataType,Position=i+1,OperatorId=equalOperator.Id,Value=valStr[i],RelationshipId=null,IsParameter=false,ReportFieldAlias=null};filterFields.Add(reportFilterField);}}

usingOperator=Izenda.BI.Framework.Enums.DateTimeOperator;[Export(typeof(IAdHocExtension))]publicclassCustomAdhocReport:DefaultAdHocExtension{publicoverrideList<CustomTimePeriod>LoadCustomTimePeriod(){varresult=newList<CustomTimePeriod>{newCustomTimePeriod("Tomorrow",DateTime.Now,DateTime.Now.AddDays(1),Operator.BetweenDateTime),newCustomTimePeriod("Previous Date -> DateTime Now",()=>DateTime.Now.AddDays(-1),()=>DateTime.Now,Operator.BetweenDateTime),newCustomTimePeriod("Less Than 2 Days Old",2,Operator.LessThanDaysOld),newCustomTimePeriod("Greater Than 2 Days Old",()=>2,Operator.GreaterThanDaysOld),newCustomTimePeriod(">= Date Time Now + 2 Days",DateTime.Now.AddDays(2),Operator.GreaterThanOrEqualsCalender),newCustomTimePeriod("<= Date Time Now - 2 Days",()=>DateTime.Now.AddDays(-2),Operator.LessThanOrEqualsCalendar)};returnresult;}}

/// <summary>/// Loads the defined custom formats into the Izenda application////// <see href="https://msdn.microsoft.com/en-us/library/dwhawy9k(v=vs.110).aspx">Standard Numeric Format Strings</see>/// </summary>/// <returns>A list of custom formats. </returns>publicoverrideList<DataFormat>LoadCustomDataFormat(){varresult=newList<DataFormat>{newDataFormat{Name="By Hour",DataType=DataType.DateTime,Category=IzendaKey.CustomFormat,FormatFunc=(x)=>{return((DateTime)x).ToString("M/d/yyyy h:00 tt");}},newDataFormat{Name="dd MM:mm",DataType=DataType.DateTime,Category=IzendaKey.CustomFormat,FormatFunc=(x)=>{vardate=Convert.ToDateTime(x);returndate.ToString("dd HH:mm");}},newDataFormat{Name="dd HH:mm:ss",DataType=DataType.DateTime,Category=IzendaKey.CustomFormat,FormatFunc=(x)=>{vardate=Convert.ToDateTime(x);returndate.ToString("dd HH:mm:ss");}},newDataFormat{Name="dd mm:ss",DataType=DataType.DateTime,Category=IzendaKey.CustomFormat,FormatFunc=(x)=>{vardate=Convert.ToDateTime(x);returndate.ToString("dd mm:ss");}},newDataFormat{Name="£0,000",DataType=DataType.Numeric,Category=IzendaKey.CustomFormat,FormatFunc=(x)=>{return((decimal)x).ToString("C0",CultureInfo.CreateSpecificCulture("en-GB"));}},newDataFormat{Name="¥0,000",DataType=DataType.Numeric,Category=IzendaKey.CustomFormat,FormatFunc=(x)=>{return((decimal)x).ToString("C0",CultureInfo.CreateSpecificCulture("ja-JP"));}},newDataFormat{Name="0,000",DataType=DataType.Numeric,Category=IzendaKey.CustomFormat,FormatFunc=(x)=>{returnString.Format(CultureInfo.InvariantCulture,"{0:0,0}",x);}},newDataFormat{Name="$0,000",DataType=DataType.Numeric,Category=IzendaKey.CustomFormat,FormatFunc=(x)=>{returnString.Format(CultureInfo.InvariantCulture,"${0:0,0}",x);}},newDataFormat{Name="HH:MM:SS",DataType=DataType.Numeric,Category=IzendaKey.CustomFormat,FormatFunc=(x)=>{varnewValue=Convert.ToDouble(x);TimeSpantime=TimeSpan.FromSeconds(newValue);returntime.ToString(@"dd\.hh\:mm\:ss");}}// Note: new in version 2.6.19// Custom DataFormat use JsFormatStringnewDataFormat{Name="2f km",//example: 2.00 km.DataType=DataType.Numeric,Category=IzendaKey.CustomFormat,JsFormatString="{value:.2f} km."},newDataFormat{Name="millisecond",DataType=DataType.DateTime,Category=IzendaKey.CustomFormat,JsFormatString="{value:%A, %b %e, %H:%M:%S.%L}",//A: Day of week//B: Month//b: Abbreviations of Month//e: Day//H: Hour//M: Minute//S: Second//L: MillisecondFormatDataType=DataType.DateTime},newDataFormat{Name="second",DataType=DataType.DateTime,Category=IzendaKey.CustomFormat,JsFormatString="{value:%H:%M:%S}",//H: Hour//M: Minute//S: SecondFormatDataType=DataType.DateTime},newDataFormat{Name="minute",DataType=DataType.DateTime,Category=IzendaKey.CustomFormat,JsFormatString="{value:%M}",FormatDataType=DataType.DateTime},newDataFormat{Name="hour",DataType=DataType.DateTime,Category=IzendaKey.CustomFormat,JsFormatString="{value:%H:%M}",},newDataFormat{Name="day",DataType=DataType.DateTime,Category=IzendaKey.CustomFormat,JsFormatString="{value:%A, %B %e, %Y}",//A: Day of week//B: Month//Y: YearFormatDataType=DataType.DateTime},newDataFormat{Name="week",DataType=DataType.DateTime,Category=IzendaKey.CustomFormat,JsFormatString="Week from {value:%A, %B %e, %Y}",//A: Day of week//B: Month//Y: YearFormatDataType=DataType.DateTime},newDataFormat{Name="month",DataType=DataType.DateTime,Category=IzendaKey.CustomFormat,JsFormatString="{value:%B %Y}",FormatDataType=DataType.DateTime},newDataFormat{Name="year",DataType=DataType.DateTime,Category=IzendaKey.CustomFormat,JsFormatString="Year {value:%Y}",FormatDataType=DataType.DateTime}//new in version 2.6.20newDataFormat{Name="2f km",//example: 2.00 km.DataType=DataType.Numeric,Category=IzendaKey.CustomFormat,JsFormatString="1k"//The name of the js format function}};returnresult;}

public class CustomWebUrlResolver : DefaultWebUrlResolver
						{
						private readonly ILog logger;
						public CustomWebUrlResolver()
						{
						this.logger = (new LogManager()).GetLogger<CustomWebUrlResolver>();
						}
						public override string ResolveUrl(string baseUrl, WebUrlActionLink action, Guid? id, Dictionary<string, object> parameters = null)
						{
						logger.Info($"Resolving the url of {action} on base url {baseUrl}");
						// Put logic to custom the web url here
						return base.ResolveUrl(baseUrl, action, id, parameters);
						}
						}
					

[Export(typeof(IAdHocExtension))]publicclassCustomAdhocReport:DefaultAdHocExtension{publicoverrideIWebUrlResolverWebUrlResolver=>newCustomWebUrlResolver();}

publicoverrideList<Theme>GetThemes(){returnnewList<Theme>{newTheme{Name="Classic",Colors=newList<string>{"#F9EA15","#F9EA15","#B4D335","#B4D335","#35B24D","#128076","#2C5AA8","#2C3185","#332A7B","#981E5B","#EE1D26","#F04323",}}};}

[Export(typeof(IAdHocExtension))]publicclassAdHocExtensionSample:DefaultAdHocExtension{publicoverridestringModifyQuery(stringquery,stringdatabase){if(database==SupportedDatabase.MSSQL){varqueryNodes=query.Split(new[]{';'});for(vari=0;i<queryNodes.Length;++i){varqueryNode=queryNodes[i];varisQueryOrdersTable=queryNode.Contains("FROM [dbo].[Orders]");if(isQueryOrdersTable){varsearchedExpression="SELECT";varfirstSelectClauseIndex=queryNode.IndexOf(searchedExpression);queryNodes[i]=queryNode.Insert(firstSelectClauseIndex+searchedExpression.Length," DISTINCT ");}}returnString.Join(";\r\n",queryNodes);}returnquery;}}