![]() ![]() In fact it’s pretty clear that the documentation suggests users to view the phplist email accounts record. That is referring to the uniqid column.īut how would anyone know that unless they opened the mysql database which is not suggested in the “Evaluating Conditions” with regex, tutorial. When composing a campaign, the drop-down list on the Segment tab has “Subscriber unique id”. There is nothing called “Subcriber ID” in a user’s record. And yet if an admin actually opens the phplist record for an email user (see image id.png4 ) and since the documentation only states “Subscriber ID” we are left scratching our heads wondering which field represents the “Subscriber ID”: is it the field called “Unique ID”, or “UUID” or “ID” (at the top of the record) all of which are different animals from each other. Edit March 2022 Note that using this method only a few characters change in the uuids, which make them look identical at a glance, but actually they're all different. So a simple UPDATE orderlineitems SET uuid uuid () should assign each uuid field a unique value. Let’s start with the pair: UUIDTOBIN/BINTOUUID. 1 Answer Sorted by: 12 Each call to uuid () returns a different, unique value. These will ease the work with UUIDs and will provide a solution around the issues mentioned above. Great! When using the drop-down selection there are two choices about ID’s: “Subscriber ID” and “Subscriber Unique ID” both of which presumably use regex. Solution: With these problems in mind, we added three new functions: UUIDTOBIN, BINTOUUID, ISUUID. This selects subscribers whose id ends in 0 or 1, which will select approximately 20% of subscribers. "Or to select an arbitrary 20% of subscribers using the subscriber id field the target value could be $. In the “Evaluating Conditions” paragraph it states. If you generate them randomly, then the probability of collision. When stored as a string, UUIDs require no. One is lifted from plugin:segment and it states, when trying to drill down into a specific user or users, the admin can use regex. UUIDs are generally not guaranteed to be universally unique. Perhaps the easiest way to store a UUID to a database is to create a char(36) column and store the UUID as a string.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |