Filter query for released items

Zendesk API User

• January 10, 2014 15:22

Author: ndegoeij
Publication Date: 1/10/2014 15:22

In FirstSpirit 4.2.489 I have created a table with some fields. Upon this table we created a datasource with input components and a mapping to the table fields.

After this I would like to use the data of this table as an select list component (CMS_INPUT_COMBOBOX) in another data source with one restriction; this select list should have a query (with filter) on it which shows only the released items of the first table.

How can I create a filter query which shows only released items as a result set?

Related to

• Developers

0

• 

  Zendesk API User

  • January 16, 2014 09:01

  Author: pavone - 1/16/2014 9:01
  

  Hello,

  you could try this:

  Open your query and select the tab "Conditions". At the top, uncheck "Wizard mode" so you see the actual query code. Then wrap your conditions with an AND-tag and add the following line:

  <NOTNULL attribute="released by"/>

  So your query looks like something like this

  <QUERY entityType="products">
    <FILTERPARAM parameter="category_id" datatype="java.lang.Integer" value="123"/>
    <AND>
      <EQ attribute="product_categories.fs_id" parameter="category_id"/>
      <NOTNULL attribute="RELEASED_BY"/>
    </AND>
  </QUERY>

  This will exclude all items which have not been released. But it will also exclude items that had been released and then were changed without being released again! You will NOT get the released version of the item.

  Best regards

  Tim

  0

Please sign in to leave a comment.