Extend named query with a query

Ignition
1

Hello!

Would it be possible to extend a named query without changing the original query?

For example I would like add extension similar to:

SELECT
TS.Codigo AS Code,
SUM(ROUND(TM.kwhGEN,0)) AS kWh_GEN,
SUM(ROUND(TM.kwhSAI,0)) AS kWh_SAI,
avg(TM.kwGEN) AS avg_kW_GEN,
avg(TM.PUE) AS PUE      
FROM T_Medidas_TE TM INNER JOIN T_Sede TS
ON TM.id_sede=TS.id_sede
WHERE TS.id_tipo NOT IN ('1','4','5')

Or it´s quicker make a new query?

Thanks!

2

I'm not sure exactly what you're trying to get at by this, but it isn't possible to change a named query from outside of the Authoring Tab.

If you need dynamic queries then the best practice is to avoid Named Queries and use a scripted query with system.db.runPrep*Query()

1 Like
3

Ok, thanks @lrose I would just make a new one.

I was adapting a Vision project, and it seem they were extending the query somehow.

4

Was it a NamedQuery? If so can you show the actual named query?

Technically, you can use a QueryString parameter to provide query text, but that is a security hole and IMO should be avoided when other tools offer a reasonable alternative.

Take a look at this for more information:

2 Likes
5

Thanks for the clarification