Query count from JournalArticle with Dynamic Query

thumbnail
Jamie Sammons, modified 2 Years ago. New Member Posts: 7 Join Date: 10/5/22 Recent Posts

Here is my code, I want to search journalArticle count 

	public long searchCount(String treePath, String startDate, String endDate) throws ParseException {
	 	DateFormat simpleDateFormat=new SimpleDateFormat("yyyy-MM-dd");
	 	Date start = simpleDateFormat.parse(startDate);
	 	Date end = simpleDateFormat.parse(endDate);
	
		long results =0L;
		int status =0;
		
		DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(JournalArticle.class)
				 .add((PropertyFactoryUtil.forName("folderId").eq(treePath)))
				 .add((PropertyFactoryUtil.forName("displayDate").between(start, end)))
				 .add((PropertyFactoryUtil.forName("layoutUuid").isNotNull()))
				 .add((PropertyFactoryUtil.forName("status").eq(status)));	
		List<JournalArticle> journalArticleList = JournalArticleLocalServiceUtil.dynamicQuery(dynamicQuery);
		results = journalArticleList.get(0).getId();

return result;
}