Hello, We had a request of retrieve all smartform contents with one specific smartform type "xxxx". How can we do it through database? Or Is there's a faster way of doing it? thanks!
Probably too late, but is this what you are trying to do?
ContentApi contentapi = new ContentApi(ApiAccessMode.Admin);Criteria<ContentProperty> criteria = new Criteria<ContentProperty>();criteria.AddFilter(ContentProperty.XmlConfigurationId, CriteriaFilterOperator.EqualTo, smartformid);criteria.OrderByDirection = EkEnumeration.OrderByDirection.Ascending;criteria.OrderByField = ContentProperty.Title;
List<Ektron.Cms.ContentData> contentDatas = contentapi.GetList(criteria);
Thanks! This is definitly a solution for my case!
I was asking if there's a sql query can perform the job.