Best approach to having a sort, select and set of action buttons on a table row

Okay so I have a bit of an odd table to achieve and I’m unsure on the the best UI/UX approach to go with.

I have a small table of files, usually at most there would be about 10 files, one of the files must be toggled as a primary file to be used for the category it belongs to. It’s possible to toggle old files as active so each row will have a radio select.

The files will also need to be draggable so that they can be dragged to other file categories. So i need a handle bar for dragging of some sort.

Below I have an example table row labelled to it’s content:

+-------------+--------------+--------------+-------------+ | Grab Handle | Active Radio | file details | edit delete | +-------------+--------------+--------------+-------------+ 

So I’m asking for a few reasons, first is that i know as a general rule it’s best practice to put all action buttons on the right so this may even include the active radio however I’ve seen some tables with selects on the far left except it’s odd to have a handle bar and select next to each other. So would there be a better approach to this or is this fine?

Best approach to having a sort, select and set of action buttons on a table row

Okay so I have a bit of an odd table to achieve and I’m unsure on the the best UI/UX approach to go with.

I have a small table of files, usually at most there would be about 10 files, one of the files must be toggled as a primary file to be used for the category it belongs to. It’s possible to toggle old files as active so each row will have a radio select.

The files will also need to be draggable so that they can be dragged to other file categories. So i need a handle bar for dragging of some sort.

Below I have an example table row labelled to it’s content:

+-------------+--------------+--------------+-------------+ | Grab Handle | Active Radio | file details | edit delete | +-------------+--------------+--------------+-------------+ 

So I’m asking for a few reasons, first is that i know as a general rule it’s best practice to put all action buttons on the right so this may even include the active radio however I’ve seen some tables with selects on the far left except it’s odd to have a handle bar and select next to each other. So would there be a better approach to this or is this fine?

Why can’t I select alternative Working Languages in Term Store Management Tool?

I tried to create a multi-lingual term sets for a SharePoint Online Team Site following this guide. When trying to change the working language all options are grayed out and I can’t select them. Same goes for the other locales option. Under Site Settings > Language Settings the default language is English and all Alternative Languages are enabled. What do I have to do, to add another working language?

Any help would be greatly appreciated, Thanks

enter image description here

Nested select statement work procedure

I was wondering how nested select statement works.

Let me be clear with an example(with an academic example). According to Database system concept of Silberschatz I am using an university database. And here is link to schema.

If I want to “Find the enrolment of each section that was offered in Fall 2017” one way to query database is :


select    course_id,    sec_id,   (select         count(ID)     from         takes     where         takes.year = section.year and        takes.semester = section.semester and         takes.course_id = section.course_id and         takes.sec_id = section.sec_id) from      section  where      semester = 'Fall' and year = 2017; 

I want to know how inner select statement matches rows with course_id and sec_id.

Thanks

At third-level, are rangers allowed to select a drake as their animal companion?

I wasn’t able to find anything about this in 5th Edition. A drake seems that it would exceed the 1/4 challenge rating stated in the PHB.

In this specific campaign, our Dungeon Master allows anything that is accessible on D&D Beyond not including Homebrew content.

I did find the Drake Warden Ranger archetype, which I assume is for Pathfinder, and thought it might be possible that I’d overlooked a similar variant in D&D 5E.

Select count date from multiple where conditions for each day

I have lot of coupons. I would like to learn for each day how many coupons from each campaign have been received by users. But I cannot write something like assigned_date for each select row

SELECT count(id)                                                  as number_of_coupons,        DATE_FORMAT(assigned_date, '%d-%m-%Y')                     as date,        (SELECT COUNT(id) FROM coupon WHERE campaign_id = 1 AND assigned_date=THIS MUST BE SOMETHING) as campaign_1,        (SELECT COUNT(id) FROM coupon WHERE campaign_id = 2 AND assigned_date=THIS MUST BE SOMETHING) as campaign_2 FROM coupon GROUP BY DATE_FORMAT(assigned_date, '%d-%m-%Y') order by STR_TO_DATE(date, '%d-%m-%Y') DESC 

So the result will be something like. How can I achieve this result?

+-------------------+------------+-------------+-----------+ | number of coupons |    date    |  campaign_1 | campaign2 | +-------------------+------------+-------------+-----------+ |               156 | 12-10-2019 |        6980 |       100 | |               177 | 11-10-2019 |        6980 |       100 | |                44 | 10-10-2019 |        6980 |       100 | |                94 | 09-10-2019 |        6980 |       100 | |                93 | 08-10-2019 |        6980 |       100 | +-------------------+------------+-------------+-----------+ 

Ubuntu 19.04 No Audio Input Devices to Select

I’m unable to use my Thinkpad’s microphone with Ubuntu 19.04. When I attempt to choose an audio input device, none are available. When taking a look in pavucontrol, it lists my microphone as unplugged.

I’ve seen a number of similar questions but none of the answers have worked to help fix this problem.

Thanks in advance for any advice.

sound settings screenshot pavucontrol screenshot

How do you create or select an icon for a feature?

How do you work out what icon type or image you need for a feature?

There’s been quite a lot of very small questions here in the form of “What is a good icon for feature X?”.

Instead we should be looking for a general guide in creating or brainstorming for an icon, that can be applied in a lot of situations and applications.

This could possibly be done by looking an intermediary step:

Feature / Semantics

  1. Terms that represent this feature
  2. Icon for that term

E.g.

Level of anger for client

  1. heat map
  2. Icon for heat map

This question is about step 1, the step you use to create a list, ideas or resource for possible icons that will be applied to the feature.

Using rows from one table as fields in SELECT

I have three tables in my MySQL database – company, extra_fields and extra_fields_info:

mysql> describe company; +-----------------------------+------------------+------+-----+---------+-------+ | Field                       | Type             | Null | Key | Default | Extra | +-----------------------------+------------------+------+-----+---------+-------+ | company_id                  | varchar(64)      | NO   | PRI | NULL    |       | | company_name                | varchar(80)      | YES  |     | NULL    |       | | other_stuff                 | varchar(1)       | YES  |     | n       |       | +-----------------------------+------------------+------+-----+---------+-------+  mysql> describe extra_fields; +-----------------------------+------------------+------+-----+---------+-------+ | Field                       | Type             | Null | Key | Default | Extra | +-----------------------------+------------------+------+-----+---------+-------+ | extra_field_id              | varchar(64)      | NO   | PRI | NULL    |       | | field_name                  | varchar(80)      | YES  |     | NULL    |       | | field_required              | varchar(1)       | YES  |     | n       |       | | field_comment               | varchar(255)     | YES  |     | NULL    |       | +-----------------------------+------------------+------+-----+---------+-------+   mysql> describe extra_fields_info; +--------------------------+-------------+------+-----+---------+-------+ | Field                    | Type        | Null | Key | Default | Extra | +--------------------------+-------------+------+-----+---------+-------+ | extra_info_id            | varchar(64) | NO   | PRI | NULL    |       | | company_id               | varchar(64) | YES  | MUL | NULL    |       | | extra_field_id           | varchar(64) | YES  |     | NULL    |       | | field_value              | text        | YES  |     | NULL    |       | +--------------------------+-------------+------+-----+---------+-------+ 

Here’s an example of some of the data from these fields:

mysql> select efi.extra_field_id, ef.field_name, efi.field_value, efi.company_id from extra_fields_info left join extra_fields ef on efi.extra_field_id = ef.extra_field_id; +----------------+-------------------+--------------------------------+------------+ | extra_field_id | field_name        | field_value                    | company_id | +----------------+-------------------+--------------------------------+------------+ | 1              | is_affiliate_user | y                              | 1          | | 2              | contact_email     | email@gmail.com                | 1          | | 3              | default_currency  | MYR                            | 1          | | 4              | vertical          | 33                             | 1          | | 5              | contact_locale    | en                             | 1          | | 6              | operating_country | MY                             | 1          | | 7              | company_name      | SomeCompanyName1               | 1          | | 1              | is_affiliate_user | y                              | 2          | | 2              | contact_email     | email2@gmail.com               | 2          | | 3              | default_currency  | EUR                            | 2          | | 4              | vertical          | 3                              | 2          | | 5              | contact_locale    | en                             | 2          | | 7              | contact_name      | ContactName                    | 2          | | 6              | operating_country | FR                             | 2          | +----------------+-------------------+--------------------------------+------------+ 

What I’d like to do is use some of the rows in the above output as fields in a SELECT. I’d like to visualise my data like this:

+------------+------------------+------------------+-------------------+----------+ | company_id | company_name     | contact_email    | operating_country | vertical | +------------+------------------+------------------+-------------------+----------+ | 2          | SomeCompanyName1 | email2@gmail.com | EUR               | 3        | | 1          |                  | email@gmail.com  | MY                | 33       | +------------+------------------+------------------+-------------------+----------+ 

As you can see, I’m using some of the extra_fields as field names. I only need to select a few of these fields as depicted above – I don’t need all of them.

I’m not even sure where to start with this, so any guidance would be appreciated.