msnraju/inline-query

select multiple columns, order by clause

Closed this issue · 0 comments

msnraju commented

Inline Query should accept multiple columns, and ORDER BY clause

example:
SELECT [No.], Name FROM Customer ORDER BY Name

Need to have a new method "AsRecord" in "Inline Query" codeunit that should accept the following parameters:

  1. Query Text - The above syntax shoule be supported.
  2. RecordRef (Reference type) - WHERE clause (Filters) and ORDER BY clause (Key) should be applied on this Parameter.