Hello, I'm using the following to return all user rows, but I'm only getting one back:
local!usersAll : cast('type!{urn:com:appian:types}AL_Users' , a!queryEntity( entity:cons!AL_USERS, query:a!query( pagingInfo:a!pagingInfo( startIndex:1, batchSize:-1, sort:a!sortInfo( field:"name", ascending:true ) ) ) ).data)
I'm using this inside a local variable in a interface. Is there a limitation to this approach? Do I need to do it somehow else? In a Web API, this works and returns all, but not here, is it something with usage inside an interface?
Discussion posts and replies are publicly visible
While casting you have to cast it as type of list -
local!usersAll : cast('type!{urn:com:appian:types}AL_Users?list' , a!queryEntity( entity:cons!AL_USERS, query:a!query( pagingInfo:a!pagingInfo( startIndex:1, batchSize:-1, sort:a!sortInfo( field:"name", ascending:true ) ) ) ).data)
Hrishikesh Dixit Yes that was what I was missing. Thank you for the answer.