Drop Down In Query Changes Value

bucobill

It seems to be the week for Dropdown questions. I would like assistance to see if what I want to do is possible.

I have a Business Object called media it has demos associated with it in a reference where the demo is Owned By Media. In Media I have a shortcut to age_group, this throws and error since age_group can have multiple lists and so this is issue one. When I switch to Plain Text I get an error when trying to install new BSV and update Data Column Key missing so we cannot do the Plain Text. When we try to add new Demo it says shortcut contains list which is an error.

Ultimately we want to change the info inside the media query when a different demo is selected to change the number of persons in age_group inside the query. Is this possible? We looked at this post http://www.awareim.com/forum/viewtopic.php?p=29815#29815
But this wasn't much help.

aware_support

Frankly, I don't understand the problem at all. Please describe the problem properly, not what you are trying to do to solve it.

What do you mean you want to change the "media" query? You cannot change a query...

bucobill

I removed the words that are unique to our program and substituted BO1, BO2, Attribute1 and Attribute2 then reference the ShortCuts as SCAttribute1 and SCAttribute2. Hopefully this will make it easier to read.

We have a Business Object BO1. It has a direct reference to a second Business Object BO2. Inside BO2 we have an attribute BO1 which is Owned By BO1, inside BO1 the reference to BO2 is Owner Of. It does not have multiple allowed on either end and neither one is calculated.

BO2 Presentation in BO1 is set to Display As Dropdown with Add New and Fetch All Records at Once.

Inside BO2 we create Attribute1 and Attribute 2. This is where we add the information. Attribute2 has values of Red, Blue, Green and Attribute1 is 1,2,3 so we need to display three items 1=Red, 2=Blue, 3=Green. Error number 1 "BO1.SCAttribute1 contains list" This prevents us from creating multiple items.

BO1 has an attribute shortcut called SCAttribute2 this is a shortcut to BO2.Attribute2. Attribute2 in BO2 is Plain Text with Dynamic Choices, Use existing attribute values as choices is selected.

BO1 also has SCAttribute1 which is an attribute shortcut called SCAttribute1 this is a shortcut to BO2.Attribute1. Attribute1 in BO2 is Plain Text with Dynamic Choices, Use existing attribute values as choices is selected.

We then run a query for BO1 we use SCAttribute2 and SCAttribute1 inside the query. SCAttribute1 in the query is editable. This creates a dropdown.

We ultimately want to change the value of SCAttribute2 in the query to reflect whichever item is selected inside the query using SCAttribute1.

If Attribute2 has values of Red, Blue, Green and Attribute1 is 1,2,3 where 1=Red, 2=Blue, 3=Green. So if we select 1 in SCAttribute1 we see the value Red in SCAttribute2, if we change to 3 in SCAttribute1 we see value green in SCAttribute2 inside the query. Obviously this isn't working. Are we on the right track or way off.

My hopes are this makes a little more sense.

bucobill

Does anybody have any idea how to do this?

Here is the scenario.

We have three BO's. One that holds cars, one that holds color and miles and one that holds the ordered car.

Inside the Main Cars BO we have a reference to features (features has color, miles, radio style etc.). In the Order you select the car, then select the feature type and it changes the info inside the order.

So let's say we have a 2014 Blue Corvette with 56 miles. You want to query cars with a list of the basic model, such as Corvette. Then from the query you select a dropdown of inventory and select the feature set. Blue Corvette 56 miles etc. Once selected it inserts this info into the order.

We have tried shortcuts but obviously the features contain lists so we get an error.

Now if the client changes their mind and wants a red corvette they could inside the corvette query select red instead of blue and the info would insert into the order.

Does this make sense? Is it possible? I have been trying various set ups to try and make this work.

customaware

Hi Bill,

There is nothing in your explanation that looks like it could be a problem.

Happy to have a look and see what the problem might be if you like.

PM me.