Listing orders with specific status in NG cockpit based list widget

[Former Member]

Hi Friends,

We are facing an issue, please suggest. Following is the details:

We have created a NG cockpit based perspective in backoffice where a user can list orders having status WAITING. We are able to create explorer tree (left navigation) and list widget where all orders are getting listed. But our objective is to list only order which have status equal to WAITING.

To achieve this we have created a restriction associated to 'Order' item and new user. But we are unable to write a where clause for this restriction: Working but not useful: {status} IN (8796094759003)

Not working: {status} IN (select {PK} from {orderstatus} where {code} = 'COMPLETED')

Please suggest an approach to achieve listing of order in WAITING status in NG cockpit based perspective. It will be helpful and appreciated if a bit technical details also provided.

Thanks, Arun

[raghavendra_desu · Accepted solution]

Hi Arun,

In the first case, you have used the PK, which is not preferrable way, because the pk value keeps changes from db to db. In the second way you are missing the syntax. The sub select query should be enclosed with double brackets, as shown below.

{status} IN ({{select {PK} from {orderstatus} where {code} = 'COMPLETED'}})

For more details please refer to conditions section in the page

please try this and let us know if you have any issues.

Regards,

Raghavendra.

[Former Member · Accepted solution]

Thanks Raghavendra!! Your where clause query is working 🙂

Regards, Arun