worksheet function – Go into “Display” tab, click a name off the drop down list, and view that individual’s data

I have 3 tabs. “Timestamps” “Techs/Locations” and “Display.”

My form timestamps when an employee clocks in or out. I have created two separate columns to carry over the date and time from the timestamp column (which is hidden)

The form set up my sheet to have columns B:AA as each location.

As a clock in/out is performed, it records the name under the corresponding location’s column.

I want to carry over the data of the employee of my choice has onto my DISPLAY sheet. I have tried Vlookup, but it only searches in the FIRST column. I have 26 COLUMNS. There is no way around the number of columns I have discovered.

I have tried INDEX/MATCH, Query, etc. The DISPLAY sheet has a drop down list of the employees. I wanted to do something such as:


Here is a link to an identical sheet with all information shortened and changed:

Again, I want to be able to go into “Display” tab, click a name off the drop down list, and view that individual’s data- which would be pulled from “timestamps.”

postgresql – Unable to create view with temp table

Hi I am working on one project and want to create a view. I am using temp table in my query. can any one let me know how we can create such view ?

Following is my query, I tried using WITH..AS , but it gives due to insert query.

create temporary table temp_testtbl as
select id,dte,name,hrs_total
FROM dttbl.dts limit 0;

insert into temp_testtbl 
select id,dte,name,hrs_total
FROM dttbl.dts 
group by id,dte,name,hrs_total;

SELECT i.dte,
    1 AS entity_id,
    sum(i.hrs_total) AS myhrs
   FROM temp_testtbl i
   JOIN schema1.mytable idm ON idm.src_id = i.iex_id::text AND idm.src_type_id = 123 AND idm.end_dte IS NULL
   JOIN schema1.mytable idm2 ON idm2.empl_id = idm.empl_id AND idm2.src_type_id = 345 AND idm2.end_dte IS NULL
  GROUP BY i.dte, idm.empl_id limit 100;

8 – Different custom view per taxonomy

I’m currently working on my first Drupal 8 project and while many things are now integrated in the core, others still stump me (for example restoring options to now bare bones CKEditor requires like 4 additional modules). As I relied on Taxonomy Display module to display different taxonomies with different views and this module is not ported to D8 while similar module TVI is still in beta, I am left wondering what’s the current standard of handling this use case. I could use template_preprocess_views_view to programatically switch displays depending on vid. Some suggested you can just use contextual filters to do the same, but I don’t see how could you switch between different displays using contextual filters. To me it seems that multiple views would run at once, but some would return empty result sets, spamming database with duplicated queries. Is there really no cleaner way to do it?

Can I set up a Google Analytics view that filters out anyone with a user-id tagged on them?

If you are capturing the user-id and sending it as a user scoped custom dimension, then you will be able to apply a filter to a View to exclude the users assigned a value for that particular custom dimension.

In doing this, any data before they are assigned a user-id and have it applied as a custom dimension will remain in the reports.

Drupal 8 View data export in Excel, date field adds a hidden apostrophe

I use Excel Serialization to export views data on Excel. The exported file (xls or xlsx it doesn’t matter) adds a hidden apostrophe in the beginning of every date cell (’08/07/2011) which can be seen only on the input line. This leads to wrong column sorting. The cell format is Number instead of Date and this probably causes the problem.

There is a workaround to remove the apostrophes from the whole column, but I want to have the cells without it from the beginning. Is there any way to do this? Maybe by formatting the column before the export? No support from the module maintainers. Any ideas?


Can we change the view of a Sharepoint list to calendar view?

I have created a SharePoint list that I am using in my Microsoft flow for leave approval system.
The list looks great with all the requests being tracked there.
However, would it be possible to change the view of this list to a calendar view, i.e. same list but in a calendar?

I do have some calculated columns, so not sure how that would work in a calendar. But if somehow I can incorporate my list into a calendar, that would be great to have a calendar view.

magento2 – Extender “Recently Product View” para añadir JS Magento 2

Tengo una duda, estoy realizando una mejora en el widget de productos vistos recientemente y me surgen dudas de como hacerlo.

Quiero mantener la funcionalidad que tiene M2, pero añadir el listado que se muestra a través del localstorage como un slider, con lo cual tengo ya listo el js y la librería en mi módulo.

Como puedo extender la funcionalidad del core y añadir mi js y nuevo diseño? sin tocar el core.


How to correct a view query?

I would like to know how to correct a view query, when Drupal goes nuts ?

I’m using a view that should list media by categories (taxonomy term).
This view is called by a node, that held a reference to the same categories (same taxonomy term) that the medias I wish to display.

I need to order thos categories according to the delta field on my node object.

So in my views I did a join from the media taxonomy field to the taxonomy terms.
Then, I have a join on my any node that hold the taxonomy field.
I filter on the nid through contextual filters.

Until then all is good.

However, if I add the sort Critera on the delta value of categorie, the views module add another (unnecessaray) join on the table holding data for my taxonomy field on my node. This confuses my database and then I get a scalar product as results (every media is sent back, for each existing delta line).

Exemple of the query (I get two joins on node__field_categorie) :

    SELECT DISTINCT AS field_categorie_taxonomy_term_field_data__node__field_catego, media_field_data.mid AS mid, taxonomy_term_field_data_media__field_standard_termref_1.tid AS taxonomy_term_field_data_media__field_standard_termref_1_tid, field_categorie_taxonomy_term_field_data.nid AS field_categorie_taxonomy_term_field_data_nid
{media_field_data} media_field_data
LEFT JOIN {media__field_standard_termref_1} media__field_standard_termref_1 ON media_field_data.mid = media__field_standard_termref_1.entity_id AND media__field_standard_termref_1.deleted = '0'
INNER JOIN {taxonomy_term_field_data} taxonomy_term_field_data_media__field_standard_termref_1 ON media__field_standard_termref_1.field_standard_termref_1_target_id = taxonomy_term_field_data_media__field_standard_termref_1.tid
INNER JOIN {**node__field_categorie**} taxonomy_term_field_data_media__field_standard_termref_1__node__field_categorie ON taxonomy_term_field_data_media__field_standard_termref_1.tid = taxonomy_term_field_data_media__field_standard_termref_1__node__field_categorie.field_categorie_target_id AND taxonomy_term_field_data_media__field_standard_termref_1__node__field_categorie.deleted = '0'
INNER JOIN {node_field_data} field_categorie_taxonomy_term_field_data ON taxonomy_term_field_data_media__field_standard_termref_1__node__field_categorie.entity_id = field_categorie_taxonomy_term_field_data.nid
LEFT JOIN {media__field_domain} media__field_domain ON media_field_data.mid = media__field_domain.entity_id AND media__field_domain.deleted = '0' AND (media__field_domain.langcode = media_field_data.langcode OR media__field_domain.bundle = 'useful_document')
LEFT JOIN {**node__field_categorie**} field_categorie_taxonomy_term_field_data__node__field_categorie ON field_categorie_taxonomy_term_field_data.nid = field_categorie_taxonomy_term_field_data__node__field_categorie.entity_id AND field_categorie_taxonomy_term_field_data__node__field_categorie.deleted = '0'
WHERE ((media_field_data.status = '1') AND (media_field_data.bundle IN ('useful_document'))) AND (media__field_domain.field_domain_target_id LIKE 'intranet_adapei69' ESCAPE '\')
ORDER BY field_categorie_taxonomy_term_field_data__node__field_catego ASC

Exemple of my view, so you can better understand.

enter image description here

How can I correct such a query ?
I’m using Drupal 8.7.12 and can’t upgrade for the moment.
I guess the easier way around this would be to be able to add an order by clause using the column made available by my first join on : node__field_categorie

I looked into query_alter and views_query_alter hooks, but it seems it is no longer possible to add an order by clause there (or I tried the wrong way). Any ideas ?

query – MySQL Dynamic Result view with column when values are on same column

I want to create a dynamic value based on election result. I’ve three table.

  1. vote table
  2. Candidate table
  3. Candidate position table.

Here the candidate table and position table is dynamic. its means I haven’t any control on it.

I want to make a view like this:
enter image description here

Here Ballton num come from vote table, president, general secretary and treasurer is come from candidate position table and against each ballot no all column will be populate.

Here are the rest of the table structure:

enter image description here

enter image description here

Candidate position:
enter image description here

8 – View listing related nodes by taxonomy term

Many of the Drupal features seem magical, but sometimes there are more steps to configure to make them work.

How to use Views Preview with Contextual filters

Contextual filters are strictly linked to individual Fields. It isn’t enough to use only the NID Contextual filter (in your Preview) that would then be able to “pull” all the other information, no matter if you have the other Contextual filters set up.

What you enter into the Preview field is what Drupal would take from the URL, or the specified default value as if the URL value is available.

If you have two Contextual filters, you need to enter two filter values into the Preview, one for each filter, in the correct order, separated by /.

To test the complete situation you enter a value for both Contextual filters, for example thriller/35 or 21/35 if Thriller has TID 21 and your first Contextual filter is for term ID and not term name, and 35 is the “current node” NID.

Most Contextual filters have the Exception value set to all. This is a sort of a bypass, the Contextual filter behaves as if it weren’t there.

So if you have two Contextual filters and you enter all/all you will see the Views results as if there are no Contextual filters at all.

This is useful when you have to test a Contextual filter while making sure the other one isn’t in the way. So you enter all/35 to see all nodes but not the current one (if the current one has NID 35). Or you enter thriller/all so see nodes tagged Thriller but the current one is still on the list.

The Views Preview field (arguments) can test only the part of the Contextual filter that has Provide default value or When the filter value IS available or a default is provided options.

Preview does help to test and configure Contextual filters more quickly, but it doesn’t gurantee that you have set them up correctly for cases that don’t take values from the URL, so you have to test the Block on the appropriate location anyway.