List view

'list view' allows you to browse and edit all entity items you can filter and search items by clicking the buttons at the top of the list you can sort items on the list in ascending order or descending order by clicking on the column title for example, to show the latest vehicles that were added to the database you need to click twice on the 'create date' column title edit view the 'edit view' feature has the following options ability to copy a view this feature will allow users to easily duplicate an existing view with settings and immediately switch to the copied view ui in the "edit view" menu, under the existing "save default view" option, there is a menu item called "copy view" logic when a user clicks "copy view" , a new view will be created, which is an exact copy of the current view (including all filters, columns, grouping row, sorting, row height, and metrics, except for the share settings) once the new view is created, the user will be automatically redirected to the newly created view share settings share settings will not be copied if the original view was shared with other users, those settings will not carry over to the copied view if a user wishes to share the new view, they will need to manually configure and share the view with other users filters here you can add conditions from the entity properties there are four options for conditions 'is empty'/ 'is not empty' (will look for the items where the chosen condition is/isn`t empty) 'is', 'is not' ( will look for the items that match/don`t match the chosen condition) there is also an option to find items that meet all or any condition for example, you need to find a vehicle that has a 1 5 l dragon engine and is in 'black noir' color you need to add two conditions 'engine version' and 'color', select 'is' on both conditions, and choose the 'meet all of the following conditions' option in the columns section, you can add, delete, and swap columns in order to configure sorting , you need to add a field for sorting and select the asc / desc option you can add fields that are not included in the columns section items will be sorted accordingly to the sorted field but, it won`t show up in the list if it`s not added to the columns section clickable metrics metrics feature is in fact a combination of hyperportal filters with metric statistics data it allows you to easily analyze your stock based on filters that can be preset for each metric you can create and manage existing metrics in the filter panel under the metrics section it allows you to easily analyze your stock based on filters that can be preset for each metric the other important moment is that now you can enable and disable preset metric filters in one click, without the need to spend a lot of time, configuring filters manually you can create and manage existing metrics in the filter panel of the database in the metric settings you can configure 3 main blocks metric calculation rules, which determine what and how the metric should count here you can choose the type of calculation that you want to perform and the field that you what to perform the calculations on available calculations have the following functions average this metric will allow you to find an average value of the entity item field (for example an average price of a vehicle ) the metric is only applicable to numeric type properties sum will sum all chosen values of the entity item field (for example an added price of all available vehicles) the metric is only applicable to numeric type properties min will find the smallest value from the selected entity items (for example the price of the cheapest vehicle) the metric is only applicable to numeric type properties max will find the biggest value from the selected entity items (for example the price of the most expensive vehicle) the metric is only applicable to numeric type properties count unique values will count the amount of the unique values that are used by the chosen entity items (for example a number of engine models that are used by your vehicles) count values will count the amount of the items where the chosen field is not empty (for example number of customers that left their private email) metric units a textual description of your result value (you can set the name of the unit for each available language metric filtering rules allow you to filter items that will be included in the calculations as for the units, please note that currently localized units translations will be saved only if you update your default view after creating a metric the metric in the example filters only those vehicles that have toyota as their manufacturer and then counts how many of those are present in the list now, let say, you have large vehicle stock in your database with just one click you will be able to filter it by make or analyze the total net worth of recently sold electric vehicles you can also apply several metrics at a time and create complex metrics by combining several filters at a time metric filters are applied on top of your default view filters, so they will be applied to what is already filtered in your default view however, please note that at this stage of development the functionality of the view filters is limited there is no possibility to use enclosed filtering rules for the database view this means that your metrics will count the data correctly, but if you want to activate metric filters in your view, you cannot build your filter like electric peugeot \[make = toyota] and \[\[fuel = electric] or \[fuel = hybrid]] currently, you can use only one filtering rule ( and or or ), so your rule will be displayed like this electric peugeot \[make = toyota] or \[fuel = electric] or \[fuel = hybrid] or like this electric peugeot \[make = toyota] and \[fuel = electric] and \[fuel = hybrid] as you can see, the last one will not give you any results, since you cannot have 2 fuel types at once also please note that the all/any rule is shared between the default view and metric filter, so you will be unable to use all (and) in the default view and any (or) in the metric at the same time let's say you have 1 filter in your default view and a metric with 2 filters that are applied to the same property if you apply such metric, you will have 0 results, because global filtering rule (all) will be applied and it is not possible to match make = citroen and make = citröen at the same time you will have to go to your filter panel and switch the rule as you can see, now you have the correct results for citroen metric, but the other metrics are not relevant just yet, because now you have 3 possible conditions that satisfy the filtering rule make = citroen or make = citröen or price is not empty so you have to delete the price filter in order to see the correct values of all the other metrics applied to your citröen vehicles the second limitation to the current metrics logic is the metric accuracy as of now, you can get precise results only if you have up to 3000 items on your list if there are more, the displayed values will be approximate values and may slightly deviate from 100% precise calculations both of these limitations will be addressed and improved in the next development stage bulk editing for bulk editing, check the list of entities and click on the 'bulk edit' button, which will appear in the upper right corner then the bulk edit menu will appear on the right side and here it is possible to set the same values ​​for several selected or all items from the list internal group changes will be abandoned the title and domain user can also change the data by enabling the toggle button for each entity field in the basic info section search to search the list of entities, you need to click on the field 'search' and enter the value of any field of the entity after entering, press enter buttоn the all entities will be filtered to the desired value custom / default view you can save the current view of the object (metrics, filters, and column order are saved) there are two ways of saving a view you can create a custom view (see screenshot below) it will be displayed in a separate tab under the 'views' section in cms then you can edit the custom view separately from the default view, when you are done with the editing you can save the custom view by clicking the 'save custom view' button you can have multiple custom views for one object, each will have separate settings you can also edit the default view of the object to do that you need to find the object in the entities list, then edit view settings, then click on the 'save default view' button after the new default view is saved, the object will be always opened with the default view settings if you have multiple views for one object, you can switch between them using a selector that is located next to the edit view button (see screenshot below) data export you can export data from your current view after you created a desirable view you can export all items by clicking on the icon next to the 'edit view' then on 'export view data' if you need to export all existing entity items you need to click on 'export data' the system will send you a download link to your email the exported file will be in xlsx format it can be opened with most spreadsheets editors like microsoft excel, google sheets, etc