Problem with previously saved Query and Query Editor.

Angarato · Post by **Angarato** » Sat Mar 10, 2007 6:10 pm

Hello!

I have a problem with Query that I saved previously and Query Editor functionality:
- Every time I open my Query in Query Editor and try to make even small changes (Delete the default buttons or Operations) it seems like the actual code of the query gets modified by the system so that I have to correct it and put my original Query code back. At the same time the
"Simple Form" of the Query stays unchanged.
- If I switch tabs "Simple Form", "Rule Form" and "SQL Form" the actual
Query code also gets modified by the System without any warnings, etc.

My questions are:
1. Is it the normal behaviour of the Query Editor?
2. If it is normal then how should I work with the Editor correctly so that
I won't loose the query code that has been already developed and saved?
3. Maybe there is something wrong with my Aware IM installation and I need to reinstall it?

Thank you in advance!
Angarato.

aware_support · Post by **aware_support** » Sun Mar 11, 2007 6:55 am

It is definitely not an installation issue. What does your query look like and what do you attempt to change in the query?

Angarato · Post by **Angarato** » Sun Mar 11, 2007 9:57 am

The following steps give me the problem described:

1. Create new Query - "Test"
2. Select Look for: "BObject1"
3. Switch to "Rule Form" Tab.
4. Enter: "FIND BObject1 WHERE TO_UPPER_CASE(BObject1.Description) CONTAINS TO_UPPER_CASE(BObject2.Keyword)"
5. Click "Create" and then "Save" buttons.
6. Perform "Update and keep Locked" of Business Space.
7. Switch to the "Simple Form" tab and see "FIND ALL BObject1" query
instead of query entered in p.4 and saved in pp.5,6.

Thanks,
Angarato.

Angarato · Post by **Angarato** » Sun Mar 11, 2007 10:05 am

Sorry, the p.7 should read:
7.Switch to the "Simple Form" and back to "Rule Form" and see
"FIND ALL BObject1" query... etc.

In other words it seems like switching back and forth "Simple Form"
and "Rule Form" tabs of Query Editor changes the Query code in
my particular case.

Thanks,
Angarato.

aware_support · Post by **aware_support** » Mon Mar 12, 2007 6:27 am

This is a bug. It is now fixed and the fix will be available in the next build.

Angarato · Post by **Angarato** » Mon Mar 12, 2007 4:22 pm

Thanks a lot! Could you please let me know when the next build will be available?

Thanks again,
Angarato.

aware_support · Post by **aware_support** » Mon Mar 12, 2007 11:21 pm

We will post a message to this thread when the fix is available. Probably within the next few days.

aware_support · Post by **aware_support** » Fri Mar 16, 2007 5:58 am

The fix is now available in build 948

Angarato · Post by **Angarato** » Fri Mar 16, 2007 7:39 pm

Thank you for the new build! However, my first impression is that it still didn't fix the problem:

1.Create query test
2.Go to the Rule Form tab
3.Create statement like: "Find Bo1 where bo1.attribute1 contains tempbo2.attribute1 and bo1.attribute2 contains tempbo2.attribute2"
4.Click on create, save, update business space and keep locked
5.Go to the simple rule tab and back to rule form tab.
6.Watch how you query Statement changed!

Angarato.

aware_support · Post by **aware_support** » Fri Mar 16, 2007 11:02 pm

Are you sure you are using the latest build 948?

We have just tested both the scenario you described in your original post and the new scenario. They both seem to work!

Angarato · Post by **Angarato** » Fri Mar 16, 2007 11:14 pm

Yes, I have a latest version. However I noticed that if after swithing to the rule form tab and noticing the default (modified by the system query) I try to close the whole configuration tool it will ask me if I want to save my query. If I say 'No' and then after shut down of the Configuration tool start it all over again, the query statement gets back to my code. I don't belive my eyes! As to me it is a very strange and suspicious behaviour of the query editor.

Thanks.

aware_support · Post by **aware_support** » Sat Mar 17, 2007 12:02 am

Sorry we cannot reproduce the problem. Could you please describe the steps you are performing in detail?

Angarato · Post by **Angarato** » Sat Mar 17, 2007 12:34 am

I just sent you an email with the screen shots and all the steps.

Angarato.