我想在Maximo中创建一个where子句。我们今天有一个条款,我们可以看到工作订单即将违反响应的SLA。(woclass = 'WORKORDER' or woclass = 'ACTIVITY') and istask = 0
and workorderidin (select sla.ownerid from slarecords sla wh
where clause;
但是,当我试图预览报告时,我收到了以下错误“workorder.wopriority,workorder.reportdate,workorder.estdur,workorder.location”+“from workorder”//包括Maximo子句+“where”
[listaProductoPrecio] @Maximo intBEGIN FROM dbo.ProductosWHERE PrecioProducto BETWEEN @Minimo AND @Maximo这是控制器:[Route("api/listaEntrePrecios")]
public IEnumerable<Producto> listaEntreP