Contains tips for configurators working with Aware IM
#20322 by tford
Tue Jan 17, 2012 1:33 am
Version 5.2 (starting with build 1513) now supports a query displaying items NOT in a reference list already.

This BSV demonstrates the concept:

http://www.awareim.com/community/Not_Query_Demo.bsv

1 ) The rule to for the query to show instances NOT selected (the top query) is:

FIND Customer WHERE COUNT RegularUser WHERE (RegularUser=LoggedInRegularUser AND Customer IN RegularUser.SelectedCustomers)=0 ORDER BY Customer.Name

2 ) Through using Auto Refresh capabilities of the 2 queries, items move "real time" between the selected and not selected lists.

3 ) When combined, these features mitigate the limitation that queries can only apply a process on items selected on one page. While that limitation still is true, the dynamic nature of selecting & moving instances to a selected items query provides some relief.

4 ) Once items are moved to a selected items area, a process can easily be applied to all of the selected items.

To see this BSV in action:

5 ) Click "add new customer" and add some. I suggest adding more than 5 so they continue to page 2 of the query.

6 ) In the top query, click "Select" for some individual instances & watch them be removed from the top query & added to the bottom query

7 ) Now do the same for multiple instances at one time.

8 ) In the bottom query, clicking "flag selected customers" and "unflag selected customers" shows that a process can be applied to all selected items. Not that these processes will apply across ALL pages of the bottom query.

9 ) Click in the top menu bar "review selected customers". This shows one other way of viewing the Customers stored in LoggedInRegularUser BO.

10 ) Click in the top menu bar "remove all selected customers" to more all items back from the bottom query to the top query.
#33688 by tford
Sun Jul 26, 2015 8:33 am
Please ignore my earlier post today. The attached BSV better demonstrated the concept. After adding customers & selecting a few, click "Review selected customers" from the main menu bar. When you click "Add", you will be presented with a list of the customers that are NOT in the Customers Selected List so that you can add additional customers to this list.

customers not selected.png
customers not selected.png (31.13 KiB) Viewed 12296 times


(40.12 KiB) Downloaded 480 times
#33689 by tford
Sun Jul 26, 2015 10:06 am
One more example query:

FIND RegularUser WHERE COUNT Student_Milestone_Notify WHERE (Student_Milestone_Notify=ThisStudent_Milestone_Notify AND RegularUser IN Student_Milestone_Notify.Users_to_Notify)=0 ORDER BY RegularUser.Name_Last,RegularUser.Name_First

In this case, I have a BO Student_Milestone_Notify with an attribute Users_to_Notify. This reference attribute contains a list of the RegularUser instances that have selected to be notified when additions are made to a particular milestone. The query above is used to show the RegularUser instances that have NOT yet selected to be notified for a particular milestone.

It is called from the "Add" button on Student_Milestone_Notify.Users_to_Notify as shown below:

users to notify.png
users to notify.png (47.65 KiB) Viewed 12294 times
#33690 by tford
Sun Jul 26, 2015 11:00 am
One last detail .. I wanted to show a query of first names of users that were watching / not watching a milestone:

milestone watch list.png
milestone watch list.png (17.64 KiB) Viewed 12293 times


Below are the two rules used to generate the two lists:

Student_Milestone_Notify.Who_is_not_watching=LIST_LINE('Student Milestone - Users Not Selected',``,`, `,`Name_First`)

Student_Milestone_Notify.Who_is_watching=LIST_LINE('FIND RegularUser WHERE RegularUser IN Student_Milestone_Notify.Users_to_Notify ORDER BY RegularUser.Name_Last',``,`, `,`Name_First`)
#45671 by Jaymer
Sun Nov 19, 2017 9:50 pm
tford wrote:Student_Milestone_Notify.Who_is_not_watching=LIST_LINE('Student Milestone - Users Not Selected',``,`, `,`Name_First`)

Student_Milestone_Notify.Who_is_watching=LIST_LINE('FIND RegularUser WHERE RegularUser IN Student_Milestone_Notify.Users_to_Notify ORDER BY RegularUser.Name_Last',``,`, `,`Name_First`)


Are those really supposed to be "accent marks" instead of single quotes?
... for the 2-4th parms to LIST_LINE

I know it shows that in the Docs, but I can't get this to work in any case.
I'm trying to use in an UPDATE RULE and it complains:
Recip.theLists = LIST_LINE (Recip.pm_List, 'ORDER BY FName DESC‘,,,'ListName')
I get a Syntax Error at this location.

And I get crap like this when I try to use the accent marks, but if they are regular single quotes. no error.
Screen Shot 2017-11-19 at 4.54.03 PM.png
Screen Shot 2017-11-19 at 4.54.03 PM.png (16.68 KiB) Viewed 11270 times

Who is online

Users browsing this forum: No registered users and 12 guests