One particular function we can use for an option list is the Tree selection. It is a core piece of Folders but without the performance heavy overhead.
In our scenario, we have a very busy auto parts store and body shop. The shop manager wants the users to have the option at check-in to assign metadata such as the year, make and model of a vehicle that the shop custom fabricates specialty parts for. The shop UCM administrator armed with an arsenal of documents from the 10g and 11g document library takes on the task and hopes to have the project done in a few days. With our help we will reduce that time to a project that can be done before lunch time.
The sections that will be covered are:
Adding information fields,
Table Creation,
Adding Views,
and Relating Views for use in Option list
First let’s begin with creating our information field.
Navigate to Administration > Admin Applets > Configuration Manager > Information Fields
1) Click “Add”
2) Enter Vehicle for Field Name
3) click “OK” through next two windows
4) Click Update Database Design to commit the add field
Now we can begin creating our tables.
While still in Configuration Manager click on the Tables tab
1) Click “Create table”
1) Enter Vehicle_Year in Table Name
2) Enter Vehicle Year for Table Description
3) Add Column Name: Vehicle_Year, with type as varchar, and length 50
4) Add Column Name: Vehicle_Year_id, with type int, enable as Primary Key, and click ok twice to complete creation of table
5) Repeat steps to create remaining tables and columns below.
Table Name: Vehicle_Name
Table Description: Vehicle Name
Column Name: Vehicle_Name,
Column Type: varchar
Column Length 50
Column Name: Vehicle_Name_id,
Column Type: int
enable Primary Key check box
Column Name: Vehicle_Year_id,
Column Type: int
Table Name: Vehicle_Model
Table Description: Vehicle Model
Column Name: Vehicle_Model,
Column Type: varchar
Column Length 50
Column Name: Vehicle_Model_id,
Column Type: int
enable Primary Key check box
Column Name: Vehicle_Year_id,
Column Type: int
Column Name: Vehicle_Name_id,
Column Type: int
After table creation we can go ahead and add the views for our project
While still in Configuration Manager click on the Views tab
1) Click “Add”
2) Select Vehicle_Year table then click “Next”
3) Select all columns then click “Finish”
4) Enter “Vehicle_Year_View” for View Name, “View for vehicle year” for View Description, then click “OK”
5) Repeat steps to add views for Vehicle_Name, and Vehicle_Model.
Now that our views are added we are going to need to add the data that will be displayed for the end users.
Vehicle Year View Data:
While still in the Views section,
1) Select Vehicle_Year_View and click “Edit Values”
2) Click “Add”
3) Enter 2009 for Vehicle_Year and, 1 for Vehicle_id
4) Follow table below to complete remaining values
Vehicle Name View Data:
1) Select Vehicle_Name_View and click “Edit Values”
2) Click “Add”
3) Enter Ford for Vehicle_Name, 11 for Vehicle_Name_id, 1 for Vehicle_id, then click ok
4) Follow table below to complete remaining values
Vehicle Model View Data:
1) Select Vehicle_Model_View and select “Edit Values”
2) Click “Add”
3) Enter F-150 for Vehicle_Model, 111 for Vehicle_Model_id, 11 for Vehicle_Year_id, 1 for Vehicle_Name_id, then click ok
4) Follow table below to complete remaining values
Now that we have populated our views data we can link or relate the newly created tables.
Relations
While still in Configuration Manager click on the Relations tab
1) Click “Add”
2) Enter “Vehicle_Name_Relationship” for Relationship Name, and “Relationship for vehicle name “ for description
3) Select Vehicle_Year from the first drop-down and Vehicle_Year_id from the second drop-down in the Parent Info drop-down
4) Selec tVehicle_Name from the first drop-down and Vehicle_Year_id from the second drop-down in the Child info drop-down, then click “OK”
5) Repeat above steps to add Vehicle_Model_Relationship. In description field enter “Relationship for vehicle model” Select Vehicle_Name in the first drop-down and Vehicle_Name_id from the second drop-down for Parent Info then Vehicle_Model from the first drop-down and Vehicle_Name_id from the second drop-down for Child info
All that is now left to do is configure our field.
Field Configuration
1) Click on Information Fields and select “Vehicle” field.
2) Click "Edit"
3) Check Enable Options List
4) Click Configure
5) Check Use Tree6) Click “Edit Definition”
7) Click drop-down to build first level of tree. Select “Vehicle_Year_View”
8) Click drop-down to build second level of tree. Select “View_Name_Relationship”
9) Click drop-down to build third level of tree. Select “View_Model_Relationship” and click “Ok” three (3) times to complete tree definition.
Our Tree option list is finally complete. To validate, we just need to go to the check in page.
In the check-in page there is a new field labeled “Vehicle”.
Click “Select” then drill down to make sure our tree displays positive results.
Now suppose the auto shop manager would rather have a dependent option list, where only information is displayed based on a previous selection.
No problem the bulk of the work is complete. All that would need to be done is:
Creation of two new information fields and,
Configuration of option list
Navigate to Administration > Admin Applets > Configuration Manager > Information Fields
1) Click “Add”
2) Enter VehicleYear for Field Name
3) Enter Vehicle Year for Field Caption
3) Check Enable Options List
4) Click Configure
5) Select Use view check-box
6) Select Vehicle_Year_View
7) Check Use Tree then click “OK” through next two windows
While still in Information Fields add the last field
1) Click “Add”
2) Enter VehicleModel for Field Name
3) Enter Vehicle Model for Field Caption
3) Check Enable Options List
4) Click Configure
5) Select Use view check-box
6) Select Vehicle_Model_View
7) Enable Dependent Field
8) Select Vehicle from Depends on field drop-down
9) Click “OK” through next two windows
10) Click Update Database Design to commit the added fields
Last step is to configure the Vehicle Information Field
1) Select Vehicle from the Information Field tab
2) Click “Configure”
3) Select Use view check-box
4) Select Vehicle_Name_View
5) Enable Dependent Field
6) Select VehicleYear from Depends on field drop-down
7) Click “OK” through next two windows
8) Refresh browser
Once again to validate changes go to check-in page and make sure the correct variables are showing.
There you have it, not one but two option lists before lunch time. This was a couple of examples of option lists, with careful planning and always on a “dev” instance first, more powerful and robust lists can be created.
Any questions or comments please reach me at lou.guerrier@senasystems.com.
The fast and furious 8 is going to be one hell of a movie and I can't wait for it to come out in April. With Charlize Theron and Helen Mirren joining the cast, The
ReplyDeletefast and furious franchise has been pushed to a whole new level. Really looking forward to it.
Movies that earn more than $1 billion worldwide tend to produce sequels. As such, Fast and Furious 8 was a no-brainer. Yet, the ridiculously lucrative Furious 7 ended with real closure Fast and Furious 8 Movie
The web site is lovingly serviced and saved as much as date. So it should be, thanks for sharing this with us
ReplyDeleterun 3
الأزمات الصحية في حياتهم ، لذلك من الضروري تحديد الخدمات التي تقدمها الشركة من أجل تسهيل التواصل معهم والوصول إلى خدماتهم في أسرع وقت. وأهم هذه الخدمات:
ReplyDeleteشركة مكافحة حشرات
They do not prefer sunlight and thus remain hidden in the dark which makes it very difficult to find them, but the insect control company in Ras Tanura is always the best in its field as it relies on certain spraying methods and special pesticides that reach the hiding places for bedbugs to eliminate it completely.
ReplyDeleteارخص شركة مكافحة حشرات
-I personally like your post, you have shared good article. It will help me in great deal.gmail login
ReplyDeleteThis is a great thing, I think everyone feels this information is very valuable, thank you
ReplyDeletewhen looking for the kids ride on cars get it from here
ReplyDeletewhen looking for the autoankauf cologne have to check it from the site
ReplyDeleteif want to have interior designers in bangalore then can check here as well
ReplyDeleteIf the showroom owners work on your devices. Then i think this may reduce the burden of work on them. Also you can get best essay writing to get new ideas for quality work and the procedure of doing it is so easy. That even a common person can handle it.
ReplyDeleteI have read the article I find it very interesting. And if I could I would suggest some interesting things or suggestions for you. Perhaps you can write the next article referring to this article. I want to read more about it! geometry dash
ReplyDeleteHi there! Thank you for sharing very interesting information. I will be glad if I help someone too. As well as helping you to have a good time reading! Guys we are always looking for honest and reliable service and nobody likes to spend their free time, which can be spent on traveling, friends and self-development. Isn't it? If i'm right, there solution of all yours problems! There is a very cool service that has been helping schoolboys and students with their homework for a very long time. They are professionals and know what they are doing, you can definitely rely on them! That's all here https://domyhomeworkfor.me/spanish-homework-help you are welcome! Thanks! Have a good day and be happy!
ReplyDeleteI would like to invite such an amazing writer like you to our website to see and know-how web and mobile app development company is leading the technological industry.
ReplyDeleteYour post is containing the benefits of personalized PHP web app development experience with professionals that introduce better UI/UX, Hire Dedicated PHP Developers for next project.
ReplyDeleteI love what you guys tend to be up too. This type of clever work and reporting! Keep up the awesome works guys I’ve added you guys to our blogroll.
ReplyDeleteMoviesflix
When our views are added, How I can add data to be displayed to end users ? write my case brief please
ReplyDelete
ReplyDeleteتتميز شركة أرمور بتقديم عدد متنوع من الخدمات المنزلية مثل تعقيم المنازل وتنظيف المكيفات
شركة تعقيم منازل بالكويت
يجب على أفراد الأسرة اتباع الإجراءات الوقائيّة في العمل والمنزل، بما في ذلك الحرص على تنظيف اليدين إذا كانت الأيدي مُتّسخة، وبعد استخدام الحمام، وقبل الأكل أو تحضير الطعام، وبعد السّعال أو العطاس أو التمخط من الأنف، وبعد ملامسة الحيوانات
شركة تنظيف مكيفات بالكويت
يؤدي انسداد المكثفات في الوحدة الداخلية لمكيف الهواء إلى تسرب المياه بسبب تجمع الطحالب أو الفطريات عليها، وتتسبب هذه المشكلة في رجوع المياه إلى داخل الأنبوب، وقد تتسرب المياه بسبب وجود عطل في مضخة التكثيف، وعندها يتطلب الإصلاح استبدالها بمضخة تكثيف أخرى.
Nice Article. I will love to subscribe to this blog. ride on cars
ReplyDeleteThe Tarp Co. is one of the best Online tarp sellers in the USA.
ReplyDeleteTarp
Nice one, I like the way you explain every point in this blog. Looking forward to such articles on your website.
ReplyDelete6 finger hand
Vrs Specialists is one of the best car valeting companies in Brighton.
ReplyDeleteCar valet brighton
Hey, I am so excited to share this amazing news with you and all here is a software which edits your video by your own way and give you background music also it is known as cyberlink powerdirector video editor software. if you want to use this amazing software so you can click cyberlink powerdirectorcoupon code here.
ReplyDeleteGreeting! Im a professional content writing.I saw your blog.This is really helpful and informative content.If any one wants Difference between Aims and Objectives topic.You can easily help from google.They will provide you the better information about academic service.
ReplyDelete