Created
January 19, 2021 18:30
-
-
Save sampetrosov/4337bd49c93537fa40b0ffde694bf92c to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="utf-8" standalone="yes"?> | |
<data-set> | |
<relations format-version="3" relations-version="20201014" main-table="GIDesign" stable-sharing="True" file-name="(Name)"> | |
<link from="GIFilter (DesignID)" to="GIDesign (DesignID)" /> | |
<link from="GIGroupBy (DesignID)" to="GIDesign (DesignID)" /> | |
<link from="GIMassAction (DesignID)" to="GIDesign (DesignID)" /> | |
<link from="GIMassUpdateField (DesignID)" to="GIDesign (DesignID)" /> | |
<link from="GINavigationScreen (DesignID)" to="GIDesign (DesignID)" /> | |
<link from="GINavigationParameter (DesignID, NavigationScreenLineNbr)" to="GINavigationScreen (DesignID, LineNbr)" /> | |
<link from="GIOn (DesignID, RelationNbr)" to="GIRelation (DesignID, LineNbr)" /> | |
<link from="GIRecordDefault (DesignID)" to="GIDesign (DesignID)" /> | |
<link from="GIRelation (DesignID, ParentTable)" to="GITable (DesignID, Alias)" /> | |
<link from="GIRelation (DesignID, ChildTable)" to="GITable (DesignID, Alias)" /> | |
<link from="GIResult (DesignID)" to="GIDesign (DesignID)" /> | |
<link from="GIResult (ObjectName, DesignID)" to="GITable (Alias, DesignID)" /> | |
<link from="GISort (DesignID)" to="GIDesign (DesignID)" /> | |
<link from="GITable (DesignID)" to="GIDesign (DesignID)" /> | |
<link from="GIWhere (DesignID)" to="GIDesign (DesignID)" /> | |
<link from="SiteMap (Url)" to="GIDesign (DesignID)" type="WeakByUrl" linkname="toDesignById" baseurl="~/GenericInquiry/GenericInquiry.aspx" paramnames="id" /> | |
<link from="SiteMap (Url)" to="GIDesign (Name)" type="WeakByUrl" linkname="toDesignByName" baseurl="~/GenericInquiry/GenericInquiry.aspx" /> | |
<link from="ListEntryPoint (ListScreenID)" to="SiteMap (ScreenID)" /> | |
<link from="SiteMap (ScreenID)" to="GIDesign (PrimaryScreenIDNew)" linkname="to1Screen" /> | |
<link from="FilterHeader (ScreenID)" to="SiteMap (ScreenID)" /> | |
<link from="FilterRow (FilterID)" to="FilterHeader (FilterID)" /> | |
<link from="PivotTable (NoteID)" to="FilterHeader (RefNoteID)" /> | |
<link from="PivotField (ScreenID, PivotTableID)" to="PivotTable (ScreenID, PivotTableID)" /> | |
<link from="MUIScreen (NodeID)" to="SiteMap (NodeID)" /> | |
<link from="MUIWorkspace (WorkspaceID)" to="MUIScreen (WorkspaceID)" type="FromMaster" linkname="workspaceToScreen" split-location="yes" updateable="True" /> | |
<link from="MUISubcategory (SubcategoryID)" to="MUIScreen (SubcategoryID)" type="FromMaster" updateable="True" /> | |
<link from="MUITile (ScreenID)" to="SiteMap (ScreenID)" /> | |
<link from="MUIWorkspace (WorkspaceID)" to="MUITile (WorkspaceID)" type="FromMaster" linkname="workspaceToTile" split-location="yes" updateable="True" /> | |
<link from="MUIArea (AreaID)" to="MUIWorkspace (AreaID)" type="FromMaster" updateable="True" /> | |
<link from="MUIPinnedScreen (NodeID, WorkspaceID)" to="MUIScreen (NodeID, WorkspaceID)" type="WeakIfEmpty" isEmpty="Username" /> | |
<link from="MUIFavoriteWorkspace (WorkspaceID)" to="MUIWorkspace (WorkspaceID)" type="WeakIfEmpty" isEmpty="Username" /> | |
<link from="GIDesign (NoteID)" to="Note (NoteID)" type="Note" /> | |
<link from="GIFilter (NoteID)" to="Note (NoteID)" type="Note" /> | |
<link from="GIFilter (NoteID)" to="GIFilterKvExt (RecordID)" type="RowKvExt" /> | |
<link from="GIGroupBy (NoteID)" to="Note (NoteID)" type="Note" /> | |
<link from="GIOn (NoteID)" to="Note (NoteID)" type="Note" /> | |
<link from="GIRelation (NoteID)" to="Note (NoteID)" type="Note" /> | |
<link from="GIResult (NoteID)" to="Note (NoteID)" type="Note" /> | |
<link from="GIResult (NoteID)" to="GIResultKvExt (RecordID)" type="RowKvExt" /> | |
<link from="GISort (NoteID)" to="Note (NoteID)" type="Note" /> | |
<link from="GITable (NoteID)" to="Note (NoteID)" type="Note" /> | |
<link from="GIWhere (NoteID)" to="Note (NoteID)" type="Note" /> | |
<link from="FilterHeader (NoteID)" to="Note (NoteID)" type="Note" /> | |
</relations> | |
<layout> | |
<table name="GIDesign"> | |
<table name="GIFilter" uplink="(DesignID) = (DesignID)"> | |
<table name="Note" uplink="(NoteID) = (NoteID)" /> | |
<table name="GIFilterKvExt" uplink="(NoteID) = (RecordID)" /> | |
</table> | |
<table name="GIGroupBy" uplink="(DesignID) = (DesignID)"> | |
<table name="Note" uplink="(NoteID) = (NoteID)" /> | |
</table> | |
<table name="GIMassAction" uplink="(DesignID) = (DesignID)" /> | |
<table name="GIMassUpdateField" uplink="(DesignID) = (DesignID)" /> | |
<table name="GINavigationScreen" uplink="(DesignID) = (DesignID)"> | |
<table name="GINavigationParameter" uplink="(DesignID, LineNbr) = (DesignID, NavigationScreenLineNbr)" /> | |
</table> | |
<table name="GIRecordDefault" uplink="(DesignID) = (DesignID)" /> | |
<table name="GISort" uplink="(DesignID) = (DesignID)"> | |
<table name="Note" uplink="(NoteID) = (NoteID)" /> | |
</table> | |
<table name="GITable" uplink="(DesignID) = (DesignID)"> | |
<table name="GIRelation" uplink="(DesignID, Alias) = (DesignID, ParentTable)"> | |
<table name="GIOn" uplink="(DesignID, LineNbr) = (DesignID, RelationNbr)"> | |
<table name="Note" uplink="(NoteID) = (NoteID)" /> | |
</table> | |
<table name="Note" uplink="(NoteID) = (NoteID)" /> | |
</table> | |
<table name="GIResult" uplink="(Alias, DesignID) = (ObjectName, DesignID)"> | |
<table name="Note" uplink="(NoteID) = (NoteID)" /> | |
<table name="GIResultKvExt" uplink="(NoteID) = (RecordID)" /> | |
</table> | |
<table name="Note" uplink="(NoteID) = (NoteID)" /> | |
</table> | |
<table name="GIWhere" uplink="(DesignID) = (DesignID)"> | |
<table name="Note" uplink="(NoteID) = (NoteID)" /> | |
</table> | |
<table name="SiteMap" uplink="(DesignID) = (Url)" linkname="toDesignById"> | |
<table name="ListEntryPoint" uplink="(ScreenID) = (ListScreenID)" /> | |
<table name="FilterHeader" uplink="(ScreenID) = (ScreenID)"> | |
<table name="FilterRow" uplink="(FilterID) = (FilterID)" /> | |
<table name="PivotTable" uplink="(RefNoteID) = (NoteID)"> | |
<table name="PivotField" uplink="(ScreenID, PivotTableID) = (ScreenID, PivotTableID)" /> | |
</table> | |
<table name="Note" uplink="(NoteID) = (NoteID)" /> | |
</table> | |
<table name="MUIScreen" uplink="(NodeID) = (NodeID)"> | |
<table name="MUIPinnedScreen" uplink="(NodeID, WorkspaceID) = (NodeID, WorkspaceID)" /> | |
</table> | |
<table name="MUITile" uplink="(ScreenID) = (ScreenID)" /> | |
</table> | |
<table name="SiteMap" uplink="(Name) = (Url)" linkname="toDesignByName"> | |
<table name="ListEntryPoint" uplink="(ScreenID) = (ListScreenID)" /> | |
<table name="FilterHeader" uplink="(ScreenID) = (ScreenID)"> | |
<table name="FilterRow" uplink="(FilterID) = (FilterID)" /> | |
<table name="PivotTable" uplink="(RefNoteID) = (NoteID)"> | |
<table name="PivotField" uplink="(ScreenID, PivotTableID) = (ScreenID, PivotTableID)" /> | |
</table> | |
<table name="Note" uplink="(NoteID) = (NoteID)" /> | |
</table> | |
<table name="MUIScreen" uplink="(NodeID) = (NodeID)"> | |
<table name="MUIPinnedScreen" uplink="(NodeID, WorkspaceID) = (NodeID, WorkspaceID)" /> | |
</table> | |
<table name="MUITile" uplink="(ScreenID) = (ScreenID)" /> | |
</table> | |
<table name="SiteMap" uplink="(PrimaryScreenIDNew) = (ScreenID)" linkname="to1Screen"> | |
<table name="ListEntryPoint" uplink="(ScreenID) = (ListScreenID)" /> | |
<table name="FilterHeader" uplink="(ScreenID) = (ScreenID)"> | |
<table name="FilterRow" uplink="(FilterID) = (FilterID)" /> | |
<table name="PivotTable" uplink="(RefNoteID) = (NoteID)"> | |
<table name="PivotField" uplink="(ScreenID, PivotTableID) = (ScreenID, PivotTableID)" /> | |
</table> | |
<table name="Note" uplink="(NoteID) = (NoteID)" /> | |
</table> | |
<table name="MUIScreen" uplink="(NodeID) = (NodeID)"> | |
<table name="MUIPinnedScreen" uplink="(NodeID, WorkspaceID) = (NodeID, WorkspaceID)" /> | |
</table> | |
<table name="MUITile" uplink="(ScreenID) = (ScreenID)" /> | |
</table> | |
<table name="Note" uplink="(NoteID) = (NoteID)" /> | |
</table> | |
<table name="MUIWorkspace"> | |
<table name="MUIFavoriteWorkspace" uplink="(WorkspaceID) = (WorkspaceID)" /> | |
</table> | |
<table name="MUISubcategory" /> | |
<table name="MUIArea" /> | |
</layout> | |
<data> | |
<GIDesign> | |
<row DesignID="b9b87e8c-1cd8-421d-86c8-d3cbb947215e" Name="DB-ProjectProductivityByDate" FilterColCount="3" PageSize="0" ExportTop="0" NewRecordCreationEnabled="0" MassDeleteEnabled="0" AutoConfirmDelete="0" MassRecordsUpdateEnabled="0" MassActionsOnRecordsEnabled="0" ExposeViaOData="0" ExposeViaMobile="0" RowStyleFormula="=IIF(PMTimeActivity_FormulaA4A7ACEFFCC1444DA018CE78DD1BFCA3>=70,'good', IIF(PMTimeActivity_FormulaA4A7ACEFFCC1444DA018CE78DD1BFCA3>=40, 'orange40','bad'))" ShowDeletedRecords="0"> | |
<GIFilter LineNbr="1" IsActive="1" Name="Project" FieldName="PMProject.contractCD" DataType="string" DisplayName="Project" IsExpression="1" DefaultValue="2017PROG01" ColSpan="1" Required="1" /> | |
<GIGroupBy LineNbr="2" IsActive="1" DataFieldName="=Year([PMTimeActivity.Date])*10000 +[PMTimeActivity.Date_Month]*100+[PMTimeActivity.Date_Day]" /> | |
<GIGroupBy LineNbr="1" IsActive="1" DataFieldName="PMTimeActivity.projectID" /> | |
<GISort LineNbr="2" IsActive="1" DataFieldName="PMTimeActivity.date" SortOrder="D" /> | |
<GISort LineNbr="1" IsActive="1" DataFieldName="PMProject.contractCD" SortOrder="A" /> | |
<GITable Alias="PMTimeActivity" Name="PX.Objects.CR.PMTimeActivity"> | |
<GIRelation LineNbr="1" ChildTable="PMProject" IsActive="1" JoinType="I"> | |
<GIOn LineNbr="1" ParentField="ProjectID" Condition="E " ChildField="ContractID" Operation="A" /> | |
</GIRelation> | |
<GIResult LineNbr="7" SortOrder="6" IsActive="1" Field="=100* CDec([PMTimeActivity.TimeBillable])/60 / 8" SchemaField="PMProject.Balance" Caption="Productivity" IsVisible="1" DefaultNav="1" AggregateFunction="SUM" QuickFilter="0" FastFilter="1" RowID="a4a7acef-fcc1-444d-a018-ce78dd1bfca3" /> | |
<GIResult LineNbr="6" SortOrder="5" IsActive="1" Field="timeBillable" IsVisible="1" DefaultNav="1" QuickFilter="0" FastFilter="1" RowID="112ddf12-71a5-414b-8cbf-4a0bb7aff04d" /> | |
<GIResult LineNbr="5" SortOrder="4" IsActive="1" Field="timeSpent" IsVisible="1" DefaultNav="1" QuickFilter="0" FastFilter="1" RowID="273e403c-d83b-4c87-b030-4104fa9768a0" /> | |
<GIResult LineNbr="1" SortOrder="1" IsActive="1" Field="Date" IsVisible="1" DefaultNav="1" QuickFilter="0" FastFilter="0" RowID="57e70327-c2ce-4db8-bccf-0bc4afa29171" /> | |
</GITable> | |
<GITable Alias="PMProject" Name="PX.Objects.PM.PMProject"> | |
<GIResult LineNbr="4" SortOrder="3" IsActive="1" Field="description" Width="300" IsVisible="1" DefaultNav="1" QuickFilter="0" FastFilter="1" RowID="bf1d137b-455c-40a5-b16f-a1b938a06373" /> | |
<GIResult LineNbr="2" SortOrder="2" IsActive="1" Field="contractCD" Width="120" IsVisible="1" DefaultNav="0" QuickFilter="0" FastFilter="1" RowID="5ab8610f-7e62-44a4-af1f-d2590f83c6d2" /> | |
</GITable> | |
<GIWhere LineNbr="1" IsActive="1" DataFieldName="PMProject.contractCD" Condition="E " IsExpression="0" Value1="[Project]" Operation="A" /> | |
<SiteMap linkname="toDesignById"> | |
<row Title="DB Project Productivity By Date" Url="~/GenericInquiry/GenericInquiry.aspx?id=b9b87e8c-1cd8-421d-86c8-d3cbb947215e" ScreenID="GI640096" NodeID="0ecc0453-56a3-419d-9598-2f6a5ccee7bd" ParentID="00000000-0000-0000-0000-000000000000"> | |
<MUIScreen IsPortal="0" WorkspaceID="bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb" Order="30" SubcategoryID="cee2f0b1-07be-4d51-82f9-6d64b05e9ee7"> | |
<MUIPinnedScreen IsPortal="0" Username="" IsPinned="1" /> | |
</MUIScreen> | |
</row> | |
</SiteMap> | |
</row> | |
</GIDesign> | |
<MUIWorkspace> | |
<row IsPortal="1" WorkspaceID="bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb" Order="5" Title="Data Views" Icon="poll" IsSystem="1"> | |
<MUIFavoriteWorkspace IsPortal="0" Username="" IsFavorite="1" /> | |
</row> | |
<row IsPortal="0" WorkspaceID="bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb" Order="32" Title="Data Views" Icon="poll" IsSystem="1"> | |
<MUIFavoriteWorkspace IsPortal="0" Username="" IsFavorite="1" /> | |
</row> | |
</MUIWorkspace> | |
<MUISubcategory> | |
<row IsPortal="0" SubcategoryID="cee2f0b1-07be-4d51-82f9-6d64b05e9ee7" Order="1464" Name="Dashboard: Project" Icon="" IsSystem="0" /> | |
</MUISubcategory> | |
</data> | |
</data-set> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment