Why not store the decimals you use, and just display them as percentages (change the display format for the attribute in the query to #%). I think that will display 0.1 as 10% in the query result.
Regards,
Steve
Search found 201 matches
- Thu Oct 26, 2017 8:14 am
- Forum: General discussion and questions about Aware IM
- Topic: Query Display Issue
- Replies: 5
- Views: 8424
- Fri Oct 20, 2017 12:04 pm
- Forum: General discussion and questions about Aware IM
- Topic: Date filter field format
- Replies: 0
- Views: 3762
Date filter field format
Hi all. I'm wanting to allow a user to filter query results based on a date column. I've added the filter, it works if I type in a date (eg 31/01/2012 will show all records where the date is the 31st of Jan 2012.) but when I try use the date selector in the search bar which is shown in the first row...
- Thu Oct 05, 2017 5:58 am
- Forum: General discussion and questions about Aware IM
- Topic: Determining if child records are created
- Replies: 2
- Views: 5408
Re: Determining if child records are created
Perhaps try
IF EXISTS Employee WHERE Employee IN Supervisor.Employees THEN
IF EXISTS Employee WHERE Employee IN Supervisor.Employees THEN
- Mon Oct 02, 2017 7:47 am
- Forum: General discussion and questions about Aware IM
- Topic: Help with custom query display
- Replies: 8
- Views: 48669
Re: Help with custom query display
I do something similar to this for a custom query that displays some time slots that can be booked. I have an attribute (color) which is set when the booking status is changed. This attribute is a color name (blue/pink). In my custom query I have added to the div style background:{color}; What I'd s...
- Wed Sep 27, 2017 7:28 am
- Forum: General discussion and questions about Aware IM
- Topic: Custom query display OFFLINE
- Replies: 4
- Views: 8252
Re: Custom query display OFFLINE
Apologies for not being clear. I am looking to select the attached option for a custom layout of a query. I cannot find it anywhere.
- Tue Sep 26, 2017 6:50 am
- Forum: General discussion and questions about Aware IM
- Topic: Custom query display OFFLINE
- Replies: 4
- Views: 8252
Re: Custom query display OFFLINE
Anyone with any insight here? If I recall there is something that can be added to initialization script to sort query results in groups, which isn't usually supported, I'm hoping there is something similar for this..
- Fri Sep 22, 2017 7:27 am
- Forum: General discussion and questions about Aware IM
- Topic: Custom query display OFFLINE
- Replies: 4
- Views: 8252
Custom query display OFFLINE
Hi all. Doing some evaluation of AwareIM's offline functionality. I'd like to set the option that is shown under the 'more' option of the standard query display, 'Fetch records for all pages at once (recommended when working in offline mode)', when using a custom query display. Is this possible? If ...
- Mon Sep 18, 2017 6:47 am
- Forum: General discussion and questions about Aware IM
- Topic: Messages on failed login
- Replies: 6
- Views: 12798
Re: Messages on failed login
Adding this worked - " &errorPage=loginerror.html". Thanks for all the help.
Regards,
Steve
Regards,
Steve
- Mon Sep 18, 2017 5:47 am
- Forum: General discussion and questions about Aware IM
- Topic: Messages on failed login
- Replies: 6
- Views: 12798
Re: Messages on failed login
Thank you for the suggestions. mrbdrm, do I need to do anything other than create that page? Do I need to change something in the login page I'm using to direct to this ErrorPage when login fails? I've created this page and tested briefly and it wasn't displayed. I tried to login with incorrect deta...
- Fri Sep 15, 2017 6:35 am
- Forum: General discussion and questions about Aware IM
- Topic: Filter a List Based on its appearance in another List
- Replies: 4
- Views: 7432
Re: Filter a List Based on its appearance in another List
Ah, so then this might work:
FIND Country WHERE EXISTS TaxType WHERE (Country IN TaxType.ps_Country AND TaxType.Active='Yes')
FIND Country WHERE EXISTS TaxType WHERE (Country IN TaxType.ps_Country AND TaxType.Active='Yes')
- Fri Sep 15, 2017 6:28 am
- Forum: General discussion and questions about Aware IM
- Topic: Filter a List Based on its appearance in another List
- Replies: 4
- Views: 7432
Re: Filter a List Based on its appearance in another List
Hi! If I understand correctly: A user selects a country from all country BOs, then selects a tax type BO that has this country BO as a relation to it, is that right? If so: FIND TaxType WHERE Country IN TaxType.ps_Country You can add - AND TaxType.Active='Yes' I would think your issue is perhaps bec...
- Fri Sep 15, 2017 6:17 am
- Forum: General discussion and questions about Aware IM
- Topic: Messages on failed login
- Replies: 6
- Views: 12798
Re: Messages on failed login
If this is not possible, does anyone have any ideas for a work around?
Regards,
Steve
Regards,
Steve
- Wed Sep 13, 2017 6:29 am
- Forum: General discussion and questions about Aware IM
- Topic: Map presentation
- Replies: 9
- Views: 17568
Re: Map presentation
Seems I ran out of attachment space.. Attached is the result from above.
Regards,
Steve
Regards,
Steve
- Wed Sep 13, 2017 5:25 am
- Forum: General discussion and questions about Aware IM
- Topic: Map presentation
- Replies: 9
- Views: 17568
Re: Map presentation
Thanks for all the replies. Bands empty, except the summary one, which has the map. I've redone this from a blank presentation. All unwanted bands have 0 height, paging bar is turned off. I've attached more screen shots. I will try the HTML way and see if that helps. I'm not sure how it works with m...
- Tue Sep 12, 2017 7:39 pm
- Forum: General discussion and questions about Aware IM
- Topic: Map presentation
- Replies: 9
- Views: 17568
Re: Map presentation
Hi Tom. I've tried that. Let me post a screen shot.
Thanks for the reply, I hope you can point me in the right direction from here..
Thanks for the reply, I hope you can point me in the right direction from here..