Forums

Hi Everyone
CCv6 and CFv6 are much better than v5 but it takes time to learn all the higher possibilities that they offer,
if you have been working with chronoengine the last years you will see the forum is the only free support you will get ,
I want to mention the effort of healyhatman to answer many people, I have learn a lot from him
 but anyway if you spent time (or money) you will find very usefull this framewok,
I have used in the begining as ERP programing but I am currently using it for IOT with spectacular results
Let me share with you some advances about this topic that for sure will help you, anf may be  it can be optimized but what I explain here works
************MY GOAL TO MAKE A DYNAMIC DROPDOWN TO FILTER RESULTS IN CCV6*****************
----------------------FIRST STEP: GENERATE AN ARRAY(KEY/VALUE) FROM A DATABASE
create a database function :
name= read_sensores, model =sensor, database=xxxxxx, select type ="return array key/value pairs ......", field to retrieve = field1 field2 ( on diferent line and order is important because first is the key)
---------------------SECOND STEP:CREATE AND ACTION FORM, without this your search field won't work, you can check html code of a view-widget-search as example of inspiration;-)
you will see that view-fields-group doesn't exist anymore, the reason is that can be easily replaced by individual view-fields-elements
create a form area(it will be your action form) name=filter you can add to this two elements: dropdown adn button, but you can add also two search field if you need it
so in content={view:dropdown}{view:boton} ( on different line) also if you want a professional aspect set class=ui action input fluid

---------------------THIRD STEP:CREATE DYNAMIC DROPDOWN with view-fields-dropdown
name=dropdown, name(ofvariable)=sensor_sel, ID=sensor_sel , options = (space)=None {var:read_sensores} (on different line, first one is to reset search)
(take note of the name of function of first step), this will load automatically the key/values on your filter field
you need now
---------------------FOURTH STEP:CREATE BUTTON from view-fields-button( are not valid other types)
name=boton, type=submit, content=filtrar, name(of variable)=filtra,ID=filtra
---------------------FIFTH STEP:ADD TO INDEX EVENT you have a table_view_list if not you can download an example in ccv6-demos
​
you have defined
{fn:read_fields}(generic database for example)
you only need to add
{fn:read_sensores}(for dynamic dropdown)
{view:filter}(name of second STEP to see filter field on ccv6 form)
you also will have a line like
{view:table_view_list} (that shows you the data rows)
---------------------SIXTH STEP:ADD FILTER TO FUNCTION THAT USE YOUR table_view_list you have a table_view_list if not you can download an example in ccv6-demos
you only have to add to the function{fn:read_fields} a condition
field1(to filter) LIKE {data:sensor_sel}% (related to name of dropdown defined on stepTHREE), have in mind that % is the wildcard for this method of filtering
have also in mind that field1 is the field that you have chosen as key parameter
​
That's all folk , have fun with CC&CF