Hi @Greeshma_Sampath1,It depends on the data type of the field on which you are doing this operation. Incase you are sure about the values/ any queries result then i would suggest you can convert your field to appropriate data type through enrichment activity & get the expected comparison values.
Hi @Urs_Boller , Not sure below links will help but you can have look at them and some linked pages for integration etc.https://experienceleague.adobe.com/docs/campaign-classic/using/sending-messages/sending-push-notifications/about-mobile-app-channel.html?lang=en
Hi @xliu - Most of the activities in adobe creates the temp table which helps us to see the results. But the SQL code activity does not create any such temp table during execution which might be the reason you are not able to see the result.
HI @Greeshma_Sampath1 - The error mentioned by you says that you don't have the correct right to perform this task. I would request you to get in touch with your support team to check once again your rights.
Hi @nannetter771416 - Could you please elaborate more on the transactional message.If you are looking for something specific related to profile the it must be shown. It would be easier for us to explain you if you can elaborate what you are looking for
That's all right! I hope the support team gets you the correct answer. Usually for these cases file/log helps to dig more on the issue but i know we can't share any client information here. Hope you get the resolution soon and let me know too about it. Thanks
Hi @icoggin - Could you try to change the datatype of that column to integer as the values and datatype is string. Give a try incase this works for you. You can change the format by 1.Click on the change the file format 2. Then change the datatype of the field from this drop downThanks