Dynamic LINQ

Stable Version 0.1.4 (O9.1)
Also available for 9
Published on 06 March 2017 by 
Created on 15 May 2016
Details
Query Record List with Dynamic LINQ
Read More

With this component, you can query Record List with following query

WHERE {Employee}.[Id] > 101
ORDER BY {Employee}.[EmployeeName] DESC
SELECT {Employee}.[Id], {Employee}.[EmployeeName]

GROUP BY {Employee}.[Gender]
SELECT it.key.Gender, Count(),Max({Employee}.[Birthday])

FROM t1
JOIN t2 ON {Employee}.[Gender] = {Gender}.[Id]
SELECT t1.{Employee}.[Id], t1.{Employee}.[EmployeeName], t2.{Gender}.[Label]


What’s new (0.1.4)

Add INNER JOIN Support

Reviews (0)
Category
Libraries
Tags
Support Options
This component is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from Wei Zhu who created this component.
Dependencies
Dynamic LINQ has no dependencies.
Requirements
Platform
9.1.0.6
Database
All
Stack
All
Component Consumers
See all 1 consumers
Weekly Downloads 
Related Components
Silk UI Web
OutSystems R&D
A fully responsive and beautiful UI framework that works within the OutSystems Platform. Build amazing looking applications, in a fraction of the time, which work perfectly across devices. Learn how to start using Silk UI and see the examples at silkui.outsystems.com . Obtain assistance on using Silk UI in our forums .
28383
OutSystems UI Mobile
OutSystems R&D
Create amazing native mobile applications using this fully integrated UI framework for OutSystems, with dozens of UI patterns ready to use.
9907
XML Records
Afonso Carvalho
An extension that allows you to convert an hierarchical structure, composed of Records and/or RecordLists to XML. It also allows to read an XML into the structure
3898
More from Wei Zhu
CSVUtil
Wei Zhu
CSV Import/Export
1624
SFTP
Paulo Ramos
SSH File Transfer Protocol. Includes a SFTP client (sample) and a library that you can use from your applications.
814
SMTPClient
Wei Zhu
Workaround for send text email via SMTP
162