MS SQL transfer ID over URL fails due to type conversion error

[bmc8923]

Hi,
I am having issues trying to edit a table row on a new screen. To do this I am trying to transfer the ID of that row to that new screen.

However, when I try to do this I get the error "Conversion failed when converting from a character string to uniqueidentifier."
In the projects screen that displays the table of data, I have an on-row click action. This action is a navigate action that navigates to a screen "/projects/:id".

On the projects/:id screen, i have a data provider that connects to the project table with the below filter

Below is an example of my ms table

[ConorWebb96]

Hey @bmc8923,

I haven't been able to replicate. I've tried this both in MySQL and Ms SQL and Budibase seems to handle everything perfectly fine.

What version of Budibase are you running?
Are you self-host or cloud based?
What are the exact values you are pushing to the server?
Can you output these keys somewhere and verify how they are displayed?
How did you create the table? (Below is the MS SQL and MYSQL query used to create the table that seemed to work fine.)

Ms SQL

CREATE TABLE master.dbo.sampletable (
    id int IDENTITY(1,1) NOT NULL,
    sampletext nvarchar(MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [date example] datetime2 NULL,
    [Unique] uniqueidentifier NULL,
    CONSTRAINT PK__sampleta__3213E83FBD5EC771 PRIMARY KEY (id)
);

MySQL

CREATE TABLE sampletable (
    id INT AUTO_INCREMENT NOT NULL,
    sampletext TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
    `date example` DATETIME NULL,
    `Unique` CHAR(36) NULL,
    PRIMARY KEY (id)
);

Personally I think this could be an issue with the DB as the error comes when SQL Server is trying to convert a string to a UNIQUEIDENTIFIER - but the string does not represent a GUID, i.e. does match the pattern for UNIQUEIDENTIFIER.

Hopefully this makes sense somewhat.