private QvDataContractResponse GetPreview(UserParameter parameter, string appId, string objectId) { q2gconhypercubemain.Connection connection = null; try { var oId = GetObjectId(objectId); if (String.IsNullOrEmpty(oId)) { throw new Exception("no object id for preview table found."); } var config = QlikApp.CreateConfig(parameter, appId); var qlikApp = new QlikApp(parameter); connection = qlikApp.CreateNewConnection(config); var script = ScriptCode.Create(appId, oId); var resultTable = tableFunctions.GetTableInfosFromApp("PreviewTable", script, connection.CurrentApp); if (resultTable == null) { throw new Exception("no preview table found."); } return(PreviewResponse.Create(resultTable.Preview)); } catch (Exception ex) { logger.Error(ex, $"fields from app {appId} and table {objectId} not loaded."); return(new PreviewResponse()); } finally { connection?.Close(); } }
public List <DocListEntry> GetAllApps(ConnectionConfig config) { Connection conn = null; try { conn = new Connection(null, config); var global = conn.GetGlobelContext(); var apps = global.GetDocListAsync().Result; if (apps == null) { return(new List <DocListEntry>()); } else { return(apps); } } catch (Exception ex) { logger.Error(ex, $"The method {nameof(GetAllApps)} failed."); return(new List <DocListEntry>()); } finally { conn?.Close(); } }
private ResultTable GetData(ScriptCode script, UserParameter parameter) { q2gconhypercubemain.Connection connection = null; try { var config = QlikApp.CreateConfig(parameter, script.AppId); var qlikApp = new QlikApp(parameter); connection = qlikApp.CreateNewConnection(config); if (!connection.Connect()) { return(null); } foreach (var filter in script.Filter) { logger.Debug($"Filter: {filter}"); foreach (var value in filter.Values) { var selection = new QlikSelections(connection.CurrentApp); var result = selection.SelectValue(filter.Name, value); if (result == false) { logger.Error($"The Dimension \"{filter.Name}\" could not found."); return(null); } } } var resultTable = tableFunctions.GetTableInfosFromApp($"Table_{script.AppId}_{script.ObjectId}", script, connection.CurrentApp); return(resultTable.QvxTable); } catch (Exception ex) { logger.Error(ex, "The table script can not be executed."); return(null); } finally { connection?.Close(); } }
private QvDataContractResponse GetFields(UserParameter parameter, string appId, string objectId) { q2gconhypercubemain.Connection connection = null; using (MappedDiagnosticsLogicalContext.SetScoped("connectionId", connection?.ConnId)) { try { var oId = GetObjectId(objectId); if (String.IsNullOrEmpty(oId)) { throw new Exception("no object id for field table found."); } var script = ScriptCode.Create(appId, oId); var config = QlikApp.CreateConfig(parameter, appId); var qlikApp = new QlikApp(parameter); connection = qlikApp.CreateNewConnection(config); var resultTable = tableFunctions.GetTableInfosFromApp("FieldTable", script, connection.CurrentApp); if (resultTable == null) { throw new Exception("no field table found."); } var qvxTable = TableUtilities.ConvertTable(resultTable.QvxTable); return(new QvDataContractFieldListResponse { qFields = qvxTable.Fields }); } catch (Exception ex) { logger.Error(ex, $"fields from app {appId} and table {objectId} not loaded."); return(new QvDataContractFieldListResponse { qFields = new QvxField[0] }); } finally { connection?.Close(); } } }
private QvDataContractResponse GetTables(UserParameter parameter, string appName) { var tables = new List <QvxTable>(); q2gconhypercubemain.Connection connection = null; using (MappedDiagnosticsLogicalContext.SetScoped("connectionId", connection?.ConnId)) { try { var config = QlikApp.CreateConfig(parameter, appName); var qlikApp = new QlikApp(parameter); var appId = qlikApp.GetAllApps(config).FirstOrDefault(a => a.qDocName == appName).qDocId; config = QlikApp.CreateConfig(parameter, appId); connection = qlikApp.CreateNewConnection(config); var options = new NxGetObjectOptions() { qTypes = new List <string> { "table" } }; var tablesObjects = connection.CurrentApp.GetObjectsAsync(options).Result; foreach (var obj in tablesObjects) { var tableObject = connection.CurrentApp.GetObjectAsync(obj.qInfo.qId).Result; dynamic layout = tableObject.GetLayoutAsync <JObject>().Result; tables.Add(new QvxTable() { TableName = $"{layout.title} [{obj.qInfo.qId}]" }); } options = new NxGetObjectOptions() { qTypes = new List <string> { "masterobject" } }; var visualisations = connection.CurrentApp.GetObjectsAsync(options).Result; foreach (var element in visualisations) { var tableObject = connection.CurrentApp.GetObjectAsync(element.qInfo.qId).Result; dynamic layout = tableObject.GetLayoutAsync <JObject>().Result; tables.Add(new QvxTable() { TableName = $"{layout.qMeta.title} [{element.qInfo.qId}]" }); } return(new QvDataContractTableListResponse { qTables = tables }); } catch (Exception ex) { logger.Error(ex, $"tables form app {appName} not loaded."); return(new QvDataContractTableListResponse { qTables = tables }); } finally { connection?.Close(); } } }