trends name

[hocine]

Hello 

Is it possible to retrieve the trends names for display in an application?
I would like to create a LogicMachine interface where clients can select trends from a dynamically generated list based on available curves.

THX

[Daniel]

Try this

Code:

query = 'SELECT name FROM trends'
for _, object in ipairs(db:getall(query)) do
      name=tostring(object.name or '')
      log(name)
end

[hocine]

Try this

Code:

query = 'SELECT name FROM trends'
for _, object in ipairs(db:getall(query)) do
      name=tostring(object.name or '')
      log(name)
end

I try this but i don't have all the trends 

Code:

local rows = db:getall("SELECT id, name FROM trends ORDER BY name COLLATE NOCASE")
for _, r in ipairs(rows or {}) do
  log(string.format('%s (id=%s)', tostring(r.name or ''), tostring(r.id or '')))
end

if not rows or #rows == 0 then
  log('[db-trends] Aucun enregistrement trouvé dans la table trends (ou table vide).')
end
 

[Daniel]

how many trends do you have?

[hocine]

how many trends do you have?

i have 34 trends

[Daniel]

Check the logs in LogicMachine Log tab.

[hocine]

Check the logs in LogicMachine Log tab.

thx