Astea Mobile - Activity sorting

Hi Laurence,
If you hit the Sort icon in the upper-right hand corner of the screen, what options are shown there?
i.e. Start Date, End Date, Activity, Done?
 

We don’t have a way to change those settings (but if you click on them you can switch them from sort from Ascending to Descending)...adding other options to this would require a small customization.
Thanks,
Reid

In case you are wondering what the current options available for sorting work list are:

From Private Activities:

The sort options are module specific (so you’ll see different options in the Work List module than you will in the Private Activities module or Inventory module, etc.)
Thanks,
Reid

I don't think I've made myself clear. What I meant was that when you create a new private activity, the list of choices is not sorted as you'd like. 

 AS you can see here, sort order is not by description (what we would like to optimize time) but id. 

Thank you

HI Laurence,

Your screen is alphabetical and looks more like descriptions than activity ID’s.

• Agence
• Chiffrage sav
• Delegation
• Detachement Installation
• Forum

How is this out of order or not alphabetical?  In any case, any changes would still be a customization.

I don’t know which database you are using for the profile but perhaps if you this query, it might help us:

select a.bpart_id, a.actv_type_id, b.descr, b.descr_lang3 from actv a with(nolock) inner join bpart b with(nolock) on b.bpart_id = a.bpart_id where b.descr_lang3 in ('CHIFFRAGE SAV','AGENCE', 'DELEGATION', 'DETACHEMENT INSTALLATION', 'FORUM') order by bpart_id

Yes,Phil, it seems to be alphabetical, but that’s because they have been created this way initially. Here is another example : 

 and here is the list with ids in Alliance :

As you can see, ID is used. ON this other environnement the request returns : 

HI Laurence,

Ok, the above was sorted by ID and not description.  This matches your second screen shot, not the first screen shot.

Seems to me the DAL query providing this information on the load to the mobile client needs to be modified to order by the description when the personal activity codes are loaded upon initialization or add a sorting functionality in Mobile.  Either way, custom change.

Hi Phil,

It will help if you can give us the DAL query name.  Is it possible please ? 

Hi Laurence,

I am not a developer and this is a custom change so I am not able to provide this type of information not knowing it specifically. My suggestion is to request Services to assist you in developing a solution.

Quick update: The R&D team is currently investigating this issue (it was replicated on the QAC environment and there is a support case logged for it in ServiceNow).
Thanks,
Reid