[SOLVED] Auto Action for Managing Connections: database trigger

Don't you just hate it when you have something solved and then have to come back an re-post. Moving on:

I have the CB Query Plugin,

Created a query field and query with settings shown in screenshot.




2 items:

1. can I use [user_id] in the query?
2. I don't see the field in _comprofiler. Guessing I need some trigger to populate the field?

Many thanks for the help.

Your image didn't attach so no idea what your configuration is.

1. can I use [user_id] in the query?

Yes.

2. I don't see the field in _comprofiler. Guessing I need some trigger to populate the field?

Query fields do not exist in database. They are calculated fields. You can not adjust them or store them like a normal field.

You answered my question. Just posting image for anybody else who might benefit from this post:

This is falling into the category of "all great things are worth working for".

Ok, I have two query fields:

1. Event Creator Query: returns the event_id of events created by User Group: Event Creator
2. Athlete Registration Query: returns the event_id of Athlete's registered events

I was hoping thru a auto action to have (on Profile Display) the Athlete and/or Affiliate connect Users who have one Event Creator Query AND Athlete Registration Query match.

Unfortunately, I got to the Auto Connect form and see

Users field: "Input comma separate list of user ids to connect user to."

screenshot:


totally stumped and I know you are likely out for the weekend. I will keep researching and post back if I don't hear from anybody til Monday :silly:

You answered my question. Just posting image for anybody else who might benefit from this post:

Your query is incorrect and your where statement is backwards. Please Try the below (avoid unnecessary linebreaks).

totally stumped and I know you are likely out for the weekend. I will keep researching and post back if I don't hear from anybody til Monday

You first need to add your conditionals to the auto action. These can be substitutions or straight values. Example as follows

[cb_query] Greater Than 0

Once you've your conditions setup you need to give it the user id of who you want the user to connect to. This is specifically where the query field that gives you the user id comes in and you'd supply such a field with a substitution (e.g. [cb_queryfield]).