/// <summary>
/// Setup Parameters
/// </summary>
void GetParameters()
{
SpotfireViewProps sl = SpotfireViewProps;
sl.SpotfireLinkParameters = new Dictionary <string, SpotfireLinkParameter>();
QueryTable qt = CriteriaCols.QueryTable;
foreach (QueryColumn qc in qt.QueryColumns)
{
if (!qc.Selected)
{
continue;
}
MetaColumn mc = qc.MetaColumn;
SpotfireLinkParameter p = new SpotfireLinkParameter();
p.Name = mc.Name;
p.Value = "True";
SpotfireViewProps.SpotfireLinkParameters[p.Name] = p;
}
return;
}
/// <summary>
/// Setup Parameters
/// </summary>
void SetupParameters()
{
QueryColumn qc;
SpotfireViewProps sl = SpotfireViewProps;
Dictionary <string, SpotfireLinkParameter> p = sl.SpotfireLinkParameters;
if (p.Count == 0) // if no parameters then include one for CIDLIST checked
{
SpotfireLinkParameter p1 = new SpotfireLinkParameter("COMPOUND_ID", "True");
p[p1.Name] = p1;
}
QueryTable qt = CriteriaCols.QueryTable;
qt.DeselectAll();
foreach (SpotfireLinkParameter p0 in sl.SpotfireLinkParameters.Values)
{
qc = qt.GetQueryColumnByName(p0.Name);
if (qc == null)
{
continue;
}
bool selected = false;
bool.TryParse(p0.Value, out selected);
qc.Selected = selected;
}
qc = qt.GetQueryColumnByName("visualization"); // hide visualization col here
if (qc != null)
{
qc.MetaColumn.InitialSelection = ColumnSelectionEnum.Hidden; // hide visualization col here
qc.Selected = false;
}
CriteriaCols.TableHeaderLabel.Visible = false;
CriteriaCols.CanDeselectKeyCol = true;
CriteriaCols.Render();
return;
}
/// <summary>
/// Build Url for analysis including prompting for any parameters
/// Example: https://[server></server>/SpotfireWeb/ViewAnalysis.aspx?file=/Mobius/Visualizations/MdbAssay_MOBIUS&configurationBlock=CorpId_LIST={1,3,5};
/// </summary>
/// <param name="sl"></param>
/// <returns></returns>
static string BuildUrl(SpotfireViewProps sl)
{
string url = sl.GetWebplayerUrlOfAnalysis();
string parms = ""; // parm names & values for config block -
//foreach (SpotfireParameter p0 in sl.Parameters.Values)
//{
SpotfireLinkParameter p0 = new SpotfireLinkParameter();
p0.Name = "Compound Id";
string vals = InputBoxMx.Show(
"Enter desired values for " + p0.Name + ":\r\n" +
"Example: 1, 2, 3",
p0.Name + " Criteria");
if (vals == null)
{
return(null); // cancelled
}
if (parms != "")
{
parms += " ";
}
parms += "SQLPARMS=\"" + vals + "\"";
//parms += p0.Name + "={" + vals + "}";
//parms += p0.Name + "=\"" + vals + "\"";
//}
if (Lex.IsDefined(parms))
{
url += "&configurationBlock=" + parms + ";"; // add the parms in the config block
}
return(url);
}
