/// <summary>
/// If the user selected a field from a non-summarized table, give them the option to replace it with the field from the
/// summarized table (if available). Performance is better. This will also avoid extra rows as well as a cartesian product.
/// </summary>
private void CheckForSummarizedVersionOfMetaColumn()
{
return;
#if false // disabled for now
if (SelectedColumn == null || SelectedColumn.QueryColumn == null)
{
return;
}
QueryColumn qc = SelectedColumn.QueryColumn;
MetaColumn mc = qc.MetaColumn;
MetaTable mt = mc.MetaTable;
QueryTable qt = new QueryTable(mt);
bool unsummarrizedVersionSelected = (!mt.UseSummarizedData && mt.SummarizedExists);
if (!unsummarrizedVersionSelected)
{
return;
}
QueryTable summarizedQt = qt.AdjustSummarizationLevel(useSummarized: true);
QueryColumn summarizedQc = summarizedQt.GetQueryColumnByName(qc.ActiveLabel);
if (summarizedQc == null)
{
return;
}
string msg =
"You have selected the un-summarized version of " + qc.ActiveLabel + ".\n" +
"Using the summarized version will result in better performance and avoid unwanted extra rows.\n" +
"It is recommended that the summarized version be used for calculated fields.\n\n" +
"Would you like to use the summarized version instead?\n";
DialogResult dialogResult = MessageBoxMx.Show(msg, "Summarized Data Available!", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialogResult == DialogResult.Yes)
{
SelectedColumn = null //summarizedQc.MetaColumn;
return;
}
#endif
}