Search found 907 matches

by RocketRod
Tue Jul 26, 2016 11:37 pm
Forum: General discussion and questions about Aware IM
Topic: ►Q◄ Best ways to break a large DB table???
Replies: 22
Views: 38068

Re: ►Q◄ Best ways to break a large DB table???

Yes I use groups a lot too and that would work for you too. It would be nice if Support could add functionality so that you could specify the group member BO when creating a record. In the example the string IndustryCode defines the Group member BO that is to be added. ENTER NEW MEMBER LoggedInRegul...
by RocketRod
Tue Jul 26, 2016 6:04 am
Forum: General discussion and questions about Aware IM
Topic: ►Q◄ Best ways to break a large DB table???
Replies: 22
Views: 38068

Re: ►Q◄ Best ways to break a large DB table???

Further explanation. I would pursue my original concept. It doesn't matter how few attributes you have in the master table but it's important that you at least put the industry there. Also to retain a master table simplifies your coding a lot. To the user they don't see any issues say in creating an...
by RocketRod
Mon Jul 25, 2016 12:41 am
Forum: General discussion and questions about Aware IM
Topic: ►Q◄ Best ways to break a large DB table???
Replies: 22
Views: 38068

Re: ►Q◄ Best ways to break a large DB table???

Ben in your example I would tend to use more of a hybrid structure. I would have a master item BO which contained the common elements such as item description, item cost, item name etc with subsidiary BO's for each category where you have elements peculiar to just that item category. This can be imp...
by RocketRod
Thu Jun 30, 2016 11:54 pm
Forum: General discussion and questions about Aware IM
Topic: Global Search Feature
Replies: 11
Views: 33125

Re: Global Search Feature

Great!

Tip: When working with groups remember you can use the TYPE function if the process is required to do different things for different BO's within the group.

Cheers Rod
by RocketRod
Thu Jun 30, 2016 11:50 pm
Forum: General discussion and questions about Aware IM
Topic: Importing data from other application
Replies: 5
Views: 12036

Re: Importing data from other application

You do have the option of adding your tables/views as BOs with persistence external DB. Then just write a process(s) to create your new AIM BO data restructuring the original data as your needs require.

Cheers Rod
by RocketRod
Wed Jun 29, 2016 11:40 pm
Forum: General discussion and questions about Aware IM
Topic: Global Search Feature
Replies: 11
Views: 33125

Re: Global Search Feature

I agree with Rod re the annoyance of the question you get prompted for every time you change a member of a group. It would be great if this could be disabled. Another option. I haven't tried it but I can't see why you could not set up a SQL view which incorporated UNION statements. This way you coul...
by RocketRod
Wed Jun 29, 2016 6:14 am
Forum: General discussion and questions about Aware IM
Topic: Global Search Feature
Replies: 11
Views: 33125

Re: Global Search Feature

Actually it's quite straight forward. Add all required BO's to one Group. The key is that each BO to be used within the Group must have an attribute called the same name e.g. SearchText. Set up a rule on each BO to set this attribute to whatever you like. For example on the contact BO it may be the ...
by RocketRod
Wed Jun 29, 2016 4:10 am
Forum: General discussion and questions about Aware IM
Topic: I must not understand "IN BATCHES OF 1"
Replies: 7
Views: 16435

Re: I must not understand "IN BATCHES OF 1"

You are passing the instance of the BO to the subprocess right?

Cheers Rod
by RocketRod
Sun Jun 19, 2016 11:15 pm
Forum: General discussion and questions about Aware IM
Topic: FR: More thoughts on Config tool
Replies: 19
Views: 32943

Re: FR: More thoughts on Config tool

I would like the Search Rules action to be extended to also search applicability conditions everywhere they can be used.

Cheers Rod
by RocketRod
Thu Jun 16, 2016 5:47 am
Forum: General discussion and questions about Aware IM
Topic: NOT AwareIM issue but WTF?
Replies: 32
Views: 40286

Re: NOT AwareIM issue but WTF?

I would ask for remote access to one of their PC's so you can see the issue first hand. Get them to install TV or similar. Then investigate different browsers and browser settings. I suggest it's their end.

Cheers Rod
by RocketRod
Sun May 29, 2016 9:36 pm
Forum: General discussion and questions about Aware IM
Topic: Time Stamp help :(
Replies: 3
Views: 9972

Re: Time Stamp help :(

Temporary attribute that you set the chosen month to. Doing it this way allows different users to request different months.

Cheers Rod
by RocketRod
Thu May 26, 2016 10:08 pm
Forum: General discussion and questions about Aware IM
Topic: Time Stamp help :(
Replies: 3
Views: 9972

Re: Time Stamp help :(

Try

MONTH(DATE_PART(QuoteLineItem.SomeTimeStamp)) = LoggedInSystemUser.TempMonth AND YEAR_DIFFERENCE(DATE_PART(QuoteLineItem.SomeTimeStamp), CURRENT_DATE) < 5
by RocketRod
Wed Apr 27, 2016 5:05 am
Forum: General discussion and questions about Aware IM
Topic: For Each Day with TimeStamp - Bug?
Replies: 5
Views: 12656

Re: For Each Day with TimeStamp - Bug?

Great, glad its all ok now. As to if it's a bug depends on if FOR EACH DAY expects dates or timestamps. Only Support can answer that.

Cheers Rod
by RocketRod
Wed Apr 27, 2016 4:35 am
Forum: General discussion and questions about Aware IM
Topic: For Each Day with TimeStamp - Bug?
Replies: 5
Views: 12656

Re: For Each Day with TimeStamp - Bug?

I notice that your date range is between a timestamp and a date attribute? If so try DATE_PART(ObjectiveActivity.StartTime). Also I usually get the day difference first between the dates and then do a For each number between 1 and daydifference variable. Then just reconstruct your timestamps. Cheers...