OrangeScape Developer Community

A community for Application Developers on OrangeScape's Platform-as-a-Service

Queue's are used to list all records which are there in a particular activity.  Sometimes you may want to filter records based on some conditions (static filters), or may be you want to give the users an option to filter the records in the queue (dynamic filters).  Let's see how to do filters.

In the process design view, after you have defined how the queue should look for a activity, choose the activity and then click on the filter data button.
This will open up the filter dialog for that activity.
Here you can click on the Plus Button to create filter conditions
In this you can define your conditions

The First Drop down lists the Field of the current model against which you are going to state conditions. This is the Left Hand Side (LHS) of the condition.  The Second Drop down list the equating options for the condition.  The Third Drop down lists the type of the value on the Right Hand Side (RHS) of the condition. And Finally the last box takes the value of the condition or the cell which will contain the value of the condition 

For Defining a Static Filter: where you will define the value, choose Value in the Third drop down and then enter the RHS value for the condition.  (without any quotes or double quotes).  and then say done.
For Defining a Dynamic Filter:, in the Third drop down choose Cell, Now the fourth box turns into a drop down field.  Before doing anything here, first you will have to create fields in User model.
Goto User Model.  Here Create fields for the conditions as required.  The only criteria being the datatypes of the fields which you are creating here and the fields against which you are going to equate these fields should match.

Now back inthe process where we are defining the filters, in the drop down in the fourth field, choose the field which you have created for this field.  and say done.

Now in the Queue.  Above Header, Add the fields, so that user will have option to enter values during runtime to search for values.

Views: 152

Comment

You need to be a member of OrangeScape Developer Community to add comments!

Join OrangeScape Developer Community

Comment by Kamal.S on March 27, 2014 at 3:41pm
Comment by Marie McCooey on March 1, 2012 at 9:14pm

Santosh/Anbarsan

Thank you for your explanations.

Comment by Anbarasan on March 1, 2012 at 3:26pm

Marie / Santhosh,

It is true that it has to work in Google App Engine, but that would make the result sorting order to appear as though it is not working.  From the Google Documentation for this under the section "Properties in Inequality Filters Must Be Sorted before Other Sort Orders". 

For your case orangescape would construct the query like, 

    .....where PR_No_of_Items > 1 order by PR_ID

this throws the error which you are facing,  to correct it, Google App Engine excepts the query to  be like 

    .....where PR_No_of_Items > 1 order by PR_No_of_Items, PR_ID

which would alter the sort order, which would give the feel, that sorting is not working.  

So for Google App Engine you can either have sorting of queues, or inequalities in filters, but not both. (unless both sort field and filter field are same)

Note : This affects only Google App Engine (NoSQL) deployments, and not Google App Engine (SQL) or Enterprise / Amazon deployments as they use RDBMS.

Comment by Santhosh Mahizhan on March 1, 2012 at 11:52am

Hi Marie,

As per the below said criteria it should work. But it seems there is a bug in Google App Engine runtime, so please raise this as a bug to the support team. Will update you if i get any update on this at the earliest.

Thanks

Comment by Marie McCooey on February 29, 2012 at 10:15pm

Do the entries selected for the OrderByCell and Filter need to be the same?

Entered PR_ID for OrderByCell and PR_No_of_Items for Filter (see att screen capture) and received error msg (see att error msg).

When OrderByCell was changed to same entry in Filter field, the Filter worked.

Thank you, Marie

Comment by Kamal.S on August 19, 2011 at 11:41am
In the Filter Dialog, by default, OrderBy Cell value is CreatedAt. Make sure that your records having unique CreatedAt.

© 2017   Created by OrangeScape Technologies.   Powered by

Badges  |  Report an Issue  |  Terms of Service