It's a Generic Inquiry, Enable Mass Updates and set the status to something not HOLD Then you can do this When you click Finish th...

Ah SQL. Actually I got that wrong In SQL the where statement would be (Given just Customer on its own row would be attribute sort order 3): W...

It looks right. You have 3 columns. Column 1 will always be Customer.BAccountID (or similar) Column 2 will be IIf([CSAttributeDetail.SortOrder] ...

@roycelithgo It doesn't scale to large data on MySQL very well where you have quite a number of joins. I've had timeouts. Should be sweet as on MS SQL...

This is nuts. But thanks. I can use this and call it my own 🤡

@timrodman Yeah, there's a reason why MS SQL Server costs more. Perhaps it's the Master Data Services or the Data Quality Services or the Integration ...

I like IsNull() as a function. =IIf( IsNull([POReceipt.ReceiptType], '') = '', ' ', ' ' ) It replaces the value with the second parameter if null...

I think he was doing this

Adding this parameter to the URL will control the columns I believe. Works in PostMan anyway! $select=<list of columns you actually want sepa...

@timrodman I think the Too Complex is equivalent to a CROSS APPLY in T-SQL. It happens after all the rows are fetched making it a bad candidate for a ...

@timrodman Yeah, beware on MySQL versions that the view has performance issues. It appears that MySQL can put the contents into a temp table i.e. to d...

@infosourcing I assume VendorLocation as opposed to just Location

Hi All So I found the reason why this didn't work. When I created the Dashboard I created the Parameter as Required. I then created th...

@jbeck From what I just read they just say you can't do Grouping. In fact I believe you can't pick a GI that has grouping. Excellent fix!