Make some fields unchecked(not visible) in flat mode for csv data

Hi, Viktor!
 
Thank you for writing to us.
To specify certain fields to be shown on the grid, we recommend using the configuration of a flat table, similar to an example below:
https://jsfiddle.net/flexmonster/cwvzymfx/
 
Please let us know if everything works fine.
 
Best Regards,
Maksym

Hello, Tigran!
 
Thank you for reaching out to us.
 
Kindly note that it is possible to deselect fields in the Field List by setting the visible property of the MappingObject to false:

data: [
   {
      "Price": {
         type: "number",
         visible: false
      },
   },
   {
      "Price": 174
   }
]

We have prepared a JSFiddle example for visualization: https://jsfiddle.net/flexmonster/92zmuw30/.
 
We also want to mention that the slice is the main configuration property in Flexmonster. 
Could you please tell us why the slice.columns property is not suitable for you?
 
Looking forward to hearing from you.
 
Regards,
Solomiia

Hello, Tigran!
 
Thank you for the details about your use case.
 
Kindly note that it is only possible to include hierarchies to be shown on the grid. 
However, we kindly suggest a workaround to deselect the necessary fields using getAllHierarchies() and runQuery() API calls along with reportcomplete event.
 
The idea lies in the following:
 
1. Create the Flexmonster instance without the slice property. It will load all existing fields to the flat grid.
2. On the reportcomplete event handler, get all available fields with getAllHierarchies() API call:

flexmonster.on("reportcomplete", function() {
  let allHierarchies = flexmonster.getAllHierarchies();
}

3. Filter from the resulting array the fields you don't want to be shown on the grid. For example, you can use the Array.prototype.filter() method:

allHierarchies = allHierarchies.filter(/* filtering condition */);

4. Run the runQuery with the resulting array in the columns property:

flexmonster.runQuery({
    columns: allHierarchies
});

We have prepared a JSFiddle example for visualization: https://jsfiddle.net/flexmonster/7cwntbs0/.
 
Hope you will find our answer helpful.
Please let us know if the suggested approach works for your case.
 
Regards,
Solomiia

Hello, Tigran!

Hope you are doing well.

Our team is wondering if you had a chance to try the suggested approach to exclude hierarchies using runQuery(). Could you please let us know if it works for your case?

Looking forward to hearing from you.

Regards,
Solomiia

Hello, Tigran!

Hope you are having a great week.

Just checking in to ask if the suggested approach was helpful in deselecting the necessary fields from the Field List.

Looking forward to hearing your feedback.

Regards,
Solomiia

Hello, Tigran,

Thank you for the response.

Kindly note that it is possible to choose which fields should not be selected, even if the fields in your data set are dynamically updated.
This behavior can be achieved by following the next steps:

1. Get all the fields from the dataset into the array
2. Filter the fields you don't want to be shown on the grid from the resulting array.
3. Display on the grid only the necessary ones.

This approach can be implemented using the getAllHierarchies() API call. This method would preserve the order of hierarchies from the original dataset.
You can implement the described approach if you know which fields should be unselected. Feel free to check the example in the following JSFiddle: https://jsfiddle.net/flexmonster/7cwntbs0/ 

Please let us know if such an approach would work for your case. Looking forward to hearing from you.

Kind regards,
Nadia

Hello, Tigran!

Thank you for your feedback.

Our team is glad to hear that the suggested approach was helpful.

Feel free to contact us in case of any other questions.

Best regards,
Solomiia