Query Building

Description: Query Building in Mendix involves creating and managing data retrieval logic using XPath or OQL (Object Query Language) to efficiently filter, sort, and retrieve data from the domain model. Deeplink: https://community.mendix.com/link/tags/query-building

• OQL join query multiplies sums of columns instead of only summing

  https://community.mendix.com/link/space/databases/questions/142730

• Unable to read the Item Revision using OTB relation

  https://community.mendix.com/link/space/teamcenter/questions/142615

• Use OQL query Data Set in a web page

  https://community.mendix.com/link/space/app-development/questions/142540

• I want to pass the value of the in clause as a single parameter to the DB query.

  https://community.mendix.com/link/space/databases/ideas/4501

• Query execution took more time than 0 seconds

  https://community.mendix.com/link/space/databases/questions/141078

• hiding personalization is on but unable to see column name when click on eye icon

  https://community.mendix.com/link/space/app-development/questions/133493

• Mendix OQL Query From clauses don't support long paths

  https://community.mendix.com/link/space/app-development/questions/7233

• DataGrid2 doesn't save last filter values on columns

  https://community.mendix.com/link/space/widgets/questions/140379

• Caused by: java.lang.NullPointerException: Could not find result attribute StoreCode in target object.

  https://community.mendix.com/link/space/java-actions/questions/140290

• OQL module from app store - no longer working?

  https://community.mendix.com/link/space/marketplace/questions/103241

• OData query filter by enum

  https://community.mendix.com/link/space/studio-pro/questions/130334

• Nanoflow - Commit WITHOUT Refresh

  https://community.mendix.com/link/space/app-development/questions/133681

• Calling Parameterized Stored Proc with Output

  https://community.mendix.com/link/space/databases/questions/125752

• Identify Items Not Currently In Task Queue

  https://community.mendix.com/link/space/app-development/questions/132511

• Does Mendix Object GUID have checksum in lower bits?

  https://community.mendix.com/link/space/databases/questions/132353

• Support query string for Page/Microflow URLs

  https://community.mendix.com/link/space/microflows/ideas/4302

• How do I add a line break between two queries in OQL?

  https://community.mendix.com/link/space/databases/questions/131877

• SQL Constraint issue with DB replication module

  https://community.mendix.com/link/space/community/questions/131586

• Published Odata service: will expand with select be supported?

  https://community.mendix.com/link/space/app-development/questions/116957

• Data Widgets - Tree Filtering

  https://community.mendix.com/link/space/app-development/ideas/3942

• Need Column Filters for Data grid 2 to take values from associated Entities.

  https://community.mendix.com/link/space/widgets/ideas/3889

• Is this OQL stored procedure possible in Mendix?

  https://community.mendix.com/link/space/studio-pro/questions/126364

• Update conflict Exception in 8.18.19

  https://community.mendix.com/link/space/microflows/questions/125780

• Replace() breaks OQL

  https://community.mendix.com/link/space/java-actions/questions/125791

• Bad query performance due to IN query

  https://community.mendix.com/link/space/studio-pro/questions/124856

• Source datagrid from OQL query

  https://community.mendix.com/link/space/studio-pro/ideas/3774

• how to connect sql server database to mendix

  https://community.mendix.com/link/space/studio-pro/questions/124937

• SQL Server supported versions

  https://community.mendix.com/link/space/databases/questions/124552

• Datagrid 2: multiple date filters in the header

  https://community.mendix.com/link/space/widgets/questions/112427

• Executed parameterized query wont read variable

  https://community.mendix.com/link/space/databases/questions/123549

• OQL to join two Un-associated tables

  https://community.mendix.com/link/space/studio-pro/questions/123497

• problem with query in OQL

  https://community.mendix.com/link/space/community/questions/122726

• Send and access Query string Parameters in URL Mendix using Deep Link

  https://community.mendix.com/link/space/studio-pro/ideas/3573

• REST GET Service with + in query parameter

  https://community.mendix.com/link/space/integrations/questions/122176

• Getting error when using Attribute name as a 'LENGTH' in OQL Query

  https://community.mendix.com/link/space/databases/questions/121505

• OQL Performance issue

  https://community.mendix.com/link/space/app-development/questions/121491

• Trim the timestamp from DateTime using OQL query

  https://community.mendix.com/link/space/databases/questions/121296

• replaceAll()

  https://community.mendix.com/link/space/microflows/questions/117924

• Retrieve ModelGUID for WorkflowDefinition

  https://community.mendix.com/link/space/workflows/questions/117866

• DataGrid2 - Column specific filtering should be allowed in header filter for improved UX

  https://community.mendix.com/link/space/user-experience/ideas/3257

• The hiding column selector of DataGrid2 cannot display all of them

  https://community.mendix.com/link/space/widgets/questions/117251

• Pulling MYSQL server primary key error

  https://community.mendix.com/link/space/microflows/questions/117104

• Data grid 2 filter widgets blocked

  https://community.mendix.com/link/space/widgets/questions/116972

• How do I pass a input string from UI to a parameterized query to my database

  https://community.mendix.com/link/space/microflows/questions/116448

• Config file showing an error

  https://community.mendix.com/link/space/studio-pro/questions/116039

• Execute call procedure using "Execute callable statement"

  https://community.mendix.com/link/space/connectors/questions/112053

• Get querystring values from request in Microflow

  https://community.mendix.com/link/space/java-actions/questions/85532

• Call procedure using "Execute callable statement" with external database PostgreSQL

  https://community.mendix.com/link/space/connectors/questions/113730

• oql select empty

  https://community.mendix.com/link/space/databases/questions/113534

• how to acept apostrophe on sql insert

  https://community.mendix.com/link/space/databases/questions/112569