Append Character to Account Name Rule and Iterate By it Using Basic Config

[ajmakowsky]

Using the Basic Config of Account Name Rule for an endpoint, is there a way to add logic to append a specific alphabetic value to the end of the account? Or only using advanced query?

[rushikeshvartak]

You need to use advanced query

[ajmakowsky]

Thanks. Is there a way to dynamically iterate by an alphabetical character for uniqueness? Let's say the account name rule needs to end with "A". If that specific account name is taken, we need to end with "B" instead, and so on and so forth. Can I do this without appending a "#" 25 times with the same logic besides the different letter?

[rushikeshvartak]

You need to # keyword

[ajmakowsky]

Ok, this brings up a new issue. Originally we were using the basic config, where one of the user attribute values is sometimes null. If the attribute value was null, using basic config, it simply skipped that value. When I try to use the same logic in advanced query, and then request an account for a user, it pops up a window that says "Enter the name of the account you need to access."

How do I account for potential null attribute values using advanced query?

[rushikeshvartak · Accepted solution]

use ifnull condition of SQL query