HomeGuidesAPI ReferenceChangelogDiscussions
GuidesiMIS ProfessionaliMIS EnterpriseClient SupportLog In
Discussions
These docs are for v20.3.44. Click to read the latest docs for v20.3.189.

Discussions

Ask a Question
Back to All

Create a view in SQL database using API

Hi team,

As we can't access the database to create a view in iMIS EMS (cloud version). Hence, I'm thinking is that possible to use API to create a view in SQL database?
What I'm trying to do is create a data source to filter the members that have more than 2 records in a muti-instance table. I have tried to use Business Object Designer but I'm not able to use having count function in the filter expression, hence need to find another way to filter the data.
Any idea/suggestion is much appreciated.

Thank you,
Vu