Chandrakumar

Hi I am getting below error when setting mysql connection An error occurred liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/changelogs/5.3.xml::2:🎨 Reason: liquibase.exception.DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PARALLEL VARCHAR(100) NULL, ADD PARALLEL_PER_MINUTE INT NULL, ADD PARALLEL_DURAT' at line 1...

How to add in conduction with multiple filer as parameter ? Attached screen will share you more details.

Hi, I installed ART with MYSQL, I would like to know how to add basic user and user group data in mysql DB? I am getting error as attached when adding new user. Thanks, Chandru

Hi, I would like to know how to add basic user and user group data in mysql DB?

I am not able to see place where we can define column name. [image: image.png] On Thu, Jan 21, 2021 at 7:14 PM Timothy Anyona tanyona@users.sourceforge.net wrote: Replace and a.store_no in #rules# with and #rules# and then define a rule for that report where the column name is a.store_no and then define the rule values for each user/user group who will run the report. Dynamic filter based on user. Sent from sourceforge.net because you indicated interest in < https://sourceforge.net/p/art/discussion/352129/>...

Kindly find the query source below select store_code Store,region_name Region,a.Created_Date Invc_Date,Invc_no,ITEM_POS,Item_no Item#,Description1,alu Model#,udf_7 as Brand,udf_8 as Gender, sum(b.qtyMODIFIER) SoldQty,sum(orig_priceMODIFIER) OrgPrice, sum((round((priceb.qty)-(((priceb.qty)/100) round(disc_perc,3)),2))MODIFIER) SellingPrice from invoice_v a left join invc_item_v b on a.invc_sid=b.invc_sid left join INVN_UDF_V c on b.item_sid=c.item_sid left join inventory_v iv on b.item_sid=iv.item_sid...

When I use #rules# in report it is replaced with 1=1 in the query. Eg [image: image.png] In query it is replaced with 1=1 [image: image.png] On Tue, Jan 19, 2021 at 1:45 PM Timothy Anyona tanyona@users.sourceforge.net wrote: Perhaps you could explain a bit more or give a specific example. Dynamic filter based on user. Sent from sourceforge.net because you indicated interest in < https://sourceforge.net/p/art/discussion/352129/> To unsubscribe from further messages, please visit < https://sourcef...

Hi, Thanks for that, I also like to know if it is possible to use username as a filter in the report? Thanks, Chandru On Fri, Jan 15, 2021 at 11:00 AM Timothy Anyona tanyona@users.sourceforge.net wrote: Hi, One of the options I can think of is using the Rules feature. Another option is to use dynamic sql feature and check the :username: tag and return the appropriate query to use. Dynamic filter based on user. Sent from sourceforge.net because you indicated interest in < https://sourceforge.net/p/art/discussion/352129/>...