go to post Katrina E Rodenhaus · Oct 27, 2023 Thank you for telling me about the security settings. That's helpful, I'm going to check on that. I've confirmed this is a table and when I use `select *` I am getting the Id column back. I've also confirmed through documentation that Id is a column that exists and should be queryable.
go to post Katrina E Rodenhaus · Oct 26, 2023 I am not binding the columns because I'm using PDO fetch mode `FETCH_ASSOC` to cast the resulting object to an array. Also I should've made this more clear, the exact same functionality works for all other IRIS queries I have. For example, the following query returns results properly: SELECT Id, Name, Mnemonic, Type FROM Dict.VisitTypes; Are there settings or anything configurable that could effect this on specific tables?