Book a Demo

Author Topic: SQLQuery object - query code  (Read 3168 times)

MarcinG

  • EA User
  • **
  • Posts: 67
  • Karma: +0/-0
    • View Profile
SQLQuery object - query code
« on: February 11, 2022, 11:11:48 pm »
Hello,

when doing data modelling , there is a possibility of using object named of type SQLQuery.  Contrary to i.e. View, it does not seem to have a proper place to store SQL code of its definition, part of a tag attribute SQL that does not seem to be linked to any bigger text field.  I am aware that using Database Builder make possible to record such queries, but there is a reason I do not want to use database builder.
I can use Note attribute of the element, but I was hoping there would be a dedicate attribute with similar availability as Note.

Does anyone have any idea ? 

Best regards
Marcin

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: SQLQuery object - query code
« Reply #1 on: February 12, 2022, 12:47:44 am »
Sounds very specific. So what I would do is to create an element in a profile having a SQL property to store exactly that.

q.