<?xml version="1.0" encoding="utf-8"?>
<rss xmlns:atom="http://www.w3.org/2005/Atom" version="2.0"><channel><title>Answers to: TaskQuery for description search</title><link>https://answers.axonivy.com/questions/1353/taskquery-for-description-search</link><description>&lt;p&gt;Hi all,&lt;/p&gt;
&lt;p&gt;Is that possible to make a search for tasks by their description?
A search by name is possible through:&lt;/p&gt;
&lt;pre&gt;&lt;code&gt;TaskQuery stringFieldQuery = TaskQuery.create();
stringFieldQuery.where().name().isLike("search by name");
&lt;/code&gt;&lt;/pre&gt;
&lt;p&gt;I guessed it was the same for the description but it seems to be unpossible to do such a TaskQuery for the description because the following code returns an &lt;em&gt;IColumnFilterQuery&lt;/em&gt; and not an &lt;em&gt;IStringColumnFilterQuery&lt;/em&gt; as for the name():&lt;/p&gt;
&lt;pre&gt;&lt;code&gt;stringFieldQuery.where().description() // There is no isLike("...") method then.
&lt;/code&gt;&lt;/pre&gt;
&lt;p&gt;Is there another possibility with the TaskQuery?&lt;/p&gt;
&lt;p&gt;Thanks in advance&lt;/p&gt;
&lt;p&gt;Emmanuel&lt;/p&gt;</description><atom:link href="https://answers.axonivy.com/questions/1353/taskquery-for-description-search" rel="self"></atom:link><language>en</language><lastBuildDate>Tue, 09 Jun 2015 15:13:23 -0400</lastBuildDate><item><title>Answer by Bruno Bütler</title><link>https://answers.axonivy.com/questions/1353/taskquery-for-description-search/1354</link><description>&lt;p&gt;No, I think you can not do that with the current TaskQuery-API. This is a bug in the API definition. The difference is that the task name is stored as VARCHAR whereas the task description is a TEXT field depending on the DB system. &lt;/p&gt;
&lt;p&gt;The same you will encounter in the CaseQuery-API. &lt;/p&gt;
&lt;p&gt;Thanks for your post&lt;/p&gt;
&lt;p&gt;Bruno&lt;/p&gt;</description><dc:creator xmlns:dc="http://purl.org/dc/elements/1.1/">Bruno Bütler</dc:creator><pubDate>Tue, 09 Jun 2015 15:13:23 -0400</pubDate><guid>https://answers.axonivy.com/questions/1353/taskquery-for-description-search/1354</guid></item></channel></rss>