Im using Orion API to get query output but for Orion.Nodes iyts working fine but
Orion.Credential its showing error
{"query":"SELECT IPAddress,non.Caption,non.DNS,non.NodeDescription FROM Orion.Nodes as non where non.NodeID=1 ORDER BY non.NodeID WITH ROWS 1 TO 5"} ==> working fine
______________________________________________________________________________
{"query":"SELECT ID, Name, Description, CredentialType FROM Orion.Credential"}
=>
{"Message":"No concrete entities are derived from entity Orion.Credential","ExceptionType":"SolarWinds.Data.Query.ParserException","FullException":"SolarWinds.Data.Query.ParserException: No concrete entities are derived from entity Orion.Credential\r\n at SolarWinds.Data.Query.Processor.InheritanceExpander.Visit(SourceExpression source)\r\n at SolarWinds.Data.Query.Swql.ParseTreeDuplicatorNoState.Visit(FromClause from)\r\n at SolarWinds.Data.Query.Swql.ParseTreeDuplicatorNoState.Visit(SelectStatement statement)\r\n at SolarWinds.Data.Query.Processor.InheritanceExpander.Visit(SelectStatement statement)\r\n at SolarWinds.Data.Query.Processor.InheritanceExpander.Process(SelectStatement select, PreProcessorState state)\r\n at SolarWinds.Data.Query.Processor.PreProcessor.Process(SelectStatement selectStatement, PreProcessorState& preProcessorState)\r\n at SolarWinds.Data.Query.Engine.QueryProcessor.CompileQueryExecutionPlan(String query, IQueryExecutionContext context)\r\n at SolarWinds.Information* Connection #0 to host SolarWinds-Orion left intact
Service.Core.QueryPlanCache.GetQueryPlan(String query, String username, Boolean federationEnabled, Func`1 buildQueryPlan)\r\n at SolarWinds.InformationService.Core.InformationService.GetQueryExecutionPlan(String query, IIdentity currentIdentity, Boolean federationEnabled, IQueryExecutionContext queryExecutionContext)\r\n at SolarWinds.InformationService.Core.InformationService.RunQuery(String query, IDictionary`2 parameters, IDataSerializer serializer, IMessageFormatterStrategy messageFormatterStrategy)"}