Fatias Member

Comments

  • @GrantSmith , @ArborRose thanks for the replies. I may not have been fully clear so I have edited the question with images. We have two values selected for the same column\filter and we need to open the dashboard with all those values that are selected. But it only passes one of the values.
    in Using pfilters with more than one value Comment by Fatias January 25
  • Thanks for the reply @AndreaLovesData , that was helpful!
    in Is it possible to make a HTTP request using the Python Script tile of Magic ETL? Comment by Fatias April 2023
  • We were able to solve the issue: we have changed the format settings in the Registry Editor by going to HKEY_USERS\.DEFAULT\Control Panel\International and there we have changed the values for the needed strings. Notice that we needed to change in HKEY_USERS to affect all the server. When we were changing the region…
    in Workbench - Preview Schema Data Type Error Comment by Fatias June 2022
  • Thanks @GrantSmith it worked very well!
    in Workbench - Different jobs ID when importing Comment by Fatias June 2022
  • Thank you @GrantSmith for the documentation. In fact that is what we are already doing, but since the PoP charts can be set up so quickly we thought we could simplify some of our developments. Guess we will have to wait for future product enhancements.
    in Period over Period - Specific Date Field instead of Current Date Comment by Fatias June 2022
  • @GrantSmith we have just tried the swap-owner command in JavaCLI and it moved everything for the new user (which was nothing because the user we want to delete does not have anything) and we still can't delete it. Maybe the API suffered some changes, we followed the documentation here:…
    in Delete User API Comment by Fatias September 2021
  • Thanks @jaeW_at_Onyx I was doing the same procedure in Python but probably had some typo because I copy paste your endpoint and the other text and it is working now! Just a side note: we have our Domo instance connected with our identity provider to allow Single Sign-On (SSO) and we noticed that the password that works…
    in Domo instance API - Method Not Allowed Comment by Fatias July 2021
  • @MarkSnodgrass thanks for your feedback, it is good to know that we can use stored procedures in the query window. However, in this case the value that I want to pass to the dynamic variable comes from an external source and that's why I was wondering if it would be possible to read (select) that value from a csv file to…
    in Workbench ODBC - Dynamic query/parameter Comment by Fatias July 2021
  • @jaeW_at_Onyx Thanks for letting me know that MySQL version in Domo is MySQL 5.6 I had followed that query example you sent for the 5.6 version and it definitely works when the parent_id < id. However in my use case, I have records in which the parent_id > id so I guess I'll have to stick with the while loop for now. I…
    in Is it possible to do CTE hierarchical recursive query in MySQL? Comment by Fatias March 2021
  • I believe that would work if everything belonged in the same hierarchy. However, if you have different hierarchies how do you distinguish them? For example, with the table below, your query would bring all the relations including the 30 and 31 which are not related with the id=19
    in Is it possible to do CTE hierarchical recursive query in MySQL? Comment by Fatias March 2021
Avatar