How to get data from default database in mendix using DB Connector

1
Anyone Help me, to get data from default database in mendix using execute query of db connector jdbc url : 'jdbc:hsqldb:hsql://localhost/' sql query : SELECT  'username', 'Publication' FROM "PUBLIC"."myfirstmodule$paper" WHERE "username" LIKE '%%'
asked
1 answers
2

From you question get the idea you are trying to access the internal mendix database via the database connector.

Are you aware that the database connector is mean to connect with external databases? The internal Mendix database can be accessed by doing a retrieve activity for example from a microflow.

The select sql statement you are indicating can be translated to a retrieve activity with:

  • source = from database
  • entity = paper
  • range = first/all (depends on your needs)
  • xpath constraint: [contains(username, ‘stringtofind’)]
answered