Hi Mark,Thanks for the update. I shall create said ticket.
Hi @Jeroen van den Belt,I unfortunately have not had enough time to try out the solution suggested by Tim.But, I did come across one issue.I tried changing the credentials in IIS pool for Indicium (client) but since the login requires the domain of the user. It seems impossible to register the same user (with same domain) for the SSRS server on my side.And what if I host the GUI & Indicium on an App Service?
Allright, I will try this out and get back to you. Thanks!
I edited the url and forgot the extra “/”. But the original url does not has typos. I verified this by copying the link to another tab and it worked perfectly.
Hi Tim,For testing/dev environment I would use 1 IAM and 1 reporting service. But for production these may be different IAM and reporting services.I added a `ssrsssrsreportserver` extended property like advised in the previous topic. But when I want to print, I get the following error:2023-07-11T15:00:44.2699967-03:00 40000061-000b-fa00-b63f-84710c7967bb [ERR] An unhandled exception occurred while processing the request. (ffba027a)Prockees.Bootstrapper.ExecutionException: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.”Any ideas?
But then it would mean that all the prefilters will be hidden when adjusting the screen type. Which is not what I want. Why am I doing it this way?Well, I need a filter form for dates in Universal GUI (which is not supported. Only supports text and numbers). So now I created a task for the user to enter a date for the filter, which will be picked up by the prefilter (activate prefilter using process flow).
I would like to point out that I also ran into this problem since after upgrading SF to 2023.1. However not in every model (project).
Allright. Thanks for clearing that up!
It worked!I changed the file_data task parameter to varbinary(max). And with the code below, I am able to continue my logic with the xml data saved in @xml_table. drop table if exists #tempcreate table #temp (col varchar(max) collate LATIN1_GENERAL_100_CI_AS_SC_UTF8)insert into #temp @file_datadeclare @xml_data xml = (select convert(xml, col, 2) from #temp)declare @xml_table table ( name nvarchar(200) , searchcode nvarchar(50))insert into @xml_table ( name , searchcode) select row.value('./name[1]', 'nvarchar(200)') ,row.value('./searchcode[1]', 'nvarchar(50)') from @xml_data.nodes('/accounts/account') as c(row)-- testing purposes onlydeclare @message nvarchar(max)set @message = concat('<text>', (select top 1 name from @xml_table), '</text>')exec tsf_send_message 'warning_msg', @message, 0Thanks guys!
Well, based on the answer of Vincent about encoding, I use the answer given. There N’this_is_some_string’ converts to string to nvarchar instead of varchar, so I convert my variable to nvarchar for the insert query. I converted back to varbinary so I could use the variable @xml_data as actual xml instead of varchar (text)
After trying this, I still can’t seem to get it to work.Here’s what I’ve got:this is my code behind my task (removed the process flow) [tabl].[tabl_blob] is a column that accepts VARBINARY(MAX) now when running a query to see what is saved I get the following: the first row is from tabl_id = 2 Also, the message still return anything. Am I still doing something wrong?
Hey @Mark Jongeling,I’ve tried but without success unfortunately.Here’s what I’ve got.a task where the file would need to be selected domain is just a database file upload a process flow which is triggered when the task is executed (design img. 1) - process variable (pv): file_data = task param file_data [output] - use pv file_data as input in “Read disk file” (see img. 2) - set “Read disk file” [output] to pv file_data (see img. 3) img. 1img. 2img. 3 a Task control procedure for debug purposes img. 4 (line 18 can be ignored as I do not not that)What do I expect?Well with this task I want the use to select a file which has a specific XML structure so I can use the XML data to run some SQL queries (i.e.: INSERT INTO ...) For now, I expect at least one company name to return in a message (img. 4).But the message I get is just empty. If I remove the query on line 35 and use some dummy text instead, I do see that dummy text, which means that the select query does not return anything.Also,
Sorry, but I haven’t had the chance to try it out yet.
Allright, I’ll try this out and get back to you. Thank you
Hi Marvin, I have tested this with some dummy code and does work! Thank you!Although the automatic download is not achievable (as far as I tried), but I can at least generate a .xml file.
I am currently using GUI version 2022.1.13
Hey Mark,I was able to get it working like I wanted with a workaround involving process flow and decisions. But I also think it would be really handy if the first method was also a valid option. I think I will create a idea for this.Thanks
I have yet to upgrade my Universal GUI
You may be right. My current Universal GUI version is 2022.1.13 b1.0. I will update this and see if it continuous. Thanks!
I see I have Universal gui version 2022.1.13 b1.0
In my case the background color is on the whole row (not a specific column). Because of this the gray color is not showed when selecting.the first 3 records are selected
I would like to keep my conditional background colors. So maybe an idea to show selected records with a border color?
Just checked and is indeed Delete for Strategy.This is what I have based on your code given above. I added “insert_user” & “insert_date_time” to make this record unique, but does not seem to work
The code for the conditional layout did work!But, I do have a error that comes when generating the definition. It says that the record already exist and duplicate is not applicable. I think this is because I generate the same version. But how can I make this possible? So I don’t need to upgrade to a newer version (just because it takes a lot of time for a complete version upgrade)?
In which format should the color be?
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
