# WIP - Query Designer

IFS Query Designer can be used to create custom SQL queries that can be published as projections. &#x20;

*TODO: why only part of the attributes are available? Example JtTask, only small portion of attributes are available (when comparing table jt\_task\_tab, base view Jt\_Task or entity JtTask)??*

Read detailed configuration instructions from IFS documentation, search for **query designer.**

### **Selecting alternative view**

After you have selected the Entity, example JtTask, you can pick alternative view belonging to entity.&#x20;

<figure><img src="https://3323790987-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJyIxKYxK0LMJ2T3XubCS%2Fuploads%2FVksO6OXEiQ6O611qoULo%2Fimage.png?alt=media&#x26;token=0356d9bc-8a3f-421b-9a33-b774f14fce8b" alt=""><figcaption></figcaption></figure>
