I have a query that returns more than 100 records as long as I don't select the primary key from one table. When I select the primary key it only displays 2 records and it shows and red exclamation mark with the following error on one of those records: ReadOnly Data is Modified.
The query is as follows:
SELECT top 100
app.fgm_grantprogrammeid
, wkf.fgm_WorkflowId
FROM fgm_applicationgrant AS app
, fgm_workflow AS wkf
WHERE app.fgm_grantprogrammeid = wkf.fgm_ProgramId
AND wkf.fgm_workflowid IN ('{596ddbc5-7496-ea11-a812-000d3a794f5d}', '{8ad95152-0dab-4074-80fb-c2bf13475ca9}')
If I run it as is it will display the following
When I comment out wkf.fgm_WorkflowId from the Select it returns 100 records
Using the Convert function produces the following FetchXML, which when run will return 100 records:
I have a query that returns more than 100 records as long as I don't select the primary key from one table. When I select the primary key it only displays 2 records and it shows and red exclamation mark with the following error on one of those records: ReadOnly Data is Modified.
The query is as follows:
If I run it as is it will display the following![image](https://github.com/MarkMpn/Sql4Cds/assets/27044773/13c9e58e-3e81-4da2-9192-3f6966636bd7)
When I comment out wkf.fgm_WorkflowId from the Select it returns 100 records![image](https://github.com/MarkMpn/Sql4Cds/assets/27044773/726be016-9c5f-4cde-a295-5204537b0fb7)
Using the Convert function produces the following FetchXML, which when run will return 100 records:
I am currently on the latest version (9.0.1) I think a recent update has caused this issue.