How to handle filtering on columns of a table?

I am currently working on a pretty complex (and convoluted, I’ll admit) table in terms of filtering. One of the options for filtering allows the user to filter on an item that is displayed as a column and I’m trying to figure out the least confusing / jarring way to update the table for it.

This is hard to describe in words, I’ll be honest so here’s a GIF showing the functionality.

enter image description here

I added blocks to hide some data so pay no mind to the floating grey boxes :).

Preview

Currently, only the selected items for that filter are shown in the table and the rest are removed. This has the benefits that the user doesn’t have to see or think about information that they don’t care about, but then they have to re-adjust to what is effectively a “new” table. The other option is to gray out the unselected columns so the information is still there but taken out of focus.

What method from the above, or some other if you have ideas, do you think would confuse the user the least?

Users want to create tables with many columns and infinite scrolling rows – how do we handle this?

I have a situation where users are capable of creating their own searches on extensive data sets, using a query-like user interface. Our users come from a strong Excel background and are used to working with dozens or more columns in those.

Our search system provides a full screen interface with infinite scrolling and fixed headers, as sometimes these searches can return millions of records. We tested limiting the number of columns on a search to 12, but users were vocal about their desire to have more.

We get asked to add horizontal scrolling, but this works poorly with the existing system of fixed headers and infinite scrolling, in addition to generally making for a poor user experience.

Because the users select the columns themselves and can write custom columns using mathematical functions or aggregates on previous columns, it is difficult to predict the final appearance or content of the searches and not likely possible to condense multiple columns into a single cell.

Are there any patterns or shortcuts to provide what the customer is asking for without compromising experience or functionality?

how to get cascading drop down values from two child columns

I have a cascading drop down where if I select a value from the parent column, I want the child column to be populate it with values from two potential matching columns in the relationship list (i.e two relation ship list child columns)

$  ().SPServices.SPCascadeDropdowns(       {           relationshipList: "AGSL HCP DB",          relationshipListParentColumn: "Doctor_x003a__speciality",           relationshipListChildColumn: "Clinic_x0020_1_x003A_Town" "Clinic_x0020_2_x003A_Town",   **<<<<---- these are the two columns I want to check results from when speciality is selected**         parentColumn: "Specialties",           childColumn: "ClinicLocality",           debug: true       });  

is there a way to achieve this maybe with CAML Query?

How can I filter a library using multiple columns?

I’m trying to filter a library using multiple columns, by project number, type, and an additional category, however when I use multiple filters, the filters applied last don’t apply properly. For example, if I apply the type “pdf” filter last, some docx items are included. If I apply the project number filter for “8” last, then some 9 10 11 items are included. Has anyone experienced this issue?

Search using REST endpoints on two different columns with OR condition in Magento 2

I’m using Magento v2.3 and using API to search products.

Following is the search criteria code.

'searchCriteria[filterGroups][0][filters][0][field]': 'name', 'searchCriteria[filterGroups][0][filters][0][value]': '%test%', 'searchCriteria[filterGroups][0][filters][0][conditionType]': 'like', 'searchCriteria[filterGroups][0][filters][1][field]': 'meta_keyword', 'searchCriteria[filterGroups][0][filters][1][value]': '%test%', 'searchCriteria[filterGroups][0][filters][1][conditionType]': 'like', 'searchCriteria[filterGroups][2][filters][0][field]': 'status', 'searchCriteria[filterGroups][2][filters][0][value]': '1', 'searchCriteria[filterGroups][2][filters][0][conditionType]': 'eq', 

I want something like this (OR condition between two different columns).

WHERE name like ‘%test%’ OR meta_keyword like ‘%test%’

But above code doesn’t give me desired results.

I have gone through documentation of Magento here https://devdocs.magento.com/guides/v2.3/rest/performing-searches.html

but the examples shown in above link are “OR conditions on same column”.

Thanks in advance!

How to maintain unique sequence across table columns?

I hava two tables registed_products and unregisted_products. Both have autoincrement primary key which can be overlapping which if 100 id exist reg table, it can exist in unreg table as well. Insert can come from many places with in the application

There is third service expecting unique id for both type of products.

In oracle , I could have introduced one more column in each table. Create a sequence. Now could create the trigger before_insert on both the tables so that whenever there is an insert in any table, trigerr will get the next_val from sequence and insert in to new column. This way I can ensure unique number across table columns.

I am not sure how to achieve the same in mysql as there are triggers but not sequences that can be used across tables ?

Best practices to allow user to hide/show columns in a data table

I have a table which can contain more than 15 columns, it is not likely that users will see the 15 columns at the same time, but I need to give them the option to select which columns they want to see. I added a section in the table to allow the user to choose from the “Available columns” and move them to the “Selected columns” that will be displayed: enter image description here

But the client didn’t like it, because he is looking for something more interactive and intuitive. Can you recommend me other controls that I can use? Note! The table is like an excel table, user can expand, filter and sort by column. I was thinking of using something similar to excel to hide the columns, but I couldn’t find out how to make the “show” columns.