how to create constain picklist?process suppose country
field is there and state field is there,when user selected
Australia in country,i have to display aus related states
only states field? pls senme ans to (selvarajb.tech@gmail.com)
Answers were Sorted based on User's Feedback
Answer / tajuddin
HI,
As usual create 2 picklists among the 1 can be a Parent
and the other can be a Child now you can configure parent
child picklists, you can constrain them by doing the steps
in your Client Application
1.Add the LOV by giving the same LOV_TYPE as "sample"
for Parent LOVS and Child LOVS the Type should be the
same as above, after that when you add child values(STATES)
give the parent Country Value in the PLIC Column.
2. GO to Tools in Tools expand the BC-BC Field_PickMap
there create 2 pickmaps as usual forthe parent pick map
make the constrain property to True and in Picklist Field
property should be "Parent" in parent pickmap
Cheers
Taj
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / harish
select field and goto pick map,in pick map make constrain
property is true thats called constrain picklist.
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / suryaa
Hi Selvaraj,
Australia has Following States. Western Australia, South
Australia, QueensLand, New South Wales, Victoria and
Tasmania.
Siebel Application : Administration - Data Select List of
Values and give a query for Australia in Display Value.
Since Australia is already existing in Type : Country ,
added following records.
Type = STATE_ABBREV, Display Value = Western Australia,
Language-Independent Code = Western Australia , Description
= Australia and Language Name = As needed.
In Siebel Tools select the Business Component ( eg Account)
and child item " Field = State ".
In Pick Map which is child of Field add a new record.
Field = Country and PicklistField = Description
Compile the project open the application Account screen ,
in the Address MV Applet
AS the State coloumn length is 10 let the value in the lov
be within 10 char'
Rgds
Is This Answer Correct ? | 1 Yes | 3 No |
Differentiate between an organization and division?
Please tell me about the eim tables and base tables are required to your entities?
Explain what is constrainted picklist?
This is krishna, I created new Table,Bc,Link,Bo,view,screen TABLE : CX_ECB_S_TAT BC : ECB TAT BC Link : ECB TAT BC/Service Request Bo : ECB TAT BO View : ECB TAT View Screen : ECB TAT Screen and I created new "X_ECB_TAT_ID" Column for foregin key relation ship in "S_SRV_REQ" Table [in colum properties I specified Forieignkey Table-CX_ECB_S_TAT] and I created "TAT Id Ext" Field with "X_ECB_TAT_ID" Column in "Service Request" BC. I created Link"ECB TAT BC/Service Request". in this link I specified "Destination Field-TAT Id EXT".( Parent BC : ECB TAT BC, Child BC : Service Request) --------------------------------------------------- There is two Screens 1)ECB TAT Screen 2)Service Request Screen in First Screen : ECB TAT Screen Parent BC : ECB TAT BC Fields : Type,Area,Sub Area,TAT I given the field values to Type,Area,Sub Area and based on field values I given "TAT" field value. now we will go to Second Screen : Service Request Screen Child BC : Service Request Fields : INS Product,INS Area,INS Sub-Area,TAT I given same values(Parent bc Field Values) to INS Product,INS Area,INS Sub-Area then should be update "TAT" Field value (I mean Parent BC same "TAT" Field vaue should be update in "TAT" Field in Child BC) I wrote script for above requirement in "SetFieldValue" Event in "ECB TAT BC" function BusComp_PreSetFieldValue (FieldName, FieldValue) { if(FieldName == "TAT") { var Bo = TheApplication().GetBusObject("ECB TAT BO"); var Bc = Bo.GetBusComp("Service Request"); this.ActivateField("Type"); this.ActivateField("Area"); this.ActivateField("Sub Area"); this.ActivateField("TAT"); var sType = this.GetFieldValue("Type"); var sArea = this.GetFieldValue("Area"); var sSubArea = this.GetFieldValue("Sub Area"); var sTAT = FieldValue; //this.GetFieldValue("TAT"); var Bc1 = Bo.GetBusComp("Service Request") with(Bc1) { var exp = "[INS Product] = '" + sType + "' AND [INS Area] = '" + sArea + "' AND [INS Sub-Area] = '" + sSubArea + "'"; ActivateField("INS Product"); ActivateField("INS Area"); ActivateField("INS Sub-Area"); ClearToQuery(); SetViewMode(AllView); SetSearchExpr(exp); ExecuteQuery(ForwardOnly); var cnt = CountRecords(); ActivateField("TAT"); var fst = FirstRecord(); while(fst) { SetFieldValue("TAT",sTAT); fst = NextRecord(); } } } return(ContinueOperation); } but in "Service Request" BC "TAT" field value updating existing records,not updating creating new necords. I should update "TAT" field value to creating new records. where I have to write script in which event in which BC for this. please post detail script for this. from last 15 days i'm working on this. please help me on this. thank you so much in advance.
What is the purpose of 1:m extended table?
what is link specification ?
What is Event Logging?
Explain where does the primary field of an mvg stored?
What is detailed category?
How do you import lov's?
Explain how would you send an email using siebel realtime application?
What is a Link, & different types of Link in Siebel?
12 Answers IBM, TCS,