Visual WSJF tool

Got a LiveCode personal license? Are you a beginner, hobbyist or educator that's new to LiveCode? This forum is the place to go for help getting started. Welcome!

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller

Post Reply
ErwinV
Posts: 4
Joined: Tue Feb 18, 2014 4:39 pm

Visual WSJF tool

Post by ErwinV » Tue Jan 08, 2019 11:57 am

Hi all,

I want to create a tool that allows me to import JIRA records, select a WSJF element (BV, TC, R/O or JS) to work on and drop them as a 'post-it' on a page with columns.
The post-it shows some info from the imported record like e.g. its title, WSJF and elements,...
Each column on the page represents a numeric value that could be used for said element. If the element already has a value, then the post-it drops in the corresponding column. Else it drops in a 'landing zone'.
From the landing zone, the user can drag the post-it to the column that represents the value that the user wants to assign to the element.
This principle works for each element type.
In a pane on the left-hand side, all records are displayed ordered by calculated WSJF value (real-time).
Is LC able to support easy creation of such an interface? I'm a low-code lover but never tried LC before on a real project.

Thanks, Erwin

MaxV
Posts: 1579
Joined: Tue May 28, 2013 2:20 pm
Location: Italy
Contact:

Re: Visual WSJF tool

Post by MaxV » Tue Jan 22, 2019 2:30 pm

Jira is proprietary a bug tracer software. It run locally, on a PostGre/MySQL database, so the short answer is YES.
Livecode natively support MySQL/PostGre databases.
Livecode Wiki: http://livecode.wikia.com
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w

ErwinV
Posts: 4
Joined: Tue Feb 18, 2014 4:39 pm

Re: Visual WSJF tool

Post by ErwinV » Wed Jan 23, 2019 9:29 am

Hi Max, I was aware of that but I didn't clearly formulate the extent of my question.

I'm more concerned about the effort required to create the drag/drop user interface that creates post-it notes for a value imported from JIRA.
Kind of similar to the way one can manipulate entries on a digital Kanban board.


Given my lack of coding experience, I'm kind of scared about the learning curve.

MaxV
Posts: 1579
Joined: Tue May 28, 2013 2:20 pm
Location: Italy
Contact:

Re: Visual WSJF tool

Post by MaxV » Wed Jan 23, 2019 1:52 pm

Connection to database is very easy: https://livecode.wikia.com/wiki/MySQL
Drag and drop is very simple (there is the translate button of the page on top right): https://livecodeitalia.blogspot.com/201 ... rni_8.html

All the rest is just SQL queries and a very little of Livecode programming.
Livecode Wiki: http://livecode.wikia.com
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w

Post Reply

Return to “Getting Started with LiveCode - Complete Beginners”