Dear All I am creating a program rule to develop a UID for the patient. I have currently created a program rule using d2:concatenate to bring various attributes and DEs together into the Unique ID (such as date and OrgUnit code). However, I would also like to include sequential numbering after this to ensure that more than 1 case can be registered on a single day. I have looked through all of th…

Hi Terence, Should be possible using CALCULATED_VALUE. Program rule variable having source type as CALCULATED_VALUE will get its value assigned by some other program rule. Try these steps create program rule variable of source type CALCULATED_VALUE // Let say “auto-increment” create program rule with Program Rule Action as Assign Value and select variable created in step 1 and assign it “#…

Hi Terence Please have a look at textpattern to generate UID’s: https://docs.dhis2.org/2.29/en/user/html/working-with-textpattern.html This is available as of 2.29 and believe it should be able to generate what you need. Nick ▶ ···

Dear Zubair Thank you for your rapid response. I have attempted to do this without success. I think I am misunderstanding. I created the program variable "auto-increment’ as suggested In this step - is this a new program rule? I created a program rule as follows: “d2:hasValue #UID”, Assign “#auto-increment + 1” to field “auto-increment”. I then set this as priority 2. I created my UID pr…

Hi Terence, There could be many reasons for that. Have you tried implementing what Nick suggested? The only limitation is that the TextPattern option is only available for TEAttribute and not to DataElement. ▶ ···

Hi Zubair Unfortunately, I am running 2.28 at the moment and therefore cannot do what Nick suggested. I will have to look into upgrading in any case, so I think that may be the best option for now. Thank you again for both of your help - I really appreciate it! Kind regards, Terence ▶ ···

Dear Zubair, Nick I have upgraded the instance to 2.30 now and am attempting to once again implement the sequential numbering using the TextPattern option. I am using it on a TEAttribute, but have not had any success. Thus far, my Defined program rule action looks as follows: d2:concatenate( V{enrollment_date}, ‘-’, V{orgunit_code}, ‘-’) This is currently working and generating the UID, but of…

Hi Terrance, Sometime back I read about this. I think you need to use the expression like ORG_UNIT_CODE(…) + "-" + CURRENT_DATE(yyyyww) + "-" + SEQUENTIAL(#####) Instead of using the function concatenate. Please refer the below link for more details: https://docs.dhis2.org/master/en/user/html/working-with-textpattern.html Hope this helps. Thanks and regards MSP ▶ ···

Hi MSP Thank you for the suggestion. I have also attempted this and was unable to have any success. I tried to create a new rule with simply having “Sequential(###)” alone, and did not have any success either. Therefore, I assumed that there would be some sort of additional text that is required to make it work. Kind regards, Terence ▶ ···

Hi Terence This textpattern applies to generating unique tracked entity attributes. So if you make the attribute unique and then system generated you can enter the pattern accordingly: [image] ▶ ···

Dear Shurajit Thanks for the advice. This worked fantastically - however, the documentation is a little confusing with regards to the required format. Is there somewhere where I can possibly make suggestions for clarification? The string that eventually worked under the Auto-generate section is as follows: CURRENT_DATE(yyyy-MM)-“-”-ORG_UNIT_CODE(…)-“-”-SEQUENTIAL(####) The ‘+’ did not work for…

DHIS2.org
Documentation
Developers
Demo
Apps
Academy

DHIS2 Community

Generating sequential numbers in program rule

Support - Assistance technique

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled