{"action":"created","issue":{"url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/226","repository_url":"https://api.github.com/repos/fsprojects/SQLProvider","labels_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/226/labels{/name}","comments_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/226/comments","events_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/226/events","html_url":"https://github.com/fsprojects/SQLProvider/issues/226","id":137418310,"number":226,"title":"Cannot replicate MSDN example for \"IN a set of specified values\"","user":{"login":"jimfoye","id":4249676,"avatar_url":"https://avatars.githubusercontent.com/u/4249676?v=3","gravatar_id":"","url":"https://api.github.com/users/jimfoye","html_url":"https://github.com/jimfoye","followers_url":"https://api.github.com/users/jimfoye/followers","following_url":"https://api.github.com/users/jimfoye/following{/other_user}","gists_url":"https://api.github.com/users/jimfoye/gists{/gist_id}","starred_url":"https://api.github.com/users/jimfoye/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jimfoye/subscriptions","organizations_url":"https://api.github.com/users/jimfoye/orgs","repos_url":"https://api.github.com/users/jimfoye/repos","events_url":"https://api.github.com/users/jimfoye/events{/privacy}","received_events_url":"https://api.github.com/users/jimfoye/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2016-02-29T23:59:33Z","updated_at":"2016-12-30T10:11:06Z","closed_at":"2016-03-01T17:18:37Z","body":"I'm trying to follow this example from https://msdn.microsoft.com/en-us/library/hh225374.aspx. This sample code also appears on the FSharpComposableQuery queries example page, but it's not clear to me if that is required to work (I added FSharpComposableQuery to my project, but it made no difference).\n\n```\n// Select students where studentID is one of a given list.\nlet idQuery = query { for id in [1; 2; 5; 10] do\n                      select id }\nquery { \n    for student in db.Student do\n    where (idQuery.Contains(student.StudentID))\n    select student\n}\n```\n\nWhen I try it like this:\n\n```\nlet idQuery = query { for id in [1; 2; 5; 10] do\n                      select id }\nlet summary =\n    query { for row in ctx.AzUnknownScenario.QryEpiSummary do\n            where ((row.ScenarioId = scenario.Id) && \n                   (idQuery.Contains(row.PatientCategoryId)))\n            select { Country = row.Country;\n                     Segment = row.SegmentName;\n                     PatientCategory = row.PatientCategory;\n                     Year = row.CurrentYear;\n                     Value = row.CurrentValue; } }\n```\n\nAt runtime I get an exception:\n\n\"Unsupported expression. Ensure all server-side objects appear on the left hand side of predicates.  The In and Not In operators only support the inline array syntax.\"\n\nBeside scratching my head wondering why this is not working, I'm also looking around for an example of this \"inline array syntax\", but I haven't found anything.\n"},"comment":{"url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/comments/269754359","html_url":"https://github.com/fsprojects/SQLProvider/issues/226#issuecomment-269754359","issue_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/226","id":269754359,"user":{"login":"yetanotherlogonfail","id":6427994,"avatar_url":"https://avatars.githubusercontent.com/u/6427994?v=3","gravatar_id":"","url":"https://api.github.com/users/yetanotherlogonfail","html_url":"https://github.com/yetanotherlogonfail","followers_url":"https://api.github.com/users/yetanotherlogonfail/followers","following_url":"https://api.github.com/users/yetanotherlogonfail/following{/other_user}","gists_url":"https://api.github.com/users/yetanotherlogonfail/gists{/gist_id}","starred_url":"https://api.github.com/users/yetanotherlogonfail/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yetanotherlogonfail/subscriptions","organizations_url":"https://api.github.com/users/yetanotherlogonfail/orgs","repos_url":"https://api.github.com/users/yetanotherlogonfail/repos","events_url":"https://api.github.com/users/yetanotherlogonfail/events{/privacy}","received_events_url":"https://api.github.com/users/yetanotherlogonfail/received_events","type":"User","site_admin":false},"created_at":"2016-12-30T10:11:06Z","updated_at":"2016-12-30T10:11:06Z","body":"ok if we get this problem caused by some bug in the sqlprovider\r\n\r\nThe In and Not In operators only support the inline array syntax. op_BarEqualsBar(tupledArg.Item1.GetColumn(\"FullDate\").DayOfWeek.ToString(), Cons(\"1.0\", get_Empty()))\r\n\r\nwhere is the example of a non inline array syntax?\r\n"}}
{"actor":{"display_login":"yetanotherlogonfail"}}