Clerk | Self-hosted habit tracker and event logging web app | Privacy library

I want to filter the 2nd drop-down list based on the 1st drop-down list.

for example: if I select 'finance' from 1st drop-down list, the 2nd drop-down list will show all 'finance' value(accountant, property custodian), and if I select 'academic and research' from the 1st drop-down list, the 2nd drop-down list will show all 'academic and research' value(clerk, HiEd libririan).

this is my current code and its not working:

1st drop-down list:

...

My table is :

loginid name role 12 abc analyst 12 abc clerk 142 xyz clerk 142 xyz manager 1 yash manager 1 yash ceo 2 aarav president 2 aarav ceo

I want to display each login id once and if it has two or more than two roles it is expected to show this result :

loginid name role role 12 abc clerk analyst 142 xyz manager clerk 1 yash ceo manager 2 aarav ceo president

but then I was able to write following query :

...

I have a sample table below:

...

I like very much css grid because of its simplicity. But there seems to be a performance issue with css grid that flexbox does not have.

I have implemented a two column full screen page both columns having a form with input box and a list of items with overflow-y:auto. One example where the left and right panel are implemented using flexbox and one where left and right panel are implemented with css grid.

this is the flexbox version : https://web-platform-wtfgmj.stackblitz.io/

and this is the css grid version : https://web-platform-wtfgmj.stackblitz.io/index2.html

Open the developper tools in chrome and enable paint flashing (tools/rendering has to be enabled). When typing in one of the input boxes, the css grid version will repaint all items in the list. The flexbox version does not have this problem.

I would like to understand why css grid repaints all items in the list when typing in the input box ? And can it somehow be avoided ?

Update : Seems to be problem with stackblitz... included as code snippets

Update 2: because it's little bit burried in comments: So I filed a bug report with chrome (bugs.chromium.org/p/chromium/issues/detail?id=1204446, upon suggestion of dgrogan) and they seem to confirm that it is a performance issue with chrome's current grid implementation. Apparently they are busy with a new implementation LayoutNGGrid which would solve the issue

...

This is what my console says upon running my Angular app (localhost:4200) –

...

Please help for the task
Display all the details of the employees whose commission is more than their salary and create additional column – “Salary_range” of employees that are Managers or Salesmen for their salary range in following groups “Less than 2000”, “Between 2000 and 5000” and “More than 5000”, for all other employees(not Manager and neither Salesman) value should be ’MISSING’.

...

Using the information below I need to create a new table in DAX called Table (Download a demo file here).

I need to find the location of each employee (column "Name") at the time of the sale date in column "Sale Date" based on their contract details in table DbEmployees. If there is more than one valid contract for a given employee that the sale date fits in, use the shortest contract length.

My problem is that the below measure isn't working to generate column "Location", but it works just fine for column "new value".

Why is this happening and how can it be fixed?

Expected result:

SaleID EmployeeID Sale Date new value Name Location 1 45643213 2021-02-04 89067445 Sally Shore 4 2 57647868 2020-04-15 57647868 Paul Bunyon 3 3 89067445 2019-09-24 57647868 Paul Bunyon 6

DbEmployees:

ID Name StartDate EndDate Location Position 546465546 Sandra Newman 2021/01/01 2021/12/31 1 Manager 546465546 Sandra Newman 2020/01/01 2020/12/31 2 Clerk 546465546 Sandra Newman 2019/01/01 2019/12/31 3 Clerk 545365743 Paul Bunyon 2021/01/01 2021/12/31 6 Manager 545365743 Paul Bunyon 2020/04/01 2020/05/01 3 Clerk 545365743 Paul Bunyon 2019/04/01 2021/01/01 6 Manager 796423504 Sally Shore 2020/01/01 2020/12/31 4 Clerk 783546053 Jack Tomson 2019/01/01 2019/12/31 2 Manager

DynamicsSales:

SaleID EmployeeID Sale Date 1 45643213 2021/02/04 2 57647868 2020/04/15 3 89067445 2019/09/24

DynamicsContacts:

EmployeeID Name Email 45643213 Sandra Newman sandra.newman@hotmail.com 65437658 Jack Tomson jack.tomson@hotmail.com 57647868 Paul Bunyon paul.bunyon@hotmail.com 89067445 Sally Shore sally.shore@hotmail.com

DynamicsAudit:

SaleID Changed Date old value new value AuditID Valid Until 1 2019/06/08 65437658 57647868 1 2020-06-07 1 2020/06/07 57647868 89067445 2 2021-05-07 1 2021/05/07 89067445 45643213 3 2021-05-07 2 2019/06/08 65437658 57647868 4 2020-06-07 2 2020/06/07 57647868 89067445 5 2021-05-07 2 2021/05/07 89067445 45643213 6 2021-05-07 3 2019/06/08 65437658 57647868 7 2020-06-07 3 2020/06/07 57647868 89067445 8 2021-05-07 3 2021/05/07 89067445 45643213 9 2021-05-07 ...

Lets assume I have an array of objects:

...

I want to pull down the clerk of the same shop as the logged-in staff with the Symfony 4.4 app.
Also, I want to display the logged-in staff at the beginning of the pull-down.
I'm trying with the code below, but I get the following error.
How can I meet my demands?　Looking at the documentation, I couldn't find a method that looked very good.

Similar questions are posted on the link below. https://www.reddit.com/r/symfony/comments/mkh5xh/how_to_get_data_of_specific_conditions_by/

Error

...