View users by filter

I’m trying to display a list of members on my site in a way that looks similar to what this site does: https://cgli.net/members

With all these user filters (by country, groups, area…), is there a WordPress plugin that does this?

SSRS reports resets the parameters to default after I click on “View Report”

We are using SSRS version 16(build 13.0.x) in Native mode.

I built a report using Report Builder with 2 parameters(independent). Everything works as it should when I run the report in Report Builder.

When I publish it to WebPortal – some random set of users have the following issue:

  1. Through WebPortal URL, they click on the report to open in browser, we have always used chrome.
  2. They populate the parameters and click on "View Report".
  3. The report starts "Loading" and immediately the parameters are reset to default(or blank) and the report area goes blank. They couldn’t even see the column header or the menu bar in the report area.

Apart from a handful of seemingly random users, everyone else have no issues.

We use SQL accounts for authentication and all users have permissions to fetch data from tables. I checked if this issue is only with certain kind of parameters, but there seems to no common denominator.

I’ve come up dry on PowerBI, Technet forums. I appreciate any help/troubleshooting steps. Thanks 🙂

Basic Projection & View matrix

Currently writing a camera component for FNA (basically XNA), and can’t for the life of me figure out why my matrix transform isn’t working as expected. This is how I calculate my view & projection matrices:

// projection // WorldSize is something like 16x9, 20x10, etc. Basically the "simulated" world size. // Zoom is just a float to zoom the camera. var left = Zoom * -WorldSize.X / 2; var right = Zoom * WorldSize.X / 2; var bottom = Zoom * -WorldSize.Y / 2; var top = Zoom * WorldSize.Y / 2; const float near = 0; const float far = 100; var projection = Matrix.CreateOrthographicOffCenter(left, right, bottom, top, near, far); 

and

// view // Position is the position of my Camera, e.g. (10, 15), (6.51, 16.612), etc. var position = new Vector3(Position, 0); var target = position + Vector3.Forward; var up = Vector3.Up; var view = Matrix.CreateLookAt(position, target, up);  // Combine them var combined = projection * view; 

This should, by all the sources I’ve checked, double-checked, and triple-checked, be correct. However when I apply this matrix to my batch or effects it doesn’t show anything at all:

// I would expect a white square to be rendered in the middle of the screen. Since WorldSize is // 16x9 I would expect a 1x1 square to be clearly visible. var batch = new SpriteBatch(); batch.begin(/* the rest */, combined); var texture = new Texture2D(Game.GraphicsDevice, 1, 1); texture.SetData(new []{Color.White }); batch.Draw(texture, Vector2.Zero, Color.White); batch.End();  // Also tried just rendering lines, shows nothing var effect = new BasicEffect(graphicsDevice) {     VertexColorEnabled = true,     View = view,     Projection = projection }; effect.CurrentTechnique.Passes[0].Apply(); graphicsDevice.DrawUserPrimitives(PrimitiveType.LineStrip, vertices, 0, vertices.Length - 1); 

I have checked so many sources and they all do exactly like this. I even tried copy+pasting the matrix source code for a Java project I made some time back that I know works, and that didn’t work either so I don’t think the Matrix transforms are to blame. Anyone know what I’m doing wrong?

MySQL – Call a View inside a Stored Procedure

Let’s say, I have a table as follows

tbl_1

id             name                 status               usertype                         flag ================================================================================================ 1              Name 1                  1                    2                               0 2              Name 2                  1                    3                               0 3              Name 3                  1                    1                               0 4              Name 4                  1                    4                               0 5              Name 5                  1                    5                               0  

HTML PAGE

<select id="type" name="type">    <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option>  </select> 

My requirement is that I need to get all the data from table where the usertype is selected from the html page by the user (could be 1, 2, 3,4,5, etc.)

I want to create a view, and call that inside stored procedure

I cannot pass an argument inside of a View. So, I was told to create a stored procedure, and call the view inside it. The problem is, I don’t know how to do it.

Access Subdatasheet (plus sign) not showing in datasheet view form but shows in table or query

I want to show inside a form in datasheet view, the plus signs for viewing subdatasheet. I have tables properly linked, all is fine and I have subdatasheet set in table/query and it displays correctly and all information well linked.

I have a form based on that table/query that has the subdatasheet but when I open the form in datasheet view so that I can see the subdatasheet, this wont show up. The plus signs are not there.

I just want a form for looking up data, not for editing and subdatasheet view serves perfectly what I want to achieve but I don’t want to open tables or queries directly but inside a form.

How to allow certain role to view Customer list

I have custom user role called Salesman. Whenever a Customer create order, a salesman was assigned to that Customer.

I need to allow user role Salesman to access WooCommerce -> Customer page.

I’ve search all available capabilities using User Role Editor plugin but none about list customer. list_users display User list page, but not the WooCommerce -> Customer page.

Woocommerce Custom product fields need to be editable after purchase in View Orders Page

I am Using https://stackoverflow.com/questions/46612499/display-a-custom-field-value-in-woocommerce-orders-edit-view/#answer-46615303 answer code, which works fine.

I want to display that checkout custom fields on My Account > View Order Pages, to allow customer to edit its value after purchase, so Customers can change and save the custom field value.

Any help?

AnyDice: semantics of output headers in “export” view

I hope this is on-topic: In AnyDice, when choosing the "Export" view, output d6 is displayed as:

"output 1",3.5000000000069997,1.707825127661641,1,6 #,% 1,16.6666666667 2,16.6666666667 3,16.6666666667 4,16.6666666667 5,16.6666666667 6,16.6666666667 

I’m not quite sure what the numbers in the first line signify, the last two (1 and 6) are presumably the range of values that the rolls can take on but what about the other two (3.5 and 1.7…)? I have not been able to figure this out from the documentation.

MariaDB views: I want to replace repeated multi-table joins in my queries with a view – are there any issues to watch out for?

Rather than

SELECT a.pk, b.pk, c.pk, d.name  FROM a JOIN b on b.pk = a.fk JOIN c on c.pk = b.fk JOIN d on d.pk = c.fk 

I can do

SELECT a_pk, b_pk, c_pk, d_name  FROM view_a_b_c_d 

I have a lot of this sort of thing through my code.

I’ve done a performance test, and the differences seem to be negligible, and I feel it would greatly tidy my codebase up and remove a lot of repetition.

But before I commit to that (as it’d be a big change with a lot of work and testing), I want to check that this IS a good thing to do. I didn’t study computer science and have no formal DBA training. I’m also a sole dev working on my own closed-source product. So I don’t get much input from the outside world, unless I strike out and ask for it.

Thank you – any opinions/experience appreciated.

MSSQL – Incapacity to query underlying table of a schemabound view

I migrated a database from SQL Server 2008R2 to SQL Server 2019 (both enterprise edition) using backup-restore technique and a set of post-transfer actions like DBCC UPDATEUSAGE or UPDATE STATISTICS XXX

At statistics update, I get following error:

Msg 402, Level 16, State 1, Procedure ZZZZ, Line 5 [Batch Start Line 0] The data types datetime and time are incompatible in the add operator. Msg 4413, Level 16, State 1, Line 1 Could not use view or function 'ZZZZ' because of binding errors. 

I know that the message is quite explicit (the view, which was syntactically correct in MSSQL 2008R2 is not anymore in MSSQL 2019) but I don’t understand why would a view defined WITH SCHEMABINDING that is not valid would prevent the update of statistics on an underlying table.

Moreover, I get the same error message when querying the underlying table with a WHERE clause, except if I force a FULLSCAN with following hint:

OPTION(TABLE HINT( $ mytable, FORCESCAN ))

I know SQL Server will fire an error in case of DDL change to underlying schema-bound objects, but I don’t understand why, if the view is invalid, the underlying objects cannot be used as usual. I’m sure there is an explanation (like the protection mechanisms for schema-bound views cannot be processed due to the invalidity of the view), but I can’t find it for sure in MS documentation…