User Trigger

0 views
Skip to first unread message

Cary Polachek

unread,
Aug 3, 2024, 5:48:10 PM8/3/24
to blownalhoso

However, I just observed that this database trigger is getting triggered even when anonymous users are getting created e.g. when non logged in users come to the website and browse or when a user logs out etc.

Boston85719 is an expert Bubbler with a decade experience as an educator. Real name Matthew, he has been actively building SaaS apps, marketplace apps, scheduling apps and more for clients, himself and for sale as templates.

Just as a little side note I'm not convinced of the need to do this in a trigger. It would be better if you created a package with drop_user and create_user procedures that do everything you want in one place rather than disguising the logic in a trigger.

You cannot create triggers on statements (DDL or DML, except on some system level statements found here). Triggers can only be created on tableson a database. In your question, drop user ; is a statement.

I am looking into ways to configure an automation using Actions, Rules or Hooks that would trigger based on an update of user and/or app metadata attributes. Idea is I would like to fire a notification to a 3rd party system that the user profile has been updated, with or without the updated metadata as part of the payload.

I looked at Actions triggers, but none seem to be the right one. Hooks seem to follow the same triggers. Rules on the other hand, while a legacy feature, seem to be completely customizable, and thus a possible solution.

Hey all I know you can log events in Automation for Jira using the smart values but I was wondering if there was a way to log the user who hit the manual trigger button? I know you can limit it to individual groups but I would like to log the user doing that action since all the actions only show "Automation for Jira" updating the issue based on manual trigger.

When a user doesn't exist in the user pool at sign-in with a password, or in the forgot-password flow, Amazon Cognito invokes this trigger. After the Lambda function returns successfully, Amazon Cognito creates the user in the user pool. For details on the authentication flow with the user migration Lambda trigger, see Importing users into user pools with a user migration Lambda trigger.

One or more key-value pairs that contain the validation data in the user's sign-in request. To pass this data to your Lambda function, you can use the ClientMetadata parameter in the InitiateAuth and AdminInitiateAuth API actions.

One or more key-value pairs that you can provide as custom input to the Lambda function for the migrate user trigger. To pass this data to your Lambda function, you can use the ClientMetadata parameter in the AdminRespondToAuthChallenge and ForgotPassword API actions.

This field must contain one or more name-value pairs that Amazon Cognito stores in the user profile in your user pool and uses as user attributes. You can include both standard and custom user attributes. Custom attributes require the custom: prefix to distinguish them from standard attributes. For more information, see Custom attributes.

To reset their passwords in the forgot-password flow, a user must have either a verified email address or a verified phone number. Amazon Cognito sends a message containing a reset password code to the email address or phone number in the user attributes.

Required if you configured your user pool with alias attributes in addition to username for sign-in, and the user has entered an valid alias value as a username. This alias value can be an email address, preferred username, or phone number.

If the request and the user pool meet the alias requirements, the response from your function must assign the username parameter that it received to an alias attribute, Also, the response must assign your own value to the username attribute. If your user pool doesn't meet the conditions required to map the received username to an alias, then the username parameter in the response must either exactly match the request, or be omitted.

You can set this parameter to CONFIRMED to auto-confirm your users so that they can sign in with their previous passwords. When you set a user to CONFIRMED, they do not need to take additional action before they can sign in. If you don't set this attribute to CONFIRMED, it's set to RESET_REQUIRED.

A finalUserStatus of RESET_REQUIRED means that the user must change their password immediately after migration at sign-in, and your client app must handle the PasswordResetRequiredException during the authentication flow.

Amazon Cognito doesn't enforce the password strength policy that you configured for the user pool during migration using Lambda trigger. If the password doesn't meet the password policy that you configured, Amazon Cognito still accepts the password so that it can continue to migrate the user. To enforce password strength policy and reject passwords that don't meet the policy, validate the password strength in your code. Then, if the password doesn't meet the policy, set finalUserStatus to RESET_REQUIRED.

You can set this parameter to SUPPRESS to decline to send the welcome message that Amazon Cognito usually sends to new users. If your function doesn't return this parameter, Amazon Cognito sends the welcome message.

You can set this parameter to EMAIL to send the welcome message by email, or SMS to send the welcome message by SMS. If your function doesn't return this parameter, Amazon Cognito sends the welcome message by SMS.

If you set this parameter to TRUE and the phone number or email address in the UserAttributes parameter already exists as an alias with a different user, the API call migrates the alias from the previous user to the newly created user. The previous user can no longer log in using that alias.

Set this parameter to true to require that your migrated user complete SMS text message multi-factor authentication (MFA) to sign in. Your user pool must have MFA enabled. Your user's attributes in the request parameters must include a phone number, or else the migration of that user will fail.

With multi-project pipelines the user triggering the pipeline in Project B needs to have permissions sufficient to trigger the pipeline in Project A, in your example, for it to work. So those users would still need at least Developer permissions in both projects.

The second three warnings are probably because you have some outdated bindkey definitions for the IC5141 waveform tool (which used the tool name "awv"), which is not present in IC615. So you probably have some functions:

In my earlier post in this thread, I included a link to another post which suggested that these are probably coming from a call to deUnRegUserTriggers() in a context file loaded from the .cdsinit. It's unlikely that they're in the bindkeys - unless there's a call to this function in leBindKeys.il or schBindKeys.il - which seems unlikely.

The warnings are benign - although it is bad practice of the PDK to be unregistering the de triggers. This has been shown to break certain tools because they depend upon these triggers. In ancient history (IC446 and before) there used to be a limitation that you could only have one user trigger defined - but this was fixed over 10 years ago. So you really ought to contact IBM.

Oh, hang on - you were asking about the "awv" messages (I got confused because you posted about the other warnings in another old thread). The awv warnings must be coming because of a call, somewhere, to an hiSetBindKey on "awv". You'll just have to hunt it down!

Try running "virtuoso -nocdsinit" and then gradually load the files loaded from the .cdsinit - or comment out pieces of the .cdsinit and see the effect. Again, the warnings won't cause any problems in practice.

You're right. The .cdsinit call the bindkeys which are defined by pdk. And they conflict with Cadence bindkeys definition. I removed that code in .cdsinit file and the warning go aways. However, I think these warnings also cause problem. Before I fixed them, I could not see the properties of components (when I pressed "Q", I saw some paramters, but look like not enough). After I fixed, the properties of components look normal.

At first, I go to Option -> Bindkeys and I saw more than 200 bindkeys for schematic. I read the .cdsinit file again. And I found other codes load the bindkeys which are defined by pdk. I removed them. And the warnings go aways. Now, bindkeys for schematic are more than 100!

No, I meant that the warnings didn't have anything to do with the change in behaviour of the "Q" bindkey. That seemed a bit unlikely, unless they have a different definition of the Q bindkey which brings up a different property editor. Hard to tell without seeing the problem.

I want to explain more detail about my problem. Before I fixed it, in a schematic, I chose a component A. When I clicked to device B, both devices are chosen (A and B, (similar to CTRL is hold)). So I though some hotkeys may conflict together. Therefore I removed some codes in .cdsinit. On the other hand, I saw the properties pop-up windows is different with photos in document. After I fixed, it almost looks ok.

IBM PDKs have some rather unusual bindkey choices (for some odd reason). First of all, each click is an incremental selection. It's possible that their Q bindkey calls a different function (turn on the Options->Log Filter and click all the checkboxes, and see what SKILL function gets called when hitting Q in the case with IBM's bindkeys and the standard Cadence bindkeys).

I want to take fields and custom fields in the user account form and use them to search a CMS (that has the user profile in it) and update, or create new, the profile CMS with data from the custom fields. Why cant I use the user membership account to trigger this flow and is there a work around?

I'm using this topicname v2.detail.events.conversation.id.user.start in inbound call for my triggger.
The behavior is ok but the trigger fires when the alert segment is started. Is there a way to start the trigger only when the agent accepts the interaction instead when he is alerted?

c80f0f1006
Reply all
Reply to author
Forward
0 new messages