0

I predefined my data source. I want to specify multiple paths in one query. For example Here is my datasource ;

  const Jforce_DataSource = {
    Name: 'Jforce',
    ConnectionProperties: {
      DataProvider: 'JSON',
      ConnectString: 'endpoint=http://localhost:3001/',
    },
  };

  const dataSources = [
    {
      id: 'Jforce',
      title: 'Jforce',
      template: Jforce_DataSource,
      canEdit: false,
      datasets: collections.map((collection) => {
        return {
          id: collection,
          title: collection,
          template: {
            Name: collection,
            Query: { DataSourceName: 'Jforce', CommandText: `uri=/${collection};jpath=$.[*].Statistics.Platforms[*];jpath=$.[*].Measurements[*]` },
            
            Fields: [
              { Name: '_id', DataField: '_id' },
              { Name: 'Date', DataField: 'Run.Date' },
              { Name: 'Index', DataField: 'Run.Index' },
              { Name: 'ScenarioName', DataField: 'Run.Scenario.Name' },
              { Name: 'ScenarioDatabase', DataField: 'Run.Scenario.Database' },
              { Name: 'SvnAddress', DataField: 'Run.Svn.Address' },
              { Name: 'SvnRevision', DataField: 'Run.Svn.Revision' },

              { Name: 'PlatformProfile', DataField: 'PProfile' },
              { Name: 'PlatformType', DataField: 'PType' },
              { Name: 'PlatformForce', DataField: 'PForce' },
              { Name: 'PlatformTotal', DataField: 'PTotal' },
              { Name: 'PlatformWrecked', DataField: 'PWrecked' },
              { Name: 'PlatformDestroyed', DataField: 'PDestroyed' },
              { Name: 'WeaponProfile', DataField: 'WProfile' },
              { Name: 'WeaponType', DataField: 'WType' },
              { Name: 'WeaponForce', DataField: 'WForce' },
              { Name: 'WeaponTotal', DataField: 'WTotal' },
              { Name: 'WeaponHit', DataField: 'WHit' },
              { Name: 'WeaponMissed', DataField: 'WMissed' },

              { Name: 'VariableType', DataField: 'VType' },
              { Name: 'VariableConfiguration', DataField: 'VConfiguration' },
              { Name: 'VariableValue', DataField: 'VVaue' },

              { Name: 'MeasurementType', DataField: 'MType' },
              { Name: 'MeasurementConfiguration', DataField: 'MConfiguration' },
              { Name: 'MeasurementValue', DataField: 'MValue' },
            ],
          },
          canEdit: true,
        };
      }),
    },
  ];

I want to retrieve both Statistics.Platforms and Measurements. When I try

CommandText: `uri=/${collection};jpath=$.[*].Statistics.Platforms[*];jpath=$.[*].Measurements[*]`

I can retrieve Measurements but I can not Statistics.Platforms. I'm glad if you can help.

user
  • 1
  • 3

0 Answers0