Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

When using refinements, unsupported type appears in JSON but not in HTML #1764

Closed
bporterfield opened this issue Jul 11, 2024 · 0 comments · Fixed by #1794
Closed

When using refinements, unsupported type appears in JSON but not in HTML #1764

bporterfield opened this issue Jul 11, 2024 · 0 comments · Fixed by #1794

Comments

@bporterfield
Copy link
Collaborator

bporterfield commented Jul 11, 2024

What happens?

Some fields that are of unsupported type (uuid in postgres, in this case) will show up as a column in a query, as expected. However, when using refinements and adding an existing view, the fields appear in the JSON response but do not appear in the HTML.

    view: chat_detail is {
        group_by: 
            `chat id` is id,
            model_message_text, 
            chat_date, 
            `user name` is user.name,
            user.email
    }

Running the view above shows "chat id" as a column. However, running the query below does not show "chat id" as a column:

run: chat -> { 
  where: 
    user.name = 'Ben',
} + chat_detail

When running this, chat id is not shown in HTML, but it does appear in the JSON response:
Screenshot 2024-07-11 at 9 13 59 AM

Screenshot 2024-07-11 at 9 13 35 AM

However, if I change chat id definition in the view to:

`chat id` is id::string,

Now chat id appears in the HTML response as well as JSON

To Reproduce

see above

OS:

macOS

Malloy Client:

local VSCode

Malloy Client Version:

latest

Database Connection:

Postgres

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
1 participant